Did we all know you can't do this?

In other words the following does not work.

<cfquery name="query" dbtype="query">
SELECT *
FROM this.data[key] <!--- A structure of queries --->
WHERE CSV_RANK > 0
</cfquery>

But the following does work.  Interesting isn't it.

<cfset temp = this.data[key]> <!--- again, a structure of queries --->
<cfquery name="query" dbtype="query">
SELECT *
FROM temp
WHERE CSV_RANK > 0
</cfquery>

Ok, maybe not so interesting, but I fought with this way to long on a
Friday.

Cheers

--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:  This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to