ADO syntax

[mb]

Hi all,

can some one tells me what is wrong with that :

$Conn->Execute("create procedure textproc \@val varchar(25) as  select AR_Ref 
,AR_Design from F_Article where AR_design like \@val");
    $cmd->{ActiveConnection} = $Conn;
    $cmd->{CommandText} = "{call textproc (?)}";
    $cmd->Parameters->Append $cmd->CreateParameter("val", adChar, ,25, 
"Dcitionnaire");     
    $rs = $cmd->Execute();
    while (! $rs->EOF) {
 $XXX = $RS->Fields(0)->value;
 $YYY = $RS->Fields(1)->value;
 print $XXX;
 print $YYY;
 $rs->MoveNext;
    }
it seem not apreciate the append to the command text.
 
syntax error at c:/phpweb/cgi-bin/chercherlivre.cgi line 92, near "->Append $cmd"

thanks a lot,
asma