[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: [Bayonne-devel] Long sql query
From: |
Julien Chavanton |
Subject: |
RE: [Bayonne-devel] Long sql query |
Date: |
Fri, 5 Aug 2005 14:27:36 -0400 |
140 is not enough there is 167 character in your query ;-)
set.size 256 %query
-----Original Message-----
From: address@hidden
[mailto:address@hidden
g] On Behalf Of address@hidden
Sent: August 5, 2005 1:54 PM
To: address@hidden
Subject: [Bayonne-devel] Long sql query
Hi everybody. I need to perform a long sql select command to retrieva
some
data from mysql. The code goes like this:
set.size 140 %querySelect "select autoriza,barra from consumos where
nro_socio='" %nro_socio "' and COD_PRESTA='" %cod_presta "' and
FECH_ORDEN<='" %fech_orden "' and FECH_ORDEN >= '2003-04-01'"
The problem is that the sql command gets truncated like this:
select autoriza,barra from consumos where nro_socio='131850330500' and
COD_PRESTA='1420101' and FECH_ORDEN<='20
Does anybody know how to deal with this problem?
Thanks a lot !
Roberto from Mendoza, Argentina
_______________________________________________
Bayonne-devel mailing list
address@hidden
http://lists.gnu.org/mailman/listinfo/bayonne-devel