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/

Reply via email to