Thanks, I'll have a look at this also. Is this the recommended way then for
what I am doing with the data.?
Gav...
| Also, I would recommend you consider using placeholders for all values
| passed to your prepare statement.
|
| eg. my $sth = $dbh->prepare('SELECT email_address FROM users WHERE
| email_address = ?') || die $dbh->errstr();
| $sth->execute($email) || die $dbh->errstr();
|
| but looking at your query I think you would be better off doing:
|
| my $rec = $dbh->selectrow_hashref(<<EOS,{}, $email) || die
| $dbh->errstr();
| SELECT email_address FROM email_address WHERE email_address = ?
| EOS
|
| print $rec->{email_address},$/;
|
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 25/03/2005
