[Gambas-devel] Mysql Issue?

Ilja Lebedev mushketer888 at ...176...
Mon Oct 17 21:09:19 CEST 2011


2011/10/17 Ron <ron at ...572...>

>
> This works:
>
>   rResult = Main.hDB.Exec("SELECT * FROM events WHERE enabled IS TRUE ORDER
> BY name")
>
> This doesn't return records where enabled = TRUE
>
>   rResult = Main.hDB.Exec("SELECT * FROM events WHERE enabled IS &1 ORDER
> BY name", TRUE)
>
> I didn't expected this, correct?
>
> Gambas2, Ubuntu 11.04
>
> Regards,
> Ron_2nd.
>

>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure contains a
> definitive record of customers, application performance, security
> threats, fraudulent activity and more. Splunk takes this data and makes
> sense of it. Business sense. IT sense. Common sense.
> http://p.sf.net/sfu/splunk-d2d-oct
> _______________________________________________
> Gambas-devel mailing list
> Gambas-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-devel
>
> Maybe by SQL syntax.
SELECT * FROM events WHERE enabled=TRUE ORDER BY name
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.gambas-basic.org/pipermail/devel/attachments/20111017/dd1c7b57/attachment.html>


More information about the Devel mailing list