ERROR AT EXPORT EXCEL

QuestionsERROR AT EXPORT EXCEL
pierre mata asked 4 years ago

Hello Abu, when i try with "select_command" send me an error when i try to export to excel, is like if the framework adds the clause "HAVING ORDER BY 1 asc". next show you what i try:

what i define in select_command:

"select inm.id,nombre,nolotes, lotetipo, m2cons, valor_lista,precio_lista, valor_contado, enganchep,enganche, apartado, plazo_enga, plazo_saldo,pagos, tasa_int, vol_venta, meses, tam from inm,estudy where inm.id=estudy.client_id and substr(fecha,1,7)='3013-11' and tipo=2 group by inm.id"

error when try export to excel:

Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY 1 asc' at line 1 – select inm.id,nombre,nolotes, lotetipo, m2cons, valor_lista,precio_lista, valor_contado, enganchep,enganche, apartado, plazo_enga, plazo_saldo,pagos, tasa_int, vol_venta, meses, tam from inm,estudy where inm.id=estudy.client_id and substr(fecha,1,7)='3013-11' and tipo=2 group by inm.id HAVING ORDER BY 1 asc

by the way, if i remove the part "group by inm.id", works…

2 Answers
Abu Ghufran answered 4 years ago

Emailed you an update.

Pierre Tremblay answered 4 years ago

terrific!!! thanks a lot!! works!!..

Your Answer

13 + 3 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?