On Tue, 22 Oct 2002 07:50:06 -0500 George Mayne <[EMAIL PROTECTED]> wrote:
> In the "while" statement you're missing the $website between $email2 &
> $available_hours1.
With as many columns as you have, it would be easier and _much_ more
efficient to retreive the values with $sth->bind_columns(). It would have
also complained if you gave the wrong number of columns.
Short example (untested):
$dbh -> {RaiseError} = 1
my $sth = $dbh -> prepare( ... );
$sth -> bind_columns( \( $v1, $v2, $v3, ... ) );
$sth -> execute;
while ( $sth -> fetch ) {
# do something with $v1, $v2, $v3, ...
}
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
