perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Terrence Brannon <metap...@urth.org>
Subject DBIx::Recordset : test.pl failure
Date Sat, 11 Oct 2003 09:57:15 GMT
Under Cygwin, Perl-5.8.0 and DBD::Pg, The following test fails:

printlogf "Select multiply fields 2";
    print LOG "\n--------------------\n" ;

    $set1 -> Select ({'+name&value1' => "Third Name",
                           '$operator' => '='})  or die "not ok         
($DBI::errstr)" ;

The Recordset expression expands to this:

DB:  'SELECT * FROM dbixrs1 WHERE   (  (  name = ?  or  value1 = ?))     
' bind_values=<2112 2112> bind_types=<1 4>

But the table contains this:

test=# select * from dbixrs1;
 id |         name         | value1 |        addon        
----+----------------------+--------+----------------------
  1 | First Name           |   9991 | Is                 
  2 | Second Name          |   9992 | it                 
  3 | Third Name           |   9993 | it ok?             
  4 | Fourth Name          |   9994 | Or not??           
  5 | Fivth Name           |   9995 | Is                 
  6 | Sixth Name           |   9996 | it                 
  7 | Seventh Name         |   9997 | it ok?             
  8 | Eighth Name          |   9998 | Or not??           
  9 | Ninth Name           |   9999 | Is                 
 10 | Tenth Name           |  99910 | it                 
 11 | Eleventh Name        |  99911 | it ok?             
 12 | Twelvth Name         |  99912 |                    
 13 | Thirdteenth Name     |        |
 14 | Fourteenth Name      |      0 |
(14 rows)

test=#


...so of course it would fail.



QUESTION: How come "&" is used to separate the fields? The docs use a
"+"




---------------------------------------------------------------------
To unsubscribe, e-mail: embperl-unsubscribe@perl.apache.org
For additional commands, e-mail: embperl-help@perl.apache.org


Mime
View raw message