|
|
Access to adding tickets in CREOLE: msg#00002
|
Subject: |
Access to adding tickets in CREOLE |
Hello,
i do not have acces to adding new tickets in Croele:
- http://creole.phpdb.org/trac//newticket
===
I have problem:
MSSQL Query "SELECT SCOPE_IDENTITY()" is not support in MS SQL 7.
query:
{{{
SELECT SCOPE_IDENTITY()
}}}
is not supported In MS SQL 7.
(/creole/drivers/mssql/MSSQLIdGenerator.php
line 56)
I have proposition to check MSSQL version:
{{{
SELECT @@VERSION
}}}
{{{
if(version >= 8) {
$query = "SELECT SCOPE_IDENTITY()";
} else {
$query = "SELECT @@IDENTITY";
}
}}}
Page of similar script:
http://cvs.php.net/viewvc.cgi/pear/MDB2/MDB2/Driver/mssql.php?revision=1.125&view=markup
Can I please to help me?
--
Regards,
Piotr Plenik
|
| |
