Autoforme: search on boolean #30
Replies: 2 comments
-
Google Group Date: Fri, 4 Aug 2017 17:51:00 -0700 On Friday, August 4, 2017 at 5:08:29 PM UTC-7, Kenneth Leung wrote:
I think this is a bug in AutoForme. The search filters should probably do Thanks, |
Beta Was this translation helpful? Give feedback.
-
Google Group Date: Mon, 7 Aug 2017 18:36:25 -0700 Hi Jeremy, The version on Github fixed the search issue. Thank you. Kenneth On Friday, August 4, 2017 at 5:51:00 PM UTC-7, Jeremy Evans wrote:
|
Beta Was this translation helpful? Give feedback.
-
Google Group Post: https://groups.google.com/g/ruby-forme/c/oeM5mMeSQ70
Google Group Date: Fri, 4 Aug 2017 17:08:29 -0700
Google Group Sender: alpha...@gmail.com
Hi,
Autoforme searchs with the SQL statement below:
SELECT * FROM
reservations
WHERE (reservations
.deductible
= 't')ORDER BY
id
DESC LIMIT 26However, the correct SQL statement should be this (when DB is sqlite):
SELECT * FROM
reservations
WHERE (reservations
.deductible
= 1) ORDERBY
id
DESC LIMIT 26so how do I tell Autoforme to search with a 1 instead of a 't'?
Also, how can I tell Autoforme what databaseI am using? ie: I am using
SQLITE for test and MSSQL for production.
SQLite do not have boolean data type and thus Sequel is smart enough to use
1 instead.
But when I move this Autoforme app to production, I don't want to use
either 1 or 't', but a True instead.
Beta Was this translation helpful? Give feedback.
All reactions