P
Papanii
Hi guys,
I am using sqlxml templates to retrieve data from a database in
xml format. By the use of these templates i have been able to supply the
right processing instructions to enble the file open in infopath. The
problem i am having is the after i retrieve the xml doc, it opens in intenet
explore instead of infopath. In order to open the doc in infoapth, I have to
save the xml doc again before it opens in infoapth. Does anyone has a
workaround? Below is an example of a xml doc return from the database by the
use of the xml sql templates..
<?xml version='1.0' ?>
<?mso-infoPathSolution solutionVersion="1.0.0.3" productVersion="11.0.6250"
PIVersion="1.0.0.0"
href="file:///C:\Documents%20and%20Settings\papanii\Desktop\New%20Folder\Tem
plate2.xsn" name="urn:schemas-microsoft-comffice:infopath:Template2:" ?>
<?mso-application progid="InfoPath.Document"?>
<BookTypes xml:lang="en-us" xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-07-22
T22:24:21">
<booktypes>
<guid>F6601ABD-41E9-4E24-944A-00C9B873FAE1</guid>
<name>BabyBooks</name>
<dateCreated>2004-07-15T16:50:13.630</dateCreated>
<author>DRAGONBALL\papanii</author>
</booktypes>
</BookTypes>
Thanx in advance...
I am using sqlxml templates to retrieve data from a database in
xml format. By the use of these templates i have been able to supply the
right processing instructions to enble the file open in infopath. The
problem i am having is the after i retrieve the xml doc, it opens in intenet
explore instead of infopath. In order to open the doc in infoapth, I have to
save the xml doc again before it opens in infoapth. Does anyone has a
workaround? Below is an example of a xml doc return from the database by the
use of the xml sql templates..
<?xml version='1.0' ?>
<?mso-infoPathSolution solutionVersion="1.0.0.3" productVersion="11.0.6250"
PIVersion="1.0.0.0"
href="file:///C:\Documents%20and%20Settings\papanii\Desktop\New%20Folder\Tem
plate2.xsn" name="urn:schemas-microsoft-comffice:infopath:Template2:" ?>
<?mso-application progid="InfoPath.Document"?>
<BookTypes xml:lang="en-us" xmlns:sql="urn:schemas-microsoft-com:xml-sql"
xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2004-07-22
T22:24:21">
<booktypes>
<guid>F6601ABD-41E9-4E24-944A-00C9B873FAE1</guid>
<name>BabyBooks</name>
<dateCreated>2004-07-15T16:50:13.630</dateCreated>
<author>DRAGONBALL\papanii</author>
</booktypes>
</BookTypes>
Thanx in advance...