U++ framework: U++ SQL » MySql, boolean values and SqlArray

Home » U++ Library support » U++ SQL » MySql, boolean values and SqlArray

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: MySql, boolean values and SqlArray [message #45961 is a reply to message #45927]

Sun, 31 January 2016 20:29

mirek
Messages: 14291
Registered: November 2005

Ultimate Member

bool types in SQL are bit of mess. That is why I am usually using single char value there.

However, this should work fine. I believe that the issue here is that

query * Select(ID, NAME).From(MACHINISTS).Where(M1 == true);

gets converted to

query * Select(ID, NAME).From(MACHINISTS).Where(M1 == 1);

Fix is easy, use

query * Select(ID, NAME).From(MACHINISTS).Where(M1 > 0);

(Note that when developing SQL, it is always a good idea to have activated SQL log at least in debug mode - SqlSession::SetTrace())

Report message to a moderator

[Message index]

		MySql, boolean values and SqlArray By: Giorgio on Wed, 27 January 2016 10:00
		Re: MySql, boolean values and SqlArray By: deep on Thu, 28 January 2016 06:24
		Re: MySql, boolean values and SqlArray By: Giorgio on Thu, 28 January 2016 08:58
		Re: MySql, boolean values and SqlArray By: deep on Thu, 28 January 2016 18:21
		Re: MySql, boolean values and SqlArray By: mirek on Sun, 31 January 2016 20:29
		Re: MySql, boolean values and SqlArray By: Giorgio on Mon, 01 February 2016 08:59
		Re: MySql, boolean values and SqlArray By: mirek on Mon, 01 February 2016 18:31

Previous Topic:	Problem with SqlUpdate
Next Topic:	How to close a sqlite session

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 08 12:04:43 GMT+2 2026

Total time taken to generate the page: 0.00902 seconds