Re: Is this an Access limitation ?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this an Access limitation ?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Is this an Access limitation ?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Is this an Access limitation ?
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: 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 Firstly, what datatype is PartNumber in Access? If it's a number, then use ValueList(PartNumber) rather than QuotedValueList(PartNumber) If it's not, put the SQL to the display before you run the SQL to make sure it should run - try it in Access if needs be Also, check the getProducts.RecordCount - if it's 0 then the SQL will break no matter what database engine you throw it at... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
RE: Is this an Access limitation ?
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
Re: Is this an Access limitation ?
Thanks for the help. I was too quick to blame it on access, but if I looked at the error just a little bit better I would have seen that the field partnumber didn't exist on the access table.. blah - Original Message - From: Philip Arnold - ASP [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 1:07 PM Subject: RE: 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 Firstly, what datatype is PartNumber in Access? If it's a number, then use ValueList(PartNumber) rather than QuotedValueList(PartNumber) If it's not, put the SQL to the display before you run the SQL to make sure it should run - try it in Access if needs be Also, check the getProducts.RecordCount - if it's 0 then the SQL will break no matter what database engine you throw it at... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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
RE: Is this an Access limitation ?
Could it be that you need to 'PreserveSingleQuotes()' in the SQL statement i.e. CFQUERY name=getstuff datasource=ACCESSDATABASE SELECT item_id FROM inv_mast WHERE partnumber NOT IN(#PreserveSingleQuotes(QuotedValueList(getproducts.partnumber))#) AND manufacturer_id = 4 /CFQUERY I've fallen for that more times than I care to remember -Original Message- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: Friday, 1 June 2001 4:08 AM To: CF-Talk Subject: RE: 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 Firstly, what datatype is PartNumber in Access? If it's a number, then use ValueList(PartNumber) rather than QuotedValueList(PartNumber) If it's not, put the SQL to the display before you run the SQL to make sure it should run - try it in Access if needs be Also, check the getProducts.RecordCount - if it's 0 then the SQL will break no matter what database engine you throw it at... Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 Websites for the real world ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ** ~~ 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