mike wrote:
> 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
This is telling you that $dbh is undefined. Your query is OK. (I assume
you have RaiseError turned on since you aren't checking for errors.)
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
