Unexpected query result 2

[audiopro]

The following code set $rv1 to a value of -2 on an empty table yet works ok on a populated table.

my $sql1="SELECT OU, OP, QU, QP, FNUM, MESSIGE, RED, FREDNO, QNUM from BABBLE WHERE OU=\"$MET\ AND OP=\"$YUT\"";
my $sth1=$dbh->prepare($sql1);
$sth1->execute();
my $rv1=$sth1->rows;

I can work round it but is there an underlying cause?

Keith

http://www.studiosoft.co.uk

 

[vjcyrano]

my $sql1="SELECT OU, OP, QU, QP, FNUM, MESSIGE, RED, FREDNO, QNUM from BABBLE WHERE OU=\"$MET\ AND OP=\"$YUT\"";


I dont see an ending double qoute.
OU=\"$MET\(") ??

and shouldnt u be using single quotes instead of double ?

 

[ishnid]

If you're using a prepared statement, you should also be using placeholders for the parameters. That way, DBI takes care of all your quoting for you:

my $sql1="SELECT OU, OP, QU, QP, FNUM, MESSIGE, RED, FREDNO, QNUM from BABBLE WHERE OU=? AND OP=?";
my $sth1=$dbh->prepare($sql1);
$sth1->execute( $MET, $YUT );
my $rv1=$sth1->rows;

 

[audiopro]

Thanks very much for that.
I need some new eyes I think!

Thanks for the tip about the quotes, I am in the habit of using delimited doubles.

Will this cause problems?



Keith

http://www.studiosoft.co.uk

 

[audiopro]

Thanks for the tip about place holders.
I am fairly new to this MySQL lark and there is still so much to learn.
I will read up on that.

Keith

http://www.studiosoft.co.uk