hehe nah, the [] works ie: <cfquery name="qAllotments" dbtype="query"> SELECT * FROM arguments.[qProducts] WHERE allotment_date BETWEEN '#dtCompare1#' AND '#dtCompare2#' </cfquery>
Turns out you have to put arguments.[] instead of [arguments.var] Its all good bud. Scott "Steve Onnis" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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/
