2:04 PM
To: Weaver Hickerson
Cc: PHP DB
Subject: Re: [PHP-DB] PHP4, mssql_* and SQL Server 2005
Ouch! That was like the.. longest.. query that I've ever seen! I'm
surprised that it actually works and even more impressed that someone
actually figured that out... It might take a long time to run
Hi!
Have you checked that the query is escaped correctly? All single quotes
(') needs to be escaped with another single quote, but that has been for
MS-SQL all the time so I'll doubt that the problem is escaping.
Another issue I noticed is that SQL Server 2005 handles SMALLDATETIME
coulmns
Karlström [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2008 3:31 AM
To: Weaver Hickerson
Cc: PHP DB
Subject: Re: [PHP-DB] PHP4, mssql_* and SQL Server 2005
Hi!
Have you checked that the query is escaped correctly? All single quotes
(') needs to be escaped with another single quote
AND H.SENDING_FACILITY = 'AEU'
ORDER BY 1
From: Krister Karlström [EMAIL PROTECTED]
Sent: Wednesday, November 05, 2008 3:31 AM
To: Weaver Hickerson
Cc: PHP DB
Subject: Re: [PHP-DB] PHP4, mssql_* and SQL Server 2005
Hi!
Have you checked
Weaver Hickerson wrote:
Greetings to the group. We have a PHP4 application that we moved to SQL server 2005 from
SQL server 2000. Everything seems to work fine except for so far we have found 2 queries
that break. Pointing back to the SQL Server 2000 server, they work fine
again.
If it's
Please always cc the mailing list so others can offer extra
advice/suggestions etc.
Weaver Hickerson wrote:
they work in query analyzer.
ok so the queries aren't the problem.
do you get an error? what is it?
Might need to play with these settings:
Chris wrote:
Please always cc the mailing list so others can offer extra
advice/suggestions etc.
Weaver Hickerson wrote:
they work in query analyzer.
ok so the queries aren't the problem.
do you get an error? what is it?
Might need to play with these settings: