var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: returning values in asp from sql stored procedure
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
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
Set objRs = Server.CreateObject("ADODB.Recordset")
objRs.Open sql, objConn
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.
i found the issue
i needed to add set no count on in the stored procedure as nothing was being returned
Glad it is working.
Actually that is not what was happening. You were getting multiple recordsets and the first one was empty.
Originally Posted by esthera
You could have used objrs.NextRecordSet() and got the next set of results.