George,
How is anyone going to use a select box with 21,000 options? Don't you think
that's too many for someone to look through when making a selection in a
select box?
You should try getting some parameters from the user first and pass those to
the query so you don't have so many options in one box. Have them enter the
category, or maybe some sort of alphabetical search, but do something that
will narrow down the query results. IMHO, you would never want to have more
than 500 options in a select box (as an absolute limit).
Jason
----
Jason Aden
Allaire Certified Developer
[EMAIL PROTECTED]
www.wwstudios.com
> -----Original Message-----
> From: George Dong [mailto:[EMAIL PROTECTED]]
> Sent: Friday, March 09, 2001 1:52 PM
> To: CF-Talk
> Subject: Re: How to fast big query result on browser
>
>
> about 21,000 options
>
> ----- Original Message -----
> From: "Hayes, David" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Friday, March 09, 2001 10:32 AM
> Subject: RE: How to fast big query result on browser
>
>
> > How many options are you putting in your select box?
> >
> > -----Original Message-----
> > From: George Dong [mailto:[EMAIL PROTECTED]]
> > Sent: Friday, March 09, 2001 12:30 PM
> > To: CF-Talk
> > Subject: How to fast big query result on browser
> >
> >
> > Hi there,
> > I have one problem, I made a select box, the option items come from a
> query
> > result, due to 20, 000 records, so the browser is very slow for that
> > template, even I already cached query on server.
> >
> > If any one has a good sulotion?
> >
> > thx.
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
