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: [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/