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/
