Hi all, 

Sure  i m the only one doing perl in the week-end, the mailinglist is deserted.

I' m tryig to generate dynamic SQL statements.
I have a problem on  getting a WHERE over 'varchar' type fields.

for ($i =0; $i<scalar(@where); $i+=2){
     #pour une entree a la table de hash avec en sortie un ensemble de atts 
     #on en selectionne un aleatoirement sur le quel portera le where
     @tabAttrs = @{$hash{@where[$i]}};
     my $indice =  int(rand(@tabAttrs));
     if($i != scalar(@where)-2){
  $string .= @where[$i].' = '.@where[$i+1].' and ';
  $stringW .= @tabAttrs[$indice].' like '.@where[$i+1].' and ';
     }else{
  $string .= @where[$i].' = '.@where[$i+1];
  $stringW .= @tabAttrs[$indice].' like '.@where[$i+1];
     }
 }

suppose @where[$i+1]      == mars          -> I want to get   'mars'.

"select DE_Intitule, @select from F_Depot  $stringW" ------------> that is my SQL 
statement

And i m gtting the error bellow :

select DE_Intitule, from F_Depot where DE_Contact like mars and DE_Ville like mars and 
DE_Contact like rueOLE exception from "Microsoft OLE DB Provider for ODBC Drivers": 
[Simba][Simba ODBC Driver]Syntax Error. Win32::OLE(0.1502) error 0x80040e14 in 
METHOD/PROPERTYGET "Execute"

thanks for any help.
and have a nice week-end ;-)

asma


  

Reply via email to