on Fri, 24 May 2002 21:56:58 GMT, Shaunn Johnson wrote:
> So, this is what I'm doing: I connect to the
> database, get a count of records and bring
> back that number. At least it looks good on
> paper ... but now I need to evaluate it as
> a number and not as a list item (if I'm making
> any kind of sense).
For queries returning a single number, I usually do
my ($count) = $dbh->selectrow_array("SELECT COUNT(*) FROM table");
if ($count > 10_000) {
# do this
} else {
# do that
}
--
felix
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
