Michael Stevens wrote: > The above give me the following error: > Syntax Error: SELECT acct_id, date_ascii, invoice_num, order_num, item_code, > stock_code, main_line, qty, ink_1, ink_2, ink_3, ink_4 FROM "QInvHisDetail" > WHERE main_line CONTAINS<< ??? >> 'Mike' ORDER BY date_ascii DESC > > If I change CONTAINS to LIKE it does not error out but it produces no output > other than the table row of headers.
CONTAINS may be a Database Management Specific SQL command and is sounds like your current database does not support it. When you change it to the more universal LIKE you no longer have a syntax error but you now have a logic error because you do not have any wild card characters in your string for LIKE to work with. Give this a try: WHERE main_line LIKE '%#cookiemainline#%'. I would think that is relativily equivalent to the CONTAINS logic. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304100 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4