SQLXML

[sodakotahusker]

I borrowed some code from work that use SQLXML to create a dynamic menuing structure. It is pretty cool. Unfortunately I can't use SQLXML on my web host. I am not extremely knowledgeable about XML and the tools available. This returns some xml tags using the For XML keyword in sql The SQLXML object then works some magic on it, which appears to me to be simply makes it well formed XML by putting the beginning and closing tags around the returned string. If that is true, I should be able to simulate that by returning the string from the database and appending my own tags and assigning it to an XMLDocument object. Can anyone tell me if I am way out in left field here or not?

 

[jmeckley]

the sql programming forum might be more help [

http://www.tek-tips.com/threadminder.cfm?pid=183

].

personally I would create this in code rather than on the server. depending on the strcture of the data and query it may take a few more database hits, but the information could be stored in cache/session to reduce contintual hits to the datatbase.

Jason Meckley
Programmer
Specialty Bakers, Inc.