I'm trying to pass an XML parameter to a stored procedure. I had it working using the command object, but since the recordcount and pagecount refuse to work with the command object I had to switch to the connection object.
How can I pass an XML parameter to my stored procedure? Here is what I was using for the command object:
sXMLDoc = oXmlDom.selectSingleNode("/").xml
oCmd.Parameters.Append oCmd.CreateParameter("", adVarchar, adParamInput, Len(sXMLDoc), sXMLDoc)
The above worked for me, however there can be several thousands of rows returned, and the rest of the code only displays 250 records on the screen at a time so the recordcount and pagecount are needed.
Your help is appreciated.