Re: Getting started with MDB2 - got it!

My problem was that my SQL class is a wrapper around MDB2. Obviously the =
SQL
class didn't have a lastInsertID() method of its own (but now it does!):

public function InsertID() {
return $this->db->lastInsertID();
}

Thanks for all the help,

Yves

------ Original Message ------
Received: Mon, 08 Sep 2008 02:02:44 PM CDT
From: "Evert Lammerts"
To: "YVES SUCAET" Cc: php-db@lists.php.net,
hbabka@iastate.edu
Subject: Re: [PHP-DB] Getting started with MDB2

Have a look at this:
http://wiki.pooteeweet.org/index.php?area=3DMDB2&page=3DExam pleS&view=3Dd=
iff&to=3D2006-05-25%2010:27:49&from=3D2006-03-22%2011:08:24

It loads the Extended module....

On Mon, Sep 8, 2008 at 8:55 PM, YVES SUCAET wrote:
> Interesting. I'm following the documentation at
> http://pear.php.net/manual/en/package.database.mdb2.intro-se quences.php=

>
> Here's my code:
>
> $sql =3D new SQL();
> $sql->connect(DSN_METNET3_MY_EDIT);
> $qry =3D "insert into List(lstName, lstNotes, UserName) values (=
$name,
> $notes, $user)";
> $sql->query($qry);
> return $sql->lastInsertID("List");
>
> I'm now getting the following error message: Call to undefined method
> SQL::lastInsertID()
>
> Any further clues?
>
> Yves
>
> ------ Original Message ------
> Received: Mon, 08 Sep 2008 01:29:42 PM CDT
> From: "Evert Lammerts"
> To: "YVES SUCAET" Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Getting started with MDB2
>
>> * mysql_last_insert_id()
>
> getAfterId()
>
>
http://pear.php.net/reference/LiveUser_Admin-0.3.3/LiveUser_ Admin/LiveUse=
r_Admin_Storage_MDB2.html#methodgetAfterId
>
>> * mysql_real_escape_string()
>
> escape()
>
>
http://pear.php.net/package/MDB2/docs/latest/MDB2/MDB2_Drive r_Common.html=
#methodescape
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php