Web Wiz Support and Community Forums : Need help with this sql statement https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 20:07:02 +0000 Mon, 09 Apr 2007 16:45:58 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23076 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Need help with this sql statement : Sorry, last post - I promise....]]> https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121916.html#121916 Author: kpdillon
Subject: 23076
Posted: 09 April 2007 at 4:45pm

Sorry, last post - I promise.  :-)  I basically want to make sure a very specific record does not exist (both the subject and date) not just the subject... Does this SQL statement accomplish that?  It doesn't seem to from what I am seeing..

]]> Mon, 09 Apr 2007 16:45:58 +0000 https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121916.html#121916 <![CDATA[Need help with this sql statement : Just to clarify, the issue I am...]]> https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121912.html#121912 Author: kpdillon
Subject: 23076
Posted: 09 April 2007 at 3:29pm

Just to clarify, the issue I am having is that it is ignoring the Event_date check... In other words, I don't want the post to update unless the subject and date both match...  What seems to be happening is that if the subject matches it won't update regardless if the date is different.]]> Mon, 09 Apr 2007 15:29:04 +0000 https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121912.html#121912 <![CDATA[Need help with this sql statement : I&#039;m trying to write a sql...]]> https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121901.html#121901 Author: kpdillon
Subject: 23076
Posted: 09 April 2007 at 3:48am

I'm trying to write a sql statement where it checks to see if both the subject and date match the subject and date variables respectively... I think I have the syntax correct but not the logic... Can someone tell me what I am doing wrong?
 
strSQL = "SELECT " & strDbTable & "Topic.Subject, " & strDbTable & "Topic.Event_date, " & strDbTable & "Topic.Forum_ID FROM " & strDbTable & "Topic "

strSQL = strSQL & "WHERE ((" & strDbTable & "Topic.Forum_ID = " & intForumID & " OR " & strDbTable & "Topic.Forum_ID = " & intForumIDMovedToNB & ") AND (" & strDbTable & "Topic.Subject LIKE '" & strSubjectNB & "%' AND "& strDbTable & "Topic.Event_date LIKE '" & strDate & "%')); "

]]> Mon, 09 Apr 2007 03:48:43 +0000 https://forums.webwiz.net/need-help-with-this-sql-statement_topic23076_post121901.html#121901