RE: [dev] OTRS with MS SQL Server
-----Original Message----- From: Martin Edenhofer [mailto:martin@edenhofer.de] Sent: Wednesday, July 09, 2003 10:29 AM To: dev@otrs.org Subject: Re: [dev] OTRS with MS SQL Server
Hi Holger,
The normal string is:
Old: 'open' New: 'closed successful'
But a ' would brake the SQL syntax so it will be quoted with \'.
On SAPDB you need to quote with ' instead of \ -=> '' instand of \'.
How is the quoteing on mssql? Also ''?
Hi Martin; yepp, its also ''. so, where do i have to change this? Holger
Hi Holger, On Wed, Jul 09, 2003 at 10:35:56AM +0200, Holger.Struck@sqs.de wrote:
yepp, its also ''.
so, where do i have to change this?
I improved the Kernel/System/DB.pm to detect different database types and use the preferences of the database. Just one more question and I send you a working Kernel/System/DB.pm for mssql. .-) Do you also need to quote \ on mssql?
Holger
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- "The number of Unix installations has grown to 10, with more expected." The Unix Programmer's Manual, 2nd Edition, June 1972
participants (2)
-
Holger.Struck＠sqs.de -
Martin Edenhofer