Skip to Content.
Sympa Menu

freetds - Re: [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: Re: [freetds] query fails
  • Date: Mon, 10 Dec 2007 16:22:35 -0600

Hi,

I encapusalted this query in a stored procedure, but it still gives me the
same query failed and read from server failed problem using the php_dblib
extension (If I use the php_mssql extension it works fine, but I cannot used
this extension because it gives me connections problems).

I do have non english characters in this table, like á or ñ, I dont now what
else to do.

Ricardo




On Dec 10, 2007 2:31 AM, Ricardo Guevara <rjguevara AT gmail.com> wrote:

> 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 <http://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 <http://r.id/> = RE.ID <http://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 <http://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
>



  • [freetds] query fails, Ricardo Guevara, 12/10/2007
    • Re: [freetds] query fails, Ricardo Guevara, 12/10/2007

Archive powered by MHonArc 2.6.24.

Top of Page