[Gambas-user] Can't exec an sql string

[Fabien Bodard]

2006/10/23, Fabricio Silva <buxaman at ...626...>:
>
> Hello guys,
>
> I have this sql:  "select price from product order by cast (price as
> char)"
> When I execute this sql inside phpMyAdmin it comes with the right result.
> But when executing the sql inside Gambas 1.9.34 it comes with the error:
> "Query failde: 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('price, ....."
> I'm using price as varchar because in Brazil we use 147,00 instead of
> 147.00and I haven't figure out yet a way of showing the result with
> ","  whether
> than dot when I use decimal or float types.



and the 'format' command ?

format(value,pattern)

Regards
> Fabricio Silva
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>