At a glance, those queries look fine. What is the error message?
Avi
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
