checkbox syntax 1

[JohannIcon]

Hi All,

How can I arrange the syntax of this checkbox statement?

response.Write &quot;<input <% if rs1.Fields.Item(&quot;menuActive&quot.value = &quot;1&quot; Then Response.write(&quot; checked&quot : Response.Write(&quot;&quot%> name=menuCheck&quot; & n+1 & &quot; type=checkbox id=menuCheck value=&quot; & rs1(&quot;menuID&quot & &quot;>&quot;

 

[cbokowski]

dim sText
if rs1.Fields.Item(&quot;menuActive&quot.value = &quot;1&quot; then
sText = &quot; checked&quot;
else
sText = &quot;&quot;
response.Write &quot;<input&quot; & sText &&quot; name=menuCheck&quot; & n+1 & &quot; type=checkbox id=menuCheck value=&quot; & rs1(&quot;menuID&quot & &quot;>&quot;

 

[GabeC]

This is how I would write it

<%
response.Write &quot;<input&quot;
if rs1.Fields.Item(&quot;menuActive&quot;).value = &quot;1&quot; Then Response.write &quot; checked&quot; 
Response.Write &quot; name=menuCheck&quot; & n+1 & &quot; type=checkbox id=menuCheck&quot; & n+1 & &quot; value=&quot; & rs1(&quot;menuID&quot;) & &quot;>&quot;
%>

Thanks,

Gabe

 

[JohannIcon]

Oh Thanks very much mate!

 

[GabeC]

JohannIcon,

You may want to update your code to keep the &quot;name&quot; and &quot;id&quot; attributes the same. You change the &quot;name&quot; attribute but leave the &quot;id&quot; attribute the same.

Thanks,

Gabe

 

[JohannIcon]

why?

 

[GabeC]

If you are not going to keep them in sync, why use both? Why not just use name or id?
Thanks,

Gabe

 

[cbokowski]

Good Point Gabe. Missed that one.

I have another way for the code. I wrote my own iif function since vbscript is lacking one.

function iif(i_Expr, i_True, i_False)
if i_Expr then
iif = i_True
else
iif = i_False
end if
end function

response.Write &quot;<input&quot; & iif(rs1.Fields.Item(&quot;menuActive&quot.value = &quot;1&quot;,&quot; checked&quot; , &quot;&quot; )&&quot; name=menuCheck&quot; & n+1 & &quot; type=checkbox id=menuCheck value=&quot; & rs1(&quot;menuID&quot & &quot;>&quot;

 

[JohannIcon]

I have to use both cause then I need to do some insertion into different tables depending on these names