I am new to XML so pardon my ignorance. I have an XML file that is used to
layout an invoice from a program. The problem I am having is I need more
data than the program puts out so is it possible to use a script or
something to query an MS SQL Server database for the additional data. I so
how would you go about this. Any help would be great thanks in advance


Richard

[quoted text, click to view]

There are lots of XML applications, e.g. there is XHTML (where elements
are in the namespace http://www.w3.org/1999/xhtml), there is XSLT (where
the program instructions are in the namespace
http://www.w3.org/1999/XSL/Transform), there is XSL-FO (where the layout
instructions are in the namespace http://www.w3.org/1999/XSL/Format).
Can you tell us what you use?

As for writing a script or program to query an MS SQL database that is
certainly possible with VBScript or JScript and ADO or with the .NET
framework but how that fits into your existing solution depends on what
kind of XML application you are using.

--

Martin Honnen --- MVP XML

From what I can see there is no namespace as you would see in an xhtml
document. This is a Purchase Order layout for microsoft dynamics retail
management system. when you print an invoice this file is used to generate
the invoice and send it to the printer. I have included the top section of
the code below. I do not know if this helps.

<XML>

<PROPERTIES>
<DESCRIPTION> XML Purchase Order </DESCRIPTION>
<AUTHOR> Microsoft Corporation </AUTHOR>
<VERSION> 1.0 </VERSION>
</PROPERTIES>

<!-- ========================= -->
<!-- Variable Declarations -->
<!-- ========================= -->

<!-- These variables may be altered: -->

<SET name="PaperWidth" custom="true" description="Paper Width"
type="vbDouble"> 8.50 </SET>
<SET name="PaperHeight" custom="true" description="Paper Height"
type="vbDouble"> 11.00 </SET>
<SET name="LogoWidth" custom="true" description="Logo Width"
type="vbDouble"> 1.125 </SET>
<SET name="LogoFilename" custom="true" description="Logo Filename"
type="String"> </SET>

<SET name="HeaderHeight" custom="true" description="Margin Left"
type="vbDouble"> 0.75 </SET>
<SET name="FooterHeight" custom="true" description="Footer Height"
type="vbDouble"> 0.25 </SET>
<SET name="TotalsHeight" custom="true" description="Totals Height"
type="vbDouble"> 1.8 </SET>

<SET name="MarginLeft" custom="true" description="Margin Left"
type="vbDouble"> 0.30 </SET>
<SET name="MarginRight" custom="true" description="Margin Right"
type="vbDouble"> 0.25 </SET>
<SET name="MarginTop" custom="true" description="Margin Top"
type="vbDouble"> 0.50 </SET>
<SET name="MarginBottom" custom="true" description="Margin Bottom"
type="vbDouble"> 0.50 </SET>


<SET name="PageWidth" description="Page Width" type="vbDouble"> PaperWidth -
MarginLeft - MarginRight </SET>
<SET name="PageHeight" description="Page Height" type="vbDouble">
PaperHeight - MarginTop - MarginBottom - HeaderHeight - FooterHeight</SET>

<!-- Margin -->



[quoted text, click to view]