how to get records from stored procedure using ASP

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!


I made a stored procedure (name = test (Out param1 char(20)) in Mysql 5.0
with a parameter. I use ASP (i know PHP would be maybe a better choice but
it's ASP) and the value of the parameter must be compared to the value of
variable 'name' for identification. I can get the records from a stored
procedure without parameter in ASP, but here, I don't know how to link
variable 'name' to the stored procedure.

The code:
set objdc = Server.CreateObject("ADODB.Connection")
objdc.Open "Driver={MySQL ODBC 3.51 Driver}; Server=localhost; Port=3306;
Socket=; Stmt=;" Database=reserv; Uid=root; Pwd=xxx;"
set rs=objdc.execute("call test3 (@x)")
if not rs.eof then
rsarray = rs.getrows()
end if

Site Timeline