Re: MSXML 4 - RowSetSchema XML

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@xxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
Sent: Friday, February 06, 2004 11:21 AM
Subject: Re:  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@xxxxxxx>
> > To: <xsl-list@xxxxxxxxxxxxxxxxxxxxxx>
> > Sent: Friday, February 06, 2004 6:04 AM
> > Subject:  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