Without seeing the error message, you may need a preservesinglequotes
around the quotedvaluelist in the second query.
Lon Lentz
Applications Developer & CyberEntomologist - Alvion Technologies
DataWarehousing and List Sales - Market Your Lists on the Net!
[EMAIL PROTECTED]
941-574-8600 Ext. 210
At 11:40 AM 5/31/2001 -0500, Tracy Bost wrote:
>The code below throws an error whenever I try to run it... What am I doing
>wrong ?
>
> Thanks in Advance...
>
><CFQUERY name="getproducts" datasource="SQL7DATABASE" >
> SELECT partnumber
> FROM products
> WHERE manufacturer_id = 4
> </CFQUERY>
>
><CFQUERY name="getstuff" datasource="ACCESSDATABASE">
> SELECT item_id
> FROM inv_mast
> WHERE partnumber NOT IN(#QuotedValueList(getproducts.partnumber)#) AND
> manufacturer_id = 4
> </CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists