xml-dev - RE: Embedding SQL statements in XML

[Mike Geiger <mike@PerCurrence.com>]

PerCurrence makes the PerXML transformation engine which is designed to do
exactly that.  It uses an XML based declarative language to represent the
data connectivity and display template.  Here is a sample fragment:

<start xmlns:PerXML="www.percurrence.com">
	<PerXML:sql id="rs1" connect="Northwind" uid="percurrence"
pw="percurrence" encoding="xml" sql="SELECT * FROM Customers where
CompanyName like 'Alfreds%' order by CompanyName" null=""
apply="CustomerList"/>
		<CustomerList>
			<CustomerMailLabel>
	
<ContactName>$rs1("ContactName")</ContactName>
			</CustomerMailLabel>
		</CustomerList>
</start>

The download and client software are free at www.percurrence.com .  This
comes with a very concise tutorial.

--Mike