Long sql query

[email protected]
Newsgroups gmane.comp.gnu.bayonne.devel
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.