RE: ADO syntax

2002-02-13 Thread RArul
: Wednesday, February 13, 2002 5:00 PM > To: [EMAIL PROTECTED] > Subject: ADO syntax > > > 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

ADO syntax

2002-02-13 Thread 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->Paramete