[freetds] query fails
Ricardo Guevara
rjguevara at gmail.com
Mon Dec 10 03:31:09 EST 2007
Hi,
I'm using php_dblib in a windows 2000 server connecting to a mssql server
2000. I have a problem with a query that works fine using the previous
extension php_mssql.dll but gives a strange error using the php_dblib:
[Mon Dec 10 02:14:52 2007] [error] [client 63.161.232.61] PHP Warning:
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]:
Read from the server failed (severity 9) in
C:\\Inetpub\\wwwroot\\adminticker\\lower.php on line 40, referer:
script.php
[Mon Dec 10 02:14:52 2007] [error] [client 63.161.232.61] PHP Warning:
mssql_query() [<a href='function.mssql-query'>function.mssql-query</a>]:
Query failed in C:\\Inetpub\\wwwroot\\adminticker\\lower.php on line 40,
referer: script.php
the query in question is somewhat complex:
SELECT top 50 RE.TEXTO_DE_RESPUESTA FROM RESPUESTAS_RECIBIDAS_TABLA_00 RE
LEFT OUTER JOIN (
SELECT R.ID FROM RESPUESTAS_RECIBIDAS_TABLA_00 R, EXPRESIONES_INVALIDAS E
WHERE (FECHA_DE_RESPUESTA_RECIBI >= CONVERT(DATETIME, '2007-12-10', 102)
AND FECHA_DE_RESPUESTA_RECIBI <= CONVERT(DATETIME, '2007-12-10 23:59:59',
102) AND ESTADO IS NULL) AND TEXTO_DE_RESPUESTA LIKE '%' + E.palabra + '%')
R
ON R.ID = RE.ID WHERE (RE.FECHA_DE_RESPUESTA_RECIBI >= CONVERT(DATETIME,
'2007-12-10', 102)) AND (RE.FECHA_DE_RESPUESTA_RECIBI <= CONVERT(DATETIME,
'2007-12-10 23:59:59', 102))
AND (R.ID IS NULL) AND (RE.TEXTO_DE_RESPUESTA <> '')
ORDER BY RE.FECHA_DE_RESPUESTA_RECIBI DESC
I can't find the problem, help please!
Ricardo
More information about the FreeTDS
mailing list