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 t
AND CHART_CODE IN ('99281','99282','99283','99284',
'99285','99291')
AND C.STATUS = 6
AND H.SENDING_FACILITY = 'AEU'
ORDER BY 1
________________
From: Kr
;99291')
AND C.STATUS = 6
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
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 s
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:
http://www.php.net/manual/en
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:
http://www.php.net/manual/en/function.mssq
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'
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.
Closing the gate once the horse i
