DBIx::Recordset : test.pl failure

[Terrence Brannon]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]