how to get record from stored procedure in Mysql with a paramater?

how to get record from stored procedure in Mysql with a paramater?

am 03.02.2006 18:52:51 von Kevin

Hi,

Here am i back, with the same question, but here, the stored procedure must
be executed with its parameter with a certain value (the same as in Access
when creating a query with a criterium defined as [xx]).
What i want is to execute the stored procedure with value "bibi".
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