I have the following query which works in psql
SELECT to_char('05 Feb 2005'::date,'YYYY-MM-DD')
However when I run it in DBI I get
$row6=$dbh->prepare("SELECT to_char('2005-02-05'::date,'YYYY-MM-DD')");
#$row6->bind_param(1,'2005-02-05');
$row6->execute();
Can't call method "prepare" on an undefined value at /home/www/cgi-
bin/times_upd_multi.pl line 46., referer: http://localhost/cgi-
bin/times_input_mult.pl
(I have tried various variations)
anyone any idea of a workaround?
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
