Regarding your list... CF (or the odbc driver) automatically escapes single
quotes unless pre-empted by a function OR unless you specifiy. So you need
to do either
<CFSET itemlistforquery=ListQualify(ITEMLIST,"'")>
Then use Preservesinglequotes( ) in your query ....
<cfquery name="INSearch2" datasource="#mydatabase_name#" debug>
SELECT PRODUCTID, PRODUCTNAME
FROM PRODUCTS
WHERE (replace(skunumber, ' ', '') in
(#preservesinglequotes(itemlistforquery)#))
OR (replace(smartnumber, ' ', '') in
(#PreserveSinglequotes(itemlistforquery)#))
</cfquery>
Or... and this is easier .....
ListQualify(ITEMLIST,"'")
<cfquery name="INSearch2" datasource="#mydatabase_name#" debug>
SELECT PRODUCTID, PRODUCTNAME
FROM PRODUCTS
WHERE (replace(skunumber, ' ', '') in (#ListQualify(ITEMLIST,"'")#))
OR (replace(smartnumber, ' ', '') in (#ListQualify(ITEMLIST,"'")#))
</cfquery>
.. Either one would work
______________________________________________________________________
Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
