yup thats what i ended up with too :) thanks!
-- tony
Better than a thousand hollow words, is one word that brings peace.
-- siddhartha gautama
On Mon, Nov 3, 2008 at 12:04 PM, JediHomer <[EMAIL PROTECTED]> wrote:
> 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:278173
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
