On Wed, 11 Apr 2001, Baxter, Lincoln wrote:
> What are you selecting from? I do not think your select is valid SQL.
Actually, for PostgreSQL, it is a valid statement -- CURRENT_DATE is a
global variable that always holds the current date. This SQL statement
should return a single row with 4-11-2001 (or whatever date format that is
being used).
Does the DBD need to be rebuilt and instaleld against the new DBI version?
-- Brett
> -----Original Message-----
> From: Mark Stosberg [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 5:38 PM
> To: [EMAIL PROTECTED]
> 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/
>
http://www.chapelperilous.net/btfwk/
------------------------------------------------------------------------
If I had a Q-TIP, I could prevent th' collapse of NEGOTIATIONS!!
