fly_mo
Posts: 109
|
| Posted: 06/03/2008, 7:18 AM |
|
Hello All,
I have an aggravating problem on what should be a simple issue. I'm using php/mysql CCS 4.
I create a report using the builder and also manually. I create a query with two tables one of which is only to show a text field for an ID stored in table one.
When I add my 3 where statements - active = true(boolean) and where Type_ID =1 or Type_ID =8, all as expressions. I view and all is well, but when I publish the report the report does not reflect the where statements at all - quite the opposite in fact
I must be missing something very basic - any ideas.
Thanks
John
_________________
John |
 |
 |
mentecky
Posts: 321
|
| Posted: 06/03/2008, 7:40 AM |
|
John,
Try "active = 1". MySQL changed to tiny ints for booleans.
Rick
_________________
http://www.ccselite.com |
|
|
|
fly_mo
Posts: 109
|
| Posted: 06/03/2008, 7:46 AM |
|
DOH! I knew that.......
Thanks Rick - worked like A charm.
Regards
John
_________________
John |
|
|
|
mentecky
Posts: 321
|
| Posted: 06/03/2008, 7:48 AM |
|
My other suggestion is did you put parens around the two Type_ID statements? You do that in the builder by selecting both statements and clicking the "()" icon.
Rick
_________________
http://www.ccselite.com |
|
|
|
mentecky
Posts: 321
|
| Posted: 06/03/2008, 7:48 AM |
|
No Problem!
Glad to help,
Rick
_________________
http://www.ccselite.com |
|
|
|
|
