Spry XML data from SQL stored procedure

[LSPNwebmaster]

It is nice that one can use a static XML dataset in the spry widgets, but a static XML dataset is not really that dynamic. What I would like to do is to be able to use a more dynamic XML source, such as one that can easily be returned by SQL server stored procedure using the FOR XML EXPLICIT clause. I have created such a stored procedure but have not been able to determine how in the heck to get it recognized as a spry XML dataset.

Has anyone tried this and gotten it to work?

If so, I would be so very happy if you would share the secret with me.

I am very new to dreamweaver, so please don't be too hard on me.

thanks,
Bob

[RajDogLives]

I am having the same problem.
I have a stored procedure that returns dynamic XML similar to how you described. I call the stored procedure in dreamweaver and it recognizes the Output parameter that returns the XML so it looks like it should work. But when I go to create a spry xml dataset -> XML source ->Browse->Data Sources ->Stored Procedure->Select the output parameter, then try to get the schema I get an error "unable to locate or parse the XML source". Yet if I save the xml that sp outputs in a file and browse to it it works fine. Really annoying, Anyone out there have any ideas?
Thanks,
Raj

[jj1966]

Wow - I hope this thread isn't dead - because I want to do the same.

Isn't any tutorial from the beginning?