A Query can be viewed as a structure of arrays, so you're done. :-)
qry_name.col_name[rownumber]
or
qry_name[col_name][rownumber]
So the city from the 10th returned row of a query "getpeople" could be
referenced by
getpeople.city[10]
or
getpeople["city"][10]
Further, you can put queries directly in a given scope as so:
<cfquery name="session.qry_name">
HTH.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: James Blaha [mailto:[EMAIL PROTECTED]
: Sent: Friday, July 18, 2003 10:59 AM
: To: CF-Talk
: Subject: Structure, Array, Both?
:
:
: All:
:
: Structure or Array?
:
: I have a large table that I want in server memory but I�m not sure what
: the best route to follow is. There are many columns. Let say its White
: Pages information.
:
: Tables Columns e.g. :
:
: ID, FirstName, LastName, Address, City, State, Zip and Notes
:
: What is the best route to follow for a CFQUERY e.g. (Select * From
: Table) to place all its information into a structure or array?
:
: Regards,
: James Blaha
:
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
