It is not an XML Schema. It is just and XML source. I also build my SQL
queries from this XML source. Here is an example of the XML source I use to
both: build sql query, and act as a template to look up against for the
resulting ADO/XML result.
If you look closely, you'll see that I add some special node vals or
properties to certain FLD elements to help determine what type of edit field
should be displayed if an edit screen is requested.
<?xml version="1.0"?>
<FLDS table="PageContent" text="table_text">
<FLD name="PageContentID" text="PageContentID" type="int" edit="false"
primarykey="true" viewable="false"></FLD>
<FLD name="PageName" text="PageName" type="string" edit="true"></FLD>
<FLD name="Label" text="Label" type="string" edit="true"></FLD>
<FLD name="Content" text="Content" type="string" edit="true">
<EDITPROPS type="textarea" rows="15" cols="65"/>
</FLD>
<FLD name="Comments" text="Comments" type="string" edit="true">
<EDITPROPS type="textarea" rows="5" cols="65"/>
</FLD>
<FLD name="Active" text="Active" type="string" edit="true"
dd="active"></FLD>
<FLD name="create_date" text="create_date" type="dateTime"
edit="false"></FLD>
<FLD name="mod_date" text="mod_date" type="dateTime" edit="false"></FLD>
<DD name="active">
<D>Y</D>
<D>N</D>
</DD>
</FLDS>
----- Original Message -----
From: <tbstewart(_at_)mho(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Friday, February 06, 2004 11:21 AM
Subject: Re: [xsl] MSXML 4 - RowSetSchema XML
Karl,
So the XML doc that you pass to the stylesheet as a parameter is an XML
schema? I remember from my last job that we used an XML schema with XSL
when transforming XML to display the resulting data correctly. Is that
what you are doing?
Tom
Hi Tom
I don't think that you can. I have a seperate XML doc which I pass to
the stylesheet as a parameter. This seperate XML doc serves as a
*template* for the resulting data. I have code samples, infact I have
an entire ASP class that I have written to support classic ASP and ADO
XSLT transformations.
Karl
----- Original Message -----
From: <tbstewart(_at_)mho(_dot_)com>
To: <xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com>
Sent: Friday, February 06, 2004 6:04 AM
Subject: [xsl] MSXML 4 - RowSetSchema XML
Hi,
I am using MSXML 4.0 to perform server-side (memory resident)
transformations in my Classic ASP Web application. The default XML
that ADO generates is a combination of the schema and the XML in what
MS calls a RowSetSchema. The problem with using the XML as is, is that
when a data item is null the node's attribute is not included in the
rowset. Hence, the report's table cell is not preserved and the
remaining data columns shift one or more columns to the left.
Q: How do I write the XSL to detect a missing rowset attribute? I want
to add whitespace to the cell to keep the data set lined up in the
correct columns.
Thanks for your help.
Cheers,
--Tom
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list