ID: 32241
Updated by: [EMAIL PROTECTED]
Reported By: kangtk at 163 dot com
Status: Bogus
Bug Type: Feature/Change Request
Operating System: Windows2000 Server
PHP Version: 4.3.10
New Comment:
It is possible to obtain this value from the server with an explicit
sql statement:
INSERT INTO jobs (job_desc,min_lvl,max_lvl) VALUES
('Accountant',12,125)
SELECT @@IDENTITY AS 'Identity'
Previous Comments:
------------------------------------------------------------------------
[2005-07-27 11:12:48] [EMAIL PROTECTED]
The underlying library doesn't provide something like that, so PHP
doesn't provide a wrapper.
There is nothing we can do, ask MS about it.
------------------------------------------------------------------------
[2005-07-27 04:05:48] Daniel dot Spada at det dot wa dot edu dot au
To expand on the previous poster. I have found that there is no such
function mssql_insert_id() when using MS-SQL server.
I am using PHP 4.3.10-15, with SQL server 2000. A mssql_insert_id
function would be REALLY handy to assist in error checking etc.
------------------------------------------------------------------------
[2005-03-09 03:10:31] kangtk at 163 dot com
Description:
------------
I can use this function mysql_insert_id to get the insert id when I
connect with mysql database.
But I cann't use the mssql_insert_id when I change the code to
Microsoft Sql server databse.
Can you explain something to me?
Thanks.
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=32241&edit=1
