[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Bayonne-devel] Long sql query
From: |
rfontan |
Subject: |
[Bayonne-devel] Long sql query |
Date: |
Fri, 5 Aug 2005 14:54:03 -0300 (ART) |
User-agent: |
SquirrelMail/1.4.4-rc1 |
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] Long sql query,
rfontan <=