I do something like that but use an onChange event in my first select box to
run a combo CF/js script in a hidden frame to get only those items necessary
based on the first select statement. Since I don't have to return the
entire state list for every country in the world each time, it executes
fairly quickly.
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Sunday, November 12, 2000 8:32 AM
To: CF-Talk
Subject: Re: [Cached Queries]
On 11/12/00, W Luke penned:
>Excellent. I basically have 2 queries that both return large amounts of
>records - the first being as you describe above - however the second is an
>interesting dilema. I have a table called Locations, with "County" and
>"Town." Using the cool TwoSelectsRelated tag, I'm populating both boxes
>(users choose a county - and then a town). However with a current town
list
>of over 1600, and due to the fact that TwoSelectsRelated loads both columns
>of the table in their entirity, this takes *ages* to download. Using
>TwoSelectsRelated is by far the nicest option available - but unfortunately
>I might have to change.
>
>Hopefully caching the query will speed things up a little anyhow.
I tried using it in my shopping cart also for countries and
states/territories. It was dreadfully slow, because of the huge
amount of javascript code that had to be loaded, and didn't work at
times probably due to the same thing. I ended up just going to an
extra screen to choose the state based on the country. An extra
click, but still much quicker.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
