Re: undefined method DB_mssql::lastInsertId() ??

Simon Mundy wrote:

DB::connect looks like a PEAR factory method - are you sure you're  
using Zend Framework? If not, you'd need to post to a PEAR mailing list.


> Hello! I'm constantly running in to these types of issues. I must be  
> doing something fundamentally wrong. I've instantiated a database  
> connection like so:
>
> //  
> ----------------------------------------------------------------------
> $dsn = $config->dbadaptor . "://"       // Build a DSN string (Data  
> Source Name)
> . $config->username . ":"        // Required by DB::connect()
> . $config->password . "@"
> . $config->host . "/"
> . $config->dbname;
>
> $db = DB::connect($dsn, TRUE);
>
> if (DB::isError($db)) {
> die($db->getMessage());
> }
>
> $this->db = $db;
> //  
> ----------------------------------------------------------------------
>
>
> Later in my code, I do something like this:
>
> //  
> ----------------------------------------------------------------------
> $sql = "INSERT INTO $table_name (" . implode(',',
> $transformed_keys) . ') VALUES ( ' . implode(',',$values) . ' ) ';
>
> $result = $this->db->query($sql);
> $id = $this->db->lastInsertId();
> //  
> ----------------------------------------------------------------------
>
> Unfortunately, I get the error, "undefined method  
> DB_mssql::lastInsertId()". What am I doing wrong?
> Thanks!
> - Bret
> View this message in context: undefined method  
> DB_mssql::lastInsertId() ??
> Sent from the Zend Framework mailing list archive at Nabble.com.

--

Simon Mundy | Director | PEPTOLAB

""" " "" """""" "" "" """"""" " "" """"" " """"" "  """""" "" "

Please support Movember today!  Visit http://www.movember.com/au/donate
Registration number for Simon 160725

202/258 Flinders Lane | Melbourne | Victoria | Australia | 3000
Voice +61 (0) 3 9654 4324 | Mobile 0438 046 061 | Fax +61 (0) 3 9654  
4124
http://www.peptolab.com