Skip to main content
A
Anonymous
September 24, 2008
Question

Spry XML data from SQL stored procedure

  • September 24, 2008
  • 2 replies
  • 298 views
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

This topic has been closed for replies.

2 replies

A
Anonymous
October 11, 2008
Wow - I hope this thread isn't dead - because I want to do the same.

Isn't any tutorial from the beginning?
R
RajDogLives
Participant
October 2, 2008
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices