U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

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

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

Return to the default flat view

Create a new topic

Submit Reply

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

Sun, 31 January 2016 20:29

mirek is currently offline

mirek
Messages: 13976
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

Send a private message to this user

[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) ] [

] [

PDF

]

Current Time: Thu May 09 01:38:26 CEST 2024

Total time taken to generate the page: 0.03034 seconds