What Val would Return if Select Criteria not Met?

[M626]

I am doing this select statement in perl, what VAL would it return if one of the criteria is not met.

select
Client,Received_Date
from
Test_History
where
Client = '$clt_brk' and Received_Date = '$dte_brk'

 

[degroat]

I don't use perl, but PHP has a function called "mysql_num_rows" that returns the number of rows returned. So, I just check to see if that value is 0 and if it is, I alter my output accordingly. Hopefully that'll get you in the right direction.

 

[sleipnir214]

The function to send the query does not return the values. If the query is well-formed and syntactically valid in the context in which you've used it, then MySQL will return a handle to the data.

It's most like a file handle than anything, except there are specialized functions for retrieving the data from that handle.

If the handle returned is not null, the perl DBI should provide a method to the statement handle called "numrows":

$sth = $dbh->query('SELECT....');
print $sth->numrows;

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!