What kind of error? That might help us solve the problem.
DC
----- Original Message -----
From: "Tracy Bost" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 12:40
Subject: Is this an Access limitation ?
> 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
