CURRENT_DATE is a constant in postgres. The select
is valid.
On Wed, Apr 11, 2001 at 05:42:58PM -0400, Baxter, Lincoln wrote:
> What are you selecting from? I do not think your select is valid SQL.
>
> -----Original Message-----
> From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 5:38 PM
> To:
> Subject: can't find selectrow_hashref
>
>
>
> Hello,
>
> I'm now using and enjoying the new features of DBI 1.15 (Thanks
> everyone!). I have an odd issue with the new method selectrow_hashref.
>
> When I to use it, I get the error:
> test.cgi: Can't locate object method "selectrow_hashref" via package "DBI
> ::db" at test.cgi line 32,
>
> I've verifed that I'm using the version of DBI I think I am, and that
> the handle is in fact valid. I
> I even double checked to make sure the function existed in the source
> code. :)
>
> Here's a test snippet that fails for me:
>
>
> use DBI;
>
> # a verifed connect string
> $DBH = DBI->connect("dbi:Pg:dbname=my_db;host=m_host.com,'username');
>
> $foo = $DBH->selectrow_hashref("SELECT CURRENT_DATE");
>
> #############
>
> 'selectall_hashref' works fine for me...
>
> Thanks for any ideas!
>
> (I'm using Postgres 7.0.3, by the way)
>
> -mark
>
> personal website } Summersault Website Development
> http://mark.stosberg.com/ { http://www.summersault.com/
