Larry
|
| Posted: 07/25/2002, 6:12 AM |
|
I have a OK_to_SHOW field in my table I want my web page to show only record where OK-to-SHOW is true it's a boolean one how to write the code in CCS within PHP I can't access on
thanks for your help
|
|
|
 |
George L.
|
| Posted: 07/25/2002, 6:56 AM |
|
What does your query look like?
|
|
|
|
Andrew I
|
| Posted: 07/25/2002, 7:12 AM |
|
If you're using CCS then start by:
-select the grid that you're using to list the records
-in the Properties:Data tab click the ... button for DataSource
-You should see a DataSource dialog box showing the details of the table/query
This is where you can make the adjustment to show the records you want.
-Click the button with a '+' under "where"
-Select the OK_to_SHOW field from the FieldName box on the left
-Select equals(=) from the the condition box
You only want records where OK-to_SHOW is true...
-Type True in the first 'Parameter Source' box (or, if using MySQL, you'll probably have to type the digit 1 )
-Select 'Expression' for the parameter type below.
Click 'OK'
and you should see the parameter 'OK_to_SHOW equals(=) '1' appear in the list.
That I think is the basic procedure; may need some fine tuning. It might be necessary to select 'Integer' as the field type if you're using 1/0 for true/false.
Rgds
Andrew
|
|
|
|
Larry
|
| Posted: 07/25/2002, 7:26 AM |
|
Georges
I have the same query like in every ccs file I want only to know what to
add to it to assing show records with OK_to_SHOW = true
SELECT * FROM evnts where "OK_to_SHOW="true"";
Could you help me on how doing in CCS
|
|
|
|
Larry
|
| Posted: 07/25/2002, 7:26 AM |
|
Georges
I have the same query like in every ccs file I want only to know what to
add to it to assing show records with OK_to_SHOW = true
SELECT * FROM evnts where "OK_to_SHOW="true"";
Could you help me on how doing in CCS
|
|
|
|
RonB
|
| Posted: 07/26/2002, 4:26 AM |
|
could depend on your database. What does your DB return for true and false mysql returns 0 or 1
this would work in any case:
Lets assume 0 means no show and 1 means show->
select somefield from sometable
where OK_to_show=1
|
|
|
|
