Scott CF is funny with where it says your errors are in the error display. I would be looking at the line below it
DATE is a reserved SQL word, so you have to escape the column name Try SELECT * FROM #arguments.qDataSet# WHERE [Date[ BETWEEN A AND B etc.. Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9444 7504 http://www.domainconceptdesigns.com <http://www.domainconceptdesigns.com> ("If you think it can't be done, you haven't asked me!") - Steve Onnis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Barnes Sent: Sunday, March 16, 2003 7:17 PM To: CFAussie Mailing List Subject: [cfaussie] Query a Query and Dynamic FROM I am using a Query on a Query Result, but i want to feed the "querys name" through a CFC. I push the Queries Recordset into the CFC, which works, but when i do: [CFQUERY dbType="Query"] SELECT * FROM #arguments.qDataSet# WHERE Date BETWEEN A AND B etc.. [/CFQUERY] If for some reason won't recognise the "qDataSet" variable. I have tried methods like Evaluate() or using "[]" around the variable and still nudda. Inside the CFC, if i reference qDataset.recordcount it infact returns the total records and if i do a cfdump on that variable, it also recognises it as a query... I'm outta solutions on this one! :D --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
