[Israel.pm] bind values are not working with oracle?

rami doqa rod082 at yahoo.com
Wed Feb 7 23:29:22 PST 2007


Hi everybody. Can any one help me please why binding
values are not working with oracle?

My example:

my $x = 100;
my $y ='blabla';

# this is not working:
my $sql = "SELECT xy FROM tableName WHERE x =? AND y
=?";

$self->{dbh}->selectrow_array( $sql, undef, ($x,$y) );


# tnis code is working fine:
my $sql = "SELECT xy FROM tableName WHERE x =$x AND y
='$y'";

$self->{dbh}->selectrow_array($sql);
		 


 
____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check. 
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html 



More information about the Perl mailing list