Very Computer

I am moving towards replacing the html generated from recordsets with XML
and XSL stylesheets, but I have not been able to find a neat way of ensuring
updates to the database are incorperated in XML when generating my pages.
Using the IIS virtual directory template query I can generated the XML I
require, but I think I need to generate the XML from the ado connection
object to ensure page updates are encorperated.

I have looked briefly at the ado recordset save function, but thought there
must be a neater way of doing this.

Does anyone know if there is:
1. A method to generate the xml definited in a template query such as
"http://myserver/myvdir/myquery.xml" from an ado connection
2. Another suitable method for updating a database then generating xml
incorperating the updates.

Thanks

Quote:> Until now I have been using ADO recordset to retrieve content from an sql
> server database for use in asp pages. I have been making all updates to
the
> database in a page initialisation procedure and then I rely on the fact
that
> I'm using the same ado connection object everywhere in the page to ensure
> that the updated records are used when generating my pages.

> I am moving towards replacing the html generated from recordsets with XML
> and XSL stylesheets, but I have not been able to find a neat way of
ensuring
> updates to the database are incorperated in XML when generating my pages.
> Using the IIS virtual directory template query I can generated the XML I
> require, but I think I need to generate the XML from the ado connection
> object to ensure page updates are encorperated.

> I have looked briefly at the ado recordset save function, but thought
there
> must be a neater way of doing this.

> Does anyone know if there is:
> 1. A method to generate the xml definited in a template query such as
> "http://myserver/myvdir/myquery.xml" from an ado connection
> 2. Another suitable method for updating a database then generating xml
> incorperating the updates.

> Thanks

Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim strmIn As New ADODB.Stream
cn.Open sConn
Set cmd.ActiveConnection = cn
strmIn.Open
strmIn.WriteText "template"
strmIn.Position = 0
Set cmd.CommandStream = strmIn
cmd.Dialect =
       "{5d531cb2-e6ed-11d2-b252-00c04f681b71}"
cmd.Properties("Output Stream").Value = Response
cmd.Execute , , adExecuteStream

when connecting to SQLServer 2000.

For updates you have several possibilities depending on your application
requirements:

1. Use SQL Stored procs/update statements to perform the updates
2. Use OpenXML in a SQL stored proc

both work with SS2000 as released. In addition with the upcoming webrelease
(current release on msdn only works with beta2 build of SS2000),

3. XML Updategrams

I hope this helps
Michael

Quote:> Until now I have been using ADO recordset to retrieve content from an sql
> server database for use in asp pages. I have been making all updates to
the
> database in a page initialisation procedure and then I rely on the fact
that
> I'm using the same ado connection object everywhere in the page to ensure
> that the updated records are used when generating my pages.

> I am moving towards replacing the html generated from recordsets with XML
> and XSL stylesheets, but I have not been able to find a neat way of
ensuring
> updates to the database are incorperated in XML when generating my pages.
> Using the IIS virtual directory template query I can generated the XML I
> require, but I think I need to generate the XML from the ado connection
> object to ensure page updates are encorperated.

> I have looked briefly at the ado recordset save function, but thought
there
> must be a neater way of doing this.

> Does anyone know if there is:
> 1. A method to generate the xml definited in a template query such as
> "http://myserver/myvdir/myquery.xml" from an ado connection
> 2. Another suitable method for updating a database then generating xml
> incorperating the updates.

> Thanks

John