>>.... do you have to loop over your query and add each row to the QofQ >>manually?
well....this QofQ has a special job within a CFC (and if you turn up to the next Bris CFUG I'll hopefully use it as an example in a talk about CFC's...) but yeah, in this case, one at a time.... but you can join an existing QofQ to another query or table (using the where clause for the join not "inner"/"outer") you know about removing rows by querying "where NOT in condition" (or whatever) and using that for the new QofQ, yes? open question for all (reading this thread): what extra's would people like to see in QofQ's? > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Scott > Thornton > Sent: Thursday, 25 August 2005 9:35 AM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Query of Query Problem - Combine two fields > together into one > > > thanks for all your advice guys, I modified the original > query in the end to do what I want. > > But I will keep your solutions in mind for next time. > > One question though: > > With the below method.... do you have to loop over your query > and add each row to the QofQ manually? > > > > Scott Thornton, Programmer > Application Development > Information Services and Telecommunications > Hunter-New England Area Health Service > Phone RNH +61 2 49236066 > Fax +61 2 49236076 > > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 08/25/05 8:41 am >>> > > aye, it's a hack to be sure but if you're stuck with 6.1 > (without cf7's QofQ datatypes) then I can't think of any other way.... > > <cfparam name="variables.qryLockStore" type="query" > default="#queryNew('table_ID,record_ID,transaction_ID,user_ID, > dtExpires')#" /> > > <!--- add a dummy row to preset the QofQ datatypes ---> > <cfset queryAddRow(variables.qryLockStore) /> > <cfset querySetCell(variables.qryLockStore, "table_ID", "dummy") /> > <cfset querySetCell(variables.qryLockStore, "record_ID", "dummy") /> > <cfset querySetCell(variables.qryLockStore, "transaction_ID", > "dummy") /> > <cfset querySetCell(variables.qryLockStore, "user_ID", "dummy") /> > <cfset querySetCell(variables.qryLockStore, "dtExpires", > dateAdd("yyyy", 100, now())) /> > > > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Darryl > > Lyons > > Sent: Thursday, 25 August 2005 8:08 AM > > To: CFAussie Mailing List > > Subject: [cfaussie] Re: Query of Query Problem - Combine two fields > > together into one > > > > > > In the past I've found that creating a dynamic query with the > > first row > > being the "data type" you want the columns to be works best. In your > > example, the first row could contain the "**CHAR**" for the > > column value, > > and then you append the rest of the rows from the query > into the query > > object. In your QofQ you'd just filter out the dummy first row. > > > > Of course, this is all in CF6.1 though... > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
