• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 442
  • Last Modified:

How to append parameter of xml type in asp(classic)

I need to send a parameter of type xml to a stored procedure on an asp(classic) page.
What is the DataTypeEnum Value for xml type?

This is the string to be sent:
"<StudyDataList><StudyData><StudyParID>931</StudyParID><TPID>2732</TPID><DataValue>1</DataValue></StudyData>
<StudyData><StudyParID>931</StudyParID><TPID>2733</TPID><DataValue>2</DataValue></StudyData>
<StudyData><StudyParID>931</StudyParID><TPID>2734</TPID><DataValue>3</DataValue></StudyData>
</StudyDataList>"

Thanks
0
ggilal
Asked:
ggilal
1 Solution
 
JoachimMartinsenCommented:
Theres no DataTypeEnum Value for XML. You would have to use the adLongVarChar (201) and then use e.g a regexp to check if it is "valid" XML.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now