RE: [Bayonne-devel] Long sql query

[Julien Chavanton]

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