codefreak.de

Notiz:

While trying to return a @@IDENTITY after an INSERT statement, the only way I could get a valid return result was to encapsulate the query within an EXEC like so:

$result = mssql_query(”
exec(”
INSERT INTO Files
(ownerId, name, sizeKB, path)
VALUES (‘$contactId’, ‘$userfile_name’, ‘$filesize’, ‘$path’)
SELECT @@IDENTITY as fileId”)
“);
list($fileId) = mssql_fetch_row($result);

This returned the appropriate @@IDENTITY in a valid result set. Not sure if mssql supports multiple inline commands or not. But that assumption would back the useage of the EXEC command in order to execute these properly.
(fundstelle: PHP Resource)

This entry was posted on Thursday, December 16th, 2004 at 12:00 and is filed under Bauen, Notizen. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.