Hi, I have problems with mssql_get_last_message(). This function doesen't return the whole error message, it only returns "Die Anweisung wurde beendet" and not the specific error message. Now I use something like this to workaround the problem:
... snip ... $this->errno = mssql_result(@$this->priv_query('SELECT @@ERROR as errorcode', $this->dbc), 0 , 'errorcode'); $this->error = mssql_result($this->priv_query("SELECT description FROM master.dbo.sysmessages WHERE error=$this->errno and msglangid = 1031", $this->dbc), 0, 'description'); $this->error = str_replace ('%', '%%', $this->error); but the problem is, that I get the error message with placeholders (not parsed): Die %1!-Anweisung verstieß gegen die %2! %3!-Einschränkung '%4!'. Der Konflikt trat in der %6!-Datenbank, Tabelle '%8!'%10!%11!%13! auf.) are there any hints to get mssql_get_last_message() to work? bye, -- -------------------------------------- Michael Bretterklieber LCP JAWA Management Software GmbH Liebenauer Hauptstr. 200 A-8041 GRAZ Tel: ++43-(0)316-403274-12 Fax: ++43-(0)316-403274-10 GSM: ++43-(0)676-93 96 698 [EMAIL PROTECTED] homepage: http://www.jawa.at --------- privat ----------- E-mail: [EMAIL PROTECTED] homepage: http://www.inode.at/mbretter -------------------------------------- "...the number of UNIX installations has grown to 10, with more expected..." - Dennis Ritchie and Ken Thompson, June 1972 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php