What is the best column type to use for checkbox I have 30 to add and don't want to use excess memory.

Wayne

ENUM (yes, no)
========================================
Buh Bye!

Cheers,
Me

I changed all the entries many thanks for the advice it is greatly appreciated.

However, taking one entry for example:

WATER which I have set as ENUM (Yes,No) as suggested

Under FORM INFORMATION I have

Form Display = Water
Form Type = Checkbox


What goes in Form Names and Form Values

I have tried various and get, when adding or modifying : (This example Water also tried 0 and -1)




Regards

Wayne

Form Names: Yes,No
Form Values: Yes,No

on seperate lines.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Many thanks it works but the result is not what I wanted or expected.

I have the entry Water [] which I want to be either blank or ticked, this is so I can test 'Water' on display to display only if the field is occupied. Perhaps I am cracking the nut with a big hammer :-) and approaching the task wrongly.

I have 30 options and I want the user to check off what are applicable, naturally if Water was clicked by mistake it needs to be blanked or nulled.

However, if I have the Yes, No how would I test for it in LSQL template syntax something like

If <%Water%> = "Yes" then do something .... or:
If <%Water%> = "No" then do nothing

With:

<%if Water%>
<%icon_water%>
<%endif%>

displays icon_water if the entry is Yes or No.

Regards

Wayne

You need to use the following:

<%if Water eq 'Yes'%>
<%icon_water%>
<%endif%>
========================================
Buh Bye!

Cheers,
Me

Many thanks .... I must have missed eq in the manual or on the help pages. Many thanks it is appreciated.

Wayne