[thelist] updating cascading 'select' form elements fromadatabase

[Ken Schaefer]

On Thu, 12 Aug 2004 22:22:52 -0700, Joel D Canfield <joel at spinhead.com> wrote:
> > SQL Server can generate XML on the fly (eg using FOR XML
> > AUTO) and serve this over HTTP. That would probably solve the
> > problem of generating the XML from the datastore.
> 
> All interesting and educational; thank you.
> 
> I'm still waiting for the part where it gets easier ;)
> 
> *If* we do this at all, I think we'll just grab the data at the outset,
> create some JavaScript arrays, and use them to populate the selects as
> required. Unless someone can really convince me this XML concept will be
> easier/better somehow in the long run
> 
> Thanks, all. It's been interesting.

I think it all depends on how much data you have. Lots of data, lots
of choices means that you have to ship stuff to the client they might
not need. 15 choices across three select lists probably isn't much:

http://www.atgconsulting.com/triplelist.asp

Cheers
Ken