Skip to Content.
Sympa Menu

freetds - [freetds] query fails

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Ricardo Guevara" <rjguevara AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] query fails
  • Date: Mon, 10 Dec 2007 02:31:09 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page