Getting data from a SP in ASP document.

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

click-fund Ten Centuries Points: 1028 More actions · Answer 1

p.s. when I first posted this vbs snippet I forgot to include the "rset.movenext" call. I know that this needs to be there, that's not the problem.

jordanac Hall of Fame Points: 3713 More actions · Answer 2

Just a shot in the dark....Do you use SET NOCOUNT ON in your SP?

Andy.

Jonathan Stokes SSCrazy Eights Points: 9861 More actions · Answer 3

Here's my two penneth.

Make sure that you are getting back the correct amount of records by bringing back a record count.

If it looks OK, it's worth having a look at the For each column statement. Try:

intNumColumns = rset.ColumnCount

For inti = 0 To intNumColumns - 1

response.write column.value & ", " & chr(10) & chr(13)

Next inti

Hope this helps you out

------------------------------
The Users are always right - when I'm not wrong!

click-fund Ten Centuries Points: 1028 More actions · Answer 4

Well, that might help getting ADO to pick the right result set. I'll try it.