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>

Reply via email to