Using ASP to Generate an XML Document

Jon Westmore

I'm using an ASP page to dynamically generate an XML document using a data
source. I was thinking the concept would be similar to dynamically creating
HTML but I'm running into an issue. Here is my source code:
<%Response.Cont entType = "text/xml"
Response.CharSe t=""

Dim Connect ,RS, Query, Details

Details = Trim(Request("D etails"))

Set Connect = Server.CreateOb ject("ADODB.Con nection")

Connect.Open "PROVIDER=SQLOL EDB;DATA
SOURCE=is-sql;UID=infopat h;PWD=infopath; DATABASE=formli b "

Set RS = Server.CreateOb ject("ADODB.Rec ordset")

Query = "SELECT * FROM patients "

Query = Query & "WHERE pt_no='"& Details & "' "

Query = Query & "ORDER BY [pt_no]"

RS.Open Query, Connect%>

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolutio n
name="urn:schem as-microsoft-com:office:info path:source-code:-dataFormSolutio n"

href="manifest. xsf"

solutionVersion ="1.0.0.26"

initialView="Vi ew 1"

productVersion= "11.0.6357"

PIVersion="1.0. 0.0"?>

<?mso-application progid="InfoPat h.Document"?>

<dfs:myFields xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"

xmlns:q="http://schemas.microso ft.com/office/infopath/2003/ado/queryFields"

xmlns:d="http://schemas.microso ft.com/office/infopath/2003/ado/dataFields"

xmlns:dfs="http ://schemas.microso ft.com/office/infopath/2003/dataFormSolutio n"

xmlns:my="http://schemas.microso ft.com/office/infopath/2003/myXSD/2004-12-29T14:43:25"

xmlns:xd="http://schemas.microso ft.com/office/infopath/2003">

<dfs:queryField s>

<q:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room=""></q:order>

<q:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></q:order_sub>

</dfs:queryFields >

<dfs:dataFields >

<d:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room="">

<d:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></d:order_sub>

</d:order>

</dfs:dataFields>

<my:phy_sig xsi:nil="true"> </my:phy_sig>

<my:signatures1 ></my:signatures1>

</dfs:myFields>

Nov 19 '05 #1

Subscribe Reply

2419

Kevin Spencer

Try posting to microsoft.publi c.inetserver.as p.general or
microsoft.publi c.inetserver.as p.db.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.
"Jon Westmore" <we*****@reidho sp.com> wrote in message
news:u4******** *****@TK2MSFTNG P10.phx.gbl...

I'm using an ASP page to dynamically generate an XML document using a data
source. I was thinking the concept would be similar to dynamically
creating HTML but I'm running into an issue. Here is my source code:
<%Response.Cont entType = "text/xml"
Response.CharSe t=""

Dim Connect ,RS, Query, Details

Details = Trim(Request("D etails"))

Set Connect = Server.CreateOb ject("ADODB.Con nection")

Connect.Open "PROVIDER=SQLOL EDB;DATA
SOURCE=is-sql;UID=infopat h;PWD=infopath; DATABASE=formli b "

Set RS = Server.CreateOb ject("ADODB.Rec ordset")

Query = "SELECT * FROM patients "

Query = Query & "WHERE pt_no='"& Details & "' "

Query = Query & "ORDER BY [pt_no]"

RS.Open Query, Connect%>

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolutio n
name="urn:schem as-microsoft-com:office:info path:source-code:-dataFormSolutio n"

href="manifest. xsf"

solutionVersion ="1.0.0.26"

initialView="Vi ew 1"

productVersion= "11.0.6357"

PIVersion="1.0. 0.0"?>

<?mso-application progid="InfoPat h.Document"?>

<dfs:myFields xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"

xmlns:q="http://schemas.microso ft.com/office/infopath/2003/ado/queryFields"

xmlns:d="http://schemas.microso ft.com/office/infopath/2003/ado/dataFields"

xmlns:dfs="http ://schemas.microso ft.com/office/infopath/2003/dataFormSolutio n"

xmlns:my="http://schemas.microso ft.com/office/infopath/2003/myXSD/2004-12-29T14:43:25"

xmlns:xd="http://schemas.microso ft.com/office/infopath/2003">

<dfs:queryField s>

<q:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room=""></q:order>

<q:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></q:order_sub>

</dfs:queryFields >

<dfs:dataFields >

<d:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room="">

<d:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></d:order_sub>

</d:order>

</dfs:dataFields>

<my:phy_sig xsi:nil="true"> </my:phy_sig>

<my:signatures1 ></my:signatures1>

</dfs:myFields>

Nov 19 '05 #2

Patrice

And the problem is ?

Also you may to post this in a classical ASP newsgroup (this one is for
ASPNET)

Patrice

--

"Jon Westmore" <we*****@reidho sp.com> a écrit dans le message de
news:u4******** *****@TK2MSFTNG P10.phx.gbl...

I'm using an ASP page to dynamically generate an XML document using a data
source. I was thinking the concept would be similar to dynamically creating HTML but I'm running into an issue. Here is my source code:
<%Response.Cont entType = "text/xml"
Response.CharSe t=""

Dim Connect ,RS, Query, Details

Details = Trim(Request("D etails"))

Set Connect = Server.CreateOb ject("ADODB.Con nection")

Connect.Open "PROVIDER=SQLOL EDB;DATA
SOURCE=is-sql;UID=infopat h;PWD=infopath; DATABASE=formli b "

Set RS = Server.CreateOb ject("ADODB.Rec ordset")

Query = "SELECT * FROM patients "

Query = Query & "WHERE pt_no='"& Details & "' "

Query = Query & "ORDER BY [pt_no]"

RS.Open Query, Connect%>

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolutio n
name="urn:schem as-microsoft-com:office:info path:source-code:-dataFormSolutio
n"
href="manifest. xsf"

solutionVersion ="1.0.0.26"

initialView="Vi ew 1"

productVersion= "11.0.6357"

PIVersion="1.0. 0.0"?>

<?mso-application progid="InfoPat h.Document"?>

<dfs:myFields xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"

xmlns:q="http://schemas.microso ft.com/office/infopath/2003/ado/queryFields"
xmlns:d="http://schemas.microso ft.com/office/infopath/2003/ado/dataFields"

xmlns:dfs="http ://schemas.microso ft.com/office/infopath/2003/dataFormSolutio
n"
xmlns:my="http://schemas.microso ft.com/office/infopath/2003/myXSD/2004-12-29
T14:43:25"
xmlns:xd="http://schemas.microso ft.com/office/infopath/2003">

<dfs:queryField s>

<q:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room=""></q:order>

<q:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></q:order_sub>

</dfs:queryFields >

<dfs:dataFields >

<d:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room="">

<d:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></d:order_sub>

</d:order>

</dfs:dataFields>

<my:phy_sig xsi:nil="true"> </my:phy_sig>

<my:signatures1 ></my:signatures1>

</dfs:myFields>

Nov 19 '05 #3

Jon Westmore

Ignore this post, it was an accidental submission

"Jon Westmore" <we*****@reidho sp.com> wrote in message
news:u4******** *****@TK2MSFTNG P10.phx.gbl...

I'm using an ASP page to dynamically generate an XML document using a data
source. I was thinking the concept would be similar to dynamically
creating HTML but I'm running into an issue. Here is my source code:
<%Response.Cont entType = "text/xml"
Response.CharSe t=""

Dim Connect ,RS, Query, Details

Details = Trim(Request("D etails"))

Set Connect = Server.CreateOb ject("ADODB.Con nection")

Connect.Open "PROVIDER=SQLOL EDB;DATA
SOURCE=is-sql;UID=infopat h;PWD=infopath; DATABASE=formli b "

Set RS = Server.CreateOb ject("ADODB.Rec ordset")

Query = "SELECT * FROM patients "

Query = Query & "WHERE pt_no='"& Details & "' "

Query = Query & "ORDER BY [pt_no]"

RS.Open Query, Connect%>

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolutio n
name="urn:schem as-microsoft-com:office:info path:source-code:-dataFormSolutio n"

href="manifest. xsf"

solutionVersion ="1.0.0.26"

initialView="Vi ew 1"

productVersion= "11.0.6357"

PIVersion="1.0. 0.0"?>

<?mso-application progid="InfoPat h.Document"?>

<dfs:myFields xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"

xmlns:q="http://schemas.microso ft.com/office/infopath/2003/ado/queryFields"

xmlns:d="http://schemas.microso ft.com/office/infopath/2003/ado/dataFields"

xmlns:dfs="http ://schemas.microso ft.com/office/infopath/2003/dataFormSolutio n"

xmlns:my="http://schemas.microso ft.com/office/infopath/2003/myXSD/2004-12-29T14:43:25"

xmlns:xd="http://schemas.microso ft.com/office/infopath/2003">

<dfs:queryField s>

<q:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room=""></q:order>

<q:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></q:order_sub>

</dfs:queryFields >

<dfs:dataFields >

<d:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room="">

<d:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></d:order_sub>

</d:order>

</dfs:dataFields>

<my:phy_sig xsi:nil="true"> </my:phy_sig>

<my:signatures1 ></my:signatures1>

</dfs:myFields>

Nov 19 '05 #4

Kevin Spencer

Do you mean that you accidentally typed "Ignore this post, it was an
accidental submission" and then accidentally submitted it?

--
;-),

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

"Jon Westmore" <we*****@reidho sp.com> wrote in message
news:eM******** ********@tk2msf tngp13.phx.gbl. ..

Ignore this post, it was an accidental submission

"Jon Westmore" <we*****@reidho sp.com> wrote in message
news:u4******** *****@TK2MSFTNG P10.phx.gbl...
I'm using an ASP page to dynamically generate an XML document using a
data source. I was thinking the concept would be similar to dynamically
creating HTML but I'm running into an issue. Here is my source code:
<%Response.Cont entType = "text/xml"
Response.CharSe t=""

Dim Connect ,RS, Query, Details

Details = Trim(Request("D etails"))

Set Connect = Server.CreateOb ject("ADODB.Con nection")

Connect.Open "PROVIDER=SQLOL EDB;DATA
SOURCE=is-sql;UID=infopat h;PWD=infopath; DATABASE=formli b "

Set RS = Server.CreateOb ject("ADODB.Rec ordset")

Query = "SELECT * FROM patients "

Query = Query & "WHERE pt_no='"& Details & "' "

Query = Query & "ORDER BY [pt_no]"

RS.Open Query, Connect%>

<?xml version="1.0" encoding="UTF-8"?>

<?mso-infoPathSolutio n
name="urn:schem as-microsoft-com:office:info path:source-code:-dataFormSolutio n"

href="manifest. xsf"

solutionVersion ="1.0.0.26"

initialView="Vi ew 1"

productVersion= "11.0.6357"

PIVersion="1.0. 0.0"?>

<?mso-application progid="InfoPat h.Document"?>

<dfs:myFields xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance"

xmlns:q="http://schemas.microso ft.com/office/infopath/2003/ado/queryFields"

xmlns:d="http://schemas.microso ft.com/office/infopath/2003/ado/dataFields"

xmlns:dfs="http ://schemas.microso ft.com/office/infopath/2003/dataFormSolutio n"

xmlns:my="http://schemas.microso ft.com/office/infopath/2003/myXSD/2004-12-29T14:43:25"

xmlns:xd="http://schemas.microso ft.com/office/infopath/2003">

<dfs:queryField s>

<q:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room=""></q:order>

<q:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></q:order_sub>

</dfs:queryFields >

<dfs:dataFields >

<d:order order_id="" order_imp_dtime ="" phy_id="<%= rs("mrn") %>"
pt_room="">

<d:order_sub sub_order_id="" fk_order_id="" sub_order_dtime =""
sub_order_desc= "" sub_order_proc= "" sub_order_nurse =""></d:order_sub>

</d:order>

</dfs:dataFields>

<my:phy_sig xsi:nil="true"> </my:phy_sig>

<my:signatures1 ></my:signatures1>

</dfs:myFields>

Nov 19 '05 #5

Similar topics

3493

Advantages to using xml in a small translation and localisation company

by: Simon Harvey | last post by:

Whato chaps, I work (or am hoping to work! :) for a company that specialises in the following: - Localisation of media - including software, manuals, literature and training material. - Creating training material themselves in many langauges built to order. The main thing I'm thinking about for the company is maybe a sort of content

.NET Framework

1955

generating multi-page output using xsl

by: Waqas Ashraf | last post by:

hi, I am a newbie at xml/xsl. I m trying to generate a book of papers marked up in xml. I have a simple xml file which includes the papers, and i have xsl stylesheet document which generates the output in the form of ONE xhtml page. I can generate the entire book as one xhtml file but I want to be able to generate each paper on a DIFFERENT...

.NET Framework

1636

Is it possible to modify a source node using XSLT?

by: titanandrews | last post by:

Hi, I have ran into a situation that I think should be possible, but I am fairly new to XSLT so maybe not. Suppose I have the following document <ROOT> <FOO name="A"> <CHILD name="B"/> </FOO>

.NET Framework

1992

Generate XML by Javascript in IE

by: Dario de Judicibus | last post by:

I am trying to generate an XML file to be shown in IE by javascript. My code looks like top.x = window.open('','MyXML') ; top.x.document.write('<?xml version="1.0" encoding="ISO-8859-1" ?>') ; top.x.document.write('<myxml>') ; // all the other write's top.x.document.write('</myxml>') ;

Javascript

11278

How to generate Word Document using ASP on server side?

by: Brian Kwan | last post by:

Project Description: Develop a web application to help manage sale operations. There is a function that to generate a report using data in database, which is a Word document on server and let user to download and print it out. Problem: Found that it's risky to do Word automation on server side using ASP. The layout of report is a bit...

ASP / Active Server Pages

1973

Generate Client from Web Service

by: Delmar | last post by:

I need to build Web Application that will generate a client to execute some operations. Each client has running silent application. Maybe somebody can advice me what can I do ? Thank you.

C# / C Sharp

4425

Writing an XMl file using a specified schema

by: Eric | last post by:

Help! I created a XML schema with a Visual Studio tools. I'm filling a dataset with a DataAdapter. Before I use the "WriteXml" method to write the data to a xml file, I want to map the XSD file I created to the dataset so that when I do use the "WriteXml" method, the generated xml file will be properly formatted to the schema I created. I did...

C# / C Sharp

4441

How to bring Calendar control from back to front using javascript

by: gan | last post by:

hi dear all please help me im using the calander control from a form just i paste here the problem, the problem is when i click the calander button the calander is opening at the same time backside form component also visible in front side how can i rectfiy this one? i changed the z-index also but no use? <TABLE border="1"...

Javascript

1863

How can I generate XML from this code?

by: cleary1981 | last post by:

Hi, I know how to generate xml from php but is there an easier way to generate xml from my code? <?php $quote=$_GET; //echo $quote; require "config.php"; $q1 = mysql_query("SELECT * FROM quote WHERE quote_id = '$quote'");

XML

7475

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7409

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7918

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

5981

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5341

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

Microsoft Access / VBA

4958

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3446

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1897

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

715

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General