[thelist] updating cascading 'select' form elements from adatabase

[Ken Schaefer]

On Thu, 12 Aug 2004 18:17:06 -0700, Diane Soini
<dianesoini at earthlink.net> wrote:
> On Thursday, August 12, 2004, at 04:15 AM,
> thelist-request at lists.evolt.org wrote:
> >
> > El jue, 12-08-2004 a las 05:38, Joel D Canfield escribió:
> >>> What about using javascript and XML. Let's you make a trip to the
> >>> server (for the XML file) without refreshing the HTML on the client
> >>> side. Works in many modern browsers but not all, though.
> >>
> >> Intruiging. Can you expand on that? What's *in* the XML file? How does
> >> it get there?
> >
> > Sorry for stepping on the middle of a conversation, but i guess he's
> > referring to the xml http request object
> >
> > http://jibbering.com/2002/4/httprequest.html
> 

> Not that this even begins to say what you could do with this technique.
> But imagine generating the XML file with a php script that queries a
> database to return xml content when your javascript calls an xml.load
> function.

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.

HTH