develooper Front page | perl.beginners | Postings from February 2002

ADO syntax

Thread Next
From:
mb
Date:
February 13, 2002 14:03
Subject:
ADO syntax
Message ID:
000601c1b4d9$f5adde40$2471933e@w3w6d9
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




Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About