Hi Juan,
this reply will depend on the database type you're using...but some database
interprete true and false as -1 and 0 respectively rather than true and
false textually.
----- Original Message -----
From: "Juan Pablo Garcia" <[EMAIL PROTECTED]>
To: "REALbasic NUG" <[email protected]>
Sent: Thursday, February 23, 2006 9:03 PM
Subject: SQL object doubt
Hi:
If I do this query
select A.rowid,A.PlayerName from Players A, Teams T where
A.Team_ID=T.rowid and T.showMe = 'true'
I get nothing
But If I trim it to
"select A.rowid,A.PlayerName from Players A, Teams T where
A.Team_ID=T.rowid
I get results
The problem is that the column "showMe" is a boolean, and there are
records that indeed have the condition I´m looking for.
Can anyone tell me what am I missing? I think I´m not looking
correctly for a boolean "true"
thanks a lot,
JP
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
