RE: Long sql query
"Julien Chavanton" <[email protected]>
| Newsgroups | gmane.comp.gnu.bayonne.devel |
|---|---|
| Message-ID | <[email protected]> |
140 is not enough there is 167 character in your query ;-) set.size 256 %query -----Original Message----- From: bayonne-devel-bounces+j.chavanton=oneworldinteractive.com@gnu.org [mailto:[email protected] g] On Behalf Of [email protected] Sent: August 5, 2005 1:54 PM To: [email protected] 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 [email protected] http://lists.gnu.org/mailman/listinfo/bayonne-devel