display boolean on webpage 1

[tradewise]

I have an access database that has a yes/no field. What I am attempting is to display the result of this field in a checkbox on a webpage.

If I use a text box it displays either 'true' or 'false' depending on the value in the database. As soon as I change it to a checkbox it just does nothing ie the checkbox remains unchecked.

Any help would be much appreciated.

Regards

 

[damber]

There are several ways, here is a simple example that should get you started. The main thing is that you must specify that the checkbox is 'checked' by using this attribute.

bYourValue = oYourRecordset.Fields("YourYesNoField")

if bYourValue = true then
response.write("<input type=""checkbox"" id=""someid"" name=""somename"" checked=""true"" />")
else
response.write("<input type=""checkbox"" id=""someid"" name=""somename"" />")
end if

A smile is worth a thousand kind words. So smile, it's easy!

 

[tradewise]

damber

it works a treat

I'll have this one tucked away for future use.

Thanks a lot

 

[damber]

No problem, glad to help.

A smile is worth a thousand kind words. So smile, it's easy!