how to get records from stored procedure using ASP

how to get records from stored procedure using ASP

am 04.02.2006 11:11:57 von bill

Hi,

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.
Thanks
Kevin

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