« Return to Thread: Mysql Issue?

Re: Mysql Issue?

by mushketer888 (Bugzilla) :: Rate this Message:

| View in Thread


2011/10/17 Ron <ron@...>

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@...
https://lists.sourceforge.net/lists/listinfo/gambas-devel

Maybe by SQL syntax.
SELECT * FROM events WHERE enabled=TRUE ORDER BY name

------------------------------------------------------------------------------
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@...
https://lists.sourceforge.net/lists/listinfo/gambas-devel

 « Return to Thread: Mysql Issue?