That did it! Thanks very much, sir. --- Charles Carroll <[EMAIL PROTECTED]> wrote: > ah forgot second Keywords ala > > Keywords LIKE '*news*' AND LIKE '*agriculture*' > should be > Keywords LIKE '*news*' AND Keywords LIKE > '*agriculture*' > > ^^^^^^^^^^^ > add this > > On Apr 4, 2005 1:03 AM, flor bamboo > <[EMAIL PROTECTED]> wrote: > > Yes, sir, it is in Access. But the problem > remains. > > Please notice the additional single quote at the > end > > of the error report: > > > > Error Type: > > Microsoft JET Database Engine (0x80040E14) > > Syntax error (missing operator) in query > expression > > 'Keywords LIKE '*news*' AND LIKE > '*agriculture*''. > > > > I'm sure I have no extra single nor double quote > at my > > sql statement, and i can't locate where it's > coming > > from. > > > > > > --- Charles Carroll <[EMAIL PROTECTED]> wrote: > > > SELECT * FROM articles WHERE Keywords LIKE > > > '%agriculture%' AND LIKE '%news%' ORDER BY > > > ArticleDate, DESC > > > > > > ah in Access it is a * not a % > > > > > > SELECT * FROM articles WHERE Keywords LIKE > > > '*agriculture*' AND LIKE '*news*' ORDER BY > > > ArticleDate, DESC > > > > > > would be correct I believe. > > > > > > > > > > On Apr 3, 2005 10:55 PM, flor bamboo > > > <[EMAIL PROTECTED]> wrote: > > > > This is the sql statement that came out: > > > > > > > > SELECT * FROM articles WHERE Keywords LIKE > > > > '%agriculture%' AND LIKE '%news%' ORDER BY > > > ArticleDate > > > > DESC > > > > > > > > > > > > > > > > --- Charles Carroll <[EMAIL PROTECTED]> > wrote: > > > > > 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! Messenger - Communicate > instantly..."Ping" > > > > > > > your friends today! Download Messenger Now > > > > > http://uk.messenger.yahoo.com/download/index.html > > > > > > > > > > > > ________________________________ > > > > 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! Messenger - Communicate instantly..."Ping" > > === message truncated ===
________________________________________________________________________ Yahoo! Messenger - Communicate instantly..."Ping" your friends today! Download Messenger Now http://uk.messenger.yahoo.com/download/index.html 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/
