RE: [xsl] ASP script: produce HTML SELECT box?

Subject: RE: [xsl] ASP script: produce HTML SELECT box?
From: Pieter Reint Siegers Kort <pieter.siegers@xxxxxxxxxxx>
Date: Fri, 11 Feb 2005 11:18:44 -0600
Hi Hardy,

At first, it seems you don't need XML to create a HTML SELECT control. Just
use the recordset to build your SELECT control using ASP script.

Another approach is (if you want to use XML/XSLT) to get the data in XML
format, either using SQLXML, or forming the XML at the SQL server, feed it
to an instance of the MSXML procesor (version 4.0), add the XSLT stylesheet,
and transform it to the SELECT control which is then written out to the
Response.Output stream.


-----Original Message-----
From: Hardy Merrill [mailto:HMerrill@xxxxxxxxxxxxxxxx] 
Sent: Thursday, February 10, 2005 12:51 PM
To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
Subject: [xsl] ASP script: produce HTML SELECT box?

In an ASP script, I've queried the database and have received back a result
set and converted that into an XML document.  What I want to do is create an
HTML "SELECT" box from that XML document.

I know I can create an XSL style sheet to render the XML document as a
SELECT box, but is that the only way to create the HTML SELECT box, when my
source for the SELECT is an XML document already?  I was just asked this
question, and it seems like there's probably a simple answer, but I can't
think of one.  Is there a way to do the XSL style sheet *in* the ASP script,
and somehow render the XML document using it, rather than having to create a
separate XSL style sheet and then calling a render function passing it the
XML document and the name of the style sheet?

Not sure if my question is clear, but does anyone know what I'm trying to
ask?  Is it doable?  Or do I just have to create a separate XSL style sheet
to render that XML doc as an HTML SELECT box?


Hardy Merrill

Current Thread