Does it throw any particular error that perhaps you'd like to share?
On Thursday, May 31, 2001 9:41 AM, Tracy Bost [SMTP:[EMAIL PROTECTED]] 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
