Try
<cfset session["dataQuery_" & o[1]] = queryNew("Name, IpAddressNumber,
IdleSeconds, Address, City, State, Zip, Place, PlaceId, BeginTime,
EndTime") />
2008/11/3 Tony <[EMAIL PROTECTED]>:
> nah, two diff
>
> also, whats wrong with my notation in naming the query here?
>
> <cfset session.dataQuery_"#o[1]#" = queryNew("Name, IpAddressNumber,
> IdleSeconds, Address, City, State, Zip, Place, PlaceId, BeginTime,
> EndTime") />
>
> thanks!
>
> -- tony
>
> Better than a thousand hollow words, is one word that brings peace.
> -- siddhartha gautama
>
>
>
> On Mon, Nov 3, 2008 at 11:48 AM, Scott Raley -ITC <[EMAIL PROTECTED]> wrote:
>> Everything on the same box? Cf and sql server?
>>
>> -----Original Message-----
>> From: Tony [mailto:[EMAIL PROTECTED]
>> Sent: Monday, November 03, 2008 11:26 AM
>> To: cf-community
>> Subject: cf question... weird i know
>>
>> if you had 10000 rows for a queryNew() query you were going to
>> construct to store in memory from a cfc to a display layer template
>> but you could logically break that down to 5 queryNew() queries, of
>> 2000 rows each, one for each vehicle in this instance
>> and store them, would you be better off performance wise when displaying
>> them?
>>
>> cause id only need to show 1 of them at a time
>> the other 4 would still just be hanging out in memory
>>
>> if i stored them all id prolly use a query of query to get the data
>> for the individual ones, and then display that new query...
>> on the other hand, i would just be reading its specific query and not
>> making that qofq call.
>>
>> which would be best performance wise of top of ya head?/
>>
>> thanks!
>>
>> -- tony
>>
>> Better than a thousand hollow words, is one word that brings peace.
>> -- siddhartha gautama
>>
>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:278166
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
