Welcome to WebmasterWorld Guest from 54.196.214.35

Forum Moderators: httpwebwitch

Message Too Old, No Replies

Querying an XML database?

XML + Xquery + XSLT

     
11:42 am on Dec 22, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Mar 31, 2004
posts:115
votes: 0


I have an XML data source (list of sales points), e.g.


<xml>
<salespoints>

<seller>
<name>
acme
</name>
<postalcode>
123456789
</postalcode>

<address>
teertsstreet
</address>

<product>
jellyfish
</product>
</seller>

</salespoints>
</xml>

What I want to do is provide a form where the user enters his postal code, then it filters this and gets all the corresponding results from the XML datasource and presents the whole as a web page through XSLT.

How would I best go about to obtaining this result?

Also, the source file will be an Excel file. Anyone know a good way to convert an Excel file to an XML datasource, like described above?

Thanks,

Darkelve

2:09 pm on Dec 23, 2005 (gmt 0)

Junior Member

10+ Year Member

joined:Oct 12, 2005
posts:86
votes: 0


Why not just Google for it. Type in "Excel XML". Plenty of stuff to go on.