On Wed, Apr 23, 2008 at 11:57 AM, Michael Stevens <[EMAIL PROTECTED]> wrote: > I don't have to play with ColdFusion enough so I may be missing something > pretty simple... The full page can be found at > www.bctarizona.com/searchML.txt > > <cfquery name="lookup" datasource="AR"> > 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 '#cookiemainline#' > ORDER BY date_ascii > DESC > </cfquery> > > 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. > > Now that I'm thinking about it it could be the output loop but I copied and > pasted the whole thing from another page that works. The only thing I > changed was the query name from Recordset1 to lookup and I changed it > everywhere else on the page. > > Anyone see my problem?
WHERE main_line LIKE '%#cookiemainline#%' the % is a wildcard character, so that line will find anything where main_line contains the value of 'cookiemainline' (whatever it may be). -- Evelyn the dog, having undergone further modification pondered the significance of short-person behaviour in pedal depressed, pan-chromatic resonance, and other highly ambient domains. "Arf," she said. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304097 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
