You must tell us the exact SQL that occured after the IFs and etc. ran by response.writing it ala http://www.learnasp.com/learn/sqlwrite.asp Tell us what the full string is that it was getting error on.
On Apr 3, 2005 10:07 PM, floorbamboo <[EMAIL PROTECTED]> wrote: > > i'm trying to build a search engine that seeks keywords from the DB. > When i enter just one word, this script works fine, but when i enter > two or more words, i get a syntax error. pls help me correct this > script. > > For i = 1 to WordCounter > If SType = "AllWords" Then > If i <> WordCounter Then > strSQL1 = strSQL1 & " LIKE '%" & Word(i) & "%' AND " > ElseIf i = WordCounter Then > strSQL1 = strSQL1 & " LIKE '%" & Word(i) & "%' " > End If > ElseIf SType = "AnyWord" Then > If i <> WordCounter Then > strSQL1 = strSQL1 & " LIKE '%" & Word(i) & "%' OR " > ElseIf i = WordCounter Then > strSQL1 = strSQL1 & " LIKE '%" & Word(i) & "%' " > End If > End If > Next > > strSQL = "SELECT * FROM articles WHERE Keywords" & strSQL1 & " ORDER > BY ArticleDate DESC" > > When i use two or more words, i get this error: > > Error Type: > Microsoft JET Database Engine (0x80040E14) > Syntax error (missing operator) in query expression 'Keywords LIKE > '%trade%' AND LIKE '%agriculture%''. > /owinfs/tests/searchalltry.asp, line 175 > > > Thank you. > > > > > ________________________________ > Yahoo! Groups Links > > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
