checkbox load ticked if yes/no field is yes

[junglist666]

<input class="txtbox" type="checkbox" name="C1" value="ON"
  <%if lcase(rsProperty("display"))="yes" then Response.write " checked " %> >

im tryin to make my checkbox be ticked if the field (yes/no datatype) is yes.

this above code produces no errors but the box isnt ticked when the page loads.. anyone know why?

 

[guitardave78]

I tend to make the value in the database either "checked" or "" and then in the checkbox us
<input class="txtbox" type="checkbox" name="C1" value="ON"
<%Response.write (rsProperty("display")) %> >

Make sure that rsProperty is returning yes when you think it is as your code should work


}...the bane of my life!

http://www.fuzzyd.co.uk

 

[onpnt]

yes/no fields are reported back as true/false I believe


Your troubleshooting should also start with...viewing the sorce code output to see if your code is generating the correct "cehcked" value based on the rs


General FAQ faq333-2924
5 steps to asking a question faq333-3811

 

[guitardave78]

yeah just response.write(rsProperty("display")) and see what it is acutally bringing out


}...the bane of my life!

http://www.fuzzyd.co.uk

 

[junglist666]

yes it was outputting true or false so i changed the yes to true and it works, thank you