CheckBox Checked 1

[PhatH]

Hello all,

I have a checkbox that's supposed to check if its value is 1 or blank if value is 0 (data was set in BIT in database), this is my code

<input type="checkbox" value=<% =rs("New") %> name="new" <% if (rs("New") = 1) then response.write ("Checked") %>>

It's not working, could someone point out the mistake(s) for me.

Thanks!

 

[onpnt]

can you view the source of the outputted HTML and see if it indeed is writing out the checked?

from the way the code looks you may be getting this
<input type="checkbox" value= 1 name="new" Checked>
I don't think the space after the <% will cause a space but it may.


ALWAYS surround the attributes of any tag with quotes as you have done for name etc..

That _1 may be killing the rest of the tag



___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064

 

[PhatH]

I created this line: <% response.Write(rs("New")) %>

and got TRUE and FALSE for the outputs, but when I rewrite:
<input type="checkbox" value=<% =rs("New") %> <% if (rs("New") = "True") then response.write ("Checked") %>>

Still, nothing has changed.

 

[onpnt]

try

<input type="checkbox" value="<%=rs("New")%>" <%If rs("New") then response.write("Checked")%>>

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064

 

[PhatH]

Thank onpnt, that works great. But don't we need to specify whether rs("New") = "something" ???

 

[onpnt]

no. simply stating If rs("New") checks to see if it is equal to True or False

Glad that did it!

___________________________________________________________________

http://www.onpnt.com

The answer to your ??'s may be closer then you think. faq333-3811
Join the Northern Illinois/Southern Wisconsin members in Forum1064

 

[PhatH]

Well, thank you very much!!