[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