returning values in asp from sql stored procedure

esthera · #1 (**permalink**) 05-13-07, 05:13

I have done this many times and it worked so i must not be seeing the error

below is my code

it tells me item cannot be found in collection...

when I execute the sp in query alalyzer I am returned the regid and price

does anyone see what i'm doing wrong

Code:

sql="exec spaddconfreg @name="& sname & ",@nameoforganization=" & nameoforganization & ",@stpob=" & stpob & ",@city=" & city & ",@zip=" & zip & ",@emailaddress=" & emailaddress & ",@phonenumber=" & phonenumber & ",@mobilephonenumber=" & mobilephonenumber & ",@dietaryrestrictions=" &dietaryrestrictions & ",@sessions=" & sessions & ",@meal=" & tosql(request("meal"),"text") & ",@ndays=" & numdays
response.write sql
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objConn
regid=objrs("regid")
price=objrs("price")
objrs.close

khurram007 · #2 (**permalink**) 05-14-07, 03:06

Post here both queries.

First what are you writing in MSSQL Query Analyzer when getting results.
Second - what is written on the page as a result of respons.write sql.

Khurram.

esthera · #3 (**permalink**) 05-14-07, 03:11

i found the issue

i needed to add set no count on in the stored procedure as nothing was being returned

khurram007 · #4 (**permalink**) 05-14-07, 04:11

Glad it is working.

Khurram.

rokslide · #5 (**permalink**) 05-17-07, 22:11

Quote:

Originally Posted by esthera

i found the issue

i needed to add set no count on in the stored procedure as nothing was being returned

Actually that is not what was happening. You were getting multiple recordsets and the first one was empty.

You could have used objrs.NextRecordSet() and got the next set of results.

Internet Services

Web Development

Digital Marketing

Consumer Tech