A very simple checkbox question

[programmher]

I've forgotten how to do this...

I have a query that is retrieving boolean data. I want to reflect the results in a checkbox on my form ("0" for no and "1" for yes).

How do I convert the results from boolean to an actual check on my form?

I've used the "yesnoformat" and "isboolean" options; but still no "check" in the appropriate boxes...

 

[calista]

Here is a small example from one of my pages. I store the value "Yes" or "No" in my database as a text field. Prior to this, I retreive the data from the database, and if the variable #ServiceFOPEN# is EQ "Yes", the box will be checked.

<INPUT TYPE=&quot;Checkbox&quot; NAME=&quot;FOPEN&quot;  VALUE=&quot;Yes&quot;<CFIF #SERVICEFOPEN# EQ &quot;Yes&quot;>checked</CFIF>>

Hope this points you in the right direction! Calista :-X
Jedi Knight,
Champion of the Force

 

[programmher]

Calista,

Thanks a million! That worked like a charm. I appreciate your help - and may the force continue to be with you!(*smile*) :-D