RE: rows returned and while statement

2005-04-27 Thread Giff Hammar
You could use this after the while loop: if ($sth->rows() == 0) { # First offense code } Giff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 26 April, 2005 11:24 To: beginners@perl.org Subject: rows returned and while statement Ok I have an is

Re: rows returned and while statement

2005-04-26 Thread Jay Savage
On 4/26/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Ok I have an issue where I run an sql query against a database, and want > to evaluate whether or not an entry occurs for a given user, if NOT then > this run will be the first entry. Ok the problem occurs in the while > statement, everythi

rows returned and while statement

2005-04-26 Thread christopher . l . hood
Ok I have an issue where I run an sql query against a database, and want to evaluate whether or not an entry occurs for a given user, if NOT then this run will be the first entry. Ok the problem occurs in the while statement, everything works as expected if the user already has an entry in the DB,