140 is not enough there is 167 character in your query ;-) set.size 256 %query
-----Original Message----- From: [EMAIL PROTECTED] [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 _______________________________________________ Bayonne-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/bayonne-devel
