Good point. You probably wouldn't want to use that method for anything like
product availability or anything I suppose. Another use would be to populate
select boxes... Like what TwoSelectsRelated.cfm does, but without having to
get crazy creating arrays and such.
You could query all of the data from the first item and all of the data for
the second. Then when the first is selected query against that recordset to
populate the second... Eh, I don't know, guess we'll all have lots of
examples once we all play with it more :-)
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.billtracker.org <http://www.billtracker.org>
-----Original Message-----
From: Phoeun Pha [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 2:29 PM
To: CF-Talk
Subject: RE: CF rules!!!
yeah, but what if data in the DB changed during that instance
-----Original Message-----
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 4:01 PM
To: CF-Talk
Subject: RE: CF rules!!!
Wouldn't another use be to drill down through data. Along the similar line,
you could make one query at the beginning and then drill down through it as
needed and not have to keep making return trips to the DB.
Just thinking
J.
John Wilker
Web Applications Consultant
Allaire Certified ColdFusion Developer
Office: 909-943-8428
www.billtracker.org <http://www.billtracker.org>
-----Original Message-----
From: Larry C. Lyons [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 1:34 PM
To: CF-Talk
Subject: Re: CF rules!!!
Alternatively you put the intial query into an application variable and
then run queries against that one.
larry
Savan Thongvanh wrote:
>
> real world mode now, how realistic is querying your inventory for each
user?
> RAM resources?
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
