Re: xpath queries on a variable instead of a table

[Virginia O'Connor]

Hello Colin,

If I understand your question correctly, you want to store XML data into multiple tables based on variables defined in the XML. In this case, a stored procedure is not necessary. Take a look at XAware (www.xaware.org).

If you have the XML data, you can use XAware to quickly shred that data structure and map it to be stored in your database tables. You can also easily define conditional logic to determine which data is stored in which table.

Of course, all of this works the other way as well ... specifically if you are trying to retrieve data from the database tables based on variable input parameter values.

Virginia
Technical Writer XAware, Inc.
www.xaware.org