oops my mistake... I had in mind when I made a query and do $sth->execute , is there place I can see such info w/o making another query or the same query (mean the same WHERE-clause) with count(*) to get this info ....
|
|
|
|>Is there a way to see if there is at least one record returned w/o making
|seperate SELECT COUNT(*) FROM ...
|>And this via Perl DBI ...
|
|Well, I don't know anything about Perl, but in general I would do a
|
|SELECT 1 FROM RDB$DATABASE WHERE EXISTS(SELECT 1 FROM ...)
|
|If this returns one row, there should be at least one row present, if it
|doesn't there is no row fitting your criteria.
|
|HTH,
|Set
|
|
|To unsubscribe from this group, send an email to:
|ib-support-unsubscribe@egroups.com
|
|
|
|Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
|