note 868 deleted from ref.odbc by sniper
| From: | sniper@php.net | Date: | Tue, 04 Nov 2003 00:36:26 +0000 |
| Subject: | note 868 deleted from ref.odbc by sniper | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-59745@lists.php.net to get a copy of this message | ||
Note Submitter: fjohansson@bigfoot.com
----
A common problem with many ODBC drivers (especially thoose from Microsoft) is that it is impossible
to eg returning an ordernumber after inserting the row into the table. The solution is simple,
make one field in the db to a counter, and one to a temp field(text50). While inserting the row set
the temp field to microtime() (or any other uniqe number). Then do a SELECT for this row (where
temp=$microtimeinserted...). / Fredrik Johansson