kevin lloyd

Hi,

I have a query that behave differently when called via query ****yser
and my ASP. Using query ****yser I get back the XML rowset I expect.
However when using the ASP (ADO) I get nothing back.

Here is a code snippet...

dim resultStream
set resultStream = Server.CreateObject("ADODB.stream")

resultStream.Open
resultStream.Position = 0
adoCmdSet.Properties("Output Stream") = resultStream

Set rs = adoCmdSet.Execute(,,adExecuteStream)


DBWrapper = resultStream.ReadText

All of my other querys work as I expect. I have examined the one that
returns blank. The only difference is that it contains many subqueries.
I'm banging my head against a wall. It works in query ****yser but
returns blank via ASP (ADO). Does anyone have any ideas?

Thanks


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

sql server development team [msft]

Please try to reset the resultStream potion to 0.

resultStream.Position=0

before call the resultStream.ReadText.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.