what does the error say? hehe that's the most important part :P
>From: "Tracy Bost" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Is this an Access limitation ?
>Date: Thu, 31 May 2001 11:40:46 -0500
>
>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
