help with checkbox issue

[PushCode]

I need to put checks in checkboxes that are associated with a given record. I'm getting a syntax error, and I'm not sure why. Any help would be appreciated. Here's the line where I'm getting the error:

response.write  cellstart & "<input type=""checkbox"" name=""opt"" " & if cint(rsOpt(& ""opt_id"" &)) = cint(qOpt(& ""opt_id"" &)) then & " checked=checked" & end if &" value="""& opt_id &""" />" & opt_name & "</td>"

Thanks

 

[monksnake]

You need to put single quotes inside double quotes and such like the following:

response.write  cellstart & "<input type='\'checkbox\'' name='\'opt\''" & if cint(rsOpt(& "'opt_id'" &)) = cint(qOpt(& "'opt_id'" &)) then & " checked='checked'" & end if &" value='"& opt_id &"' />" & opt_name & "</td>"

<.

 

[dtqbterror]

Use single quotes in place of the double quotes except to specify the strings. Using a double quote as escape character just confuses the code.

example
cellstart & "<input type='checkbox' name='op' " &

http://www.chiefscoalition.com

 

[monksnake]

Yeah my code is not right, I have too many nested quotes.
Didn't think about what I was writing, just wrote it.


<.

 

[monksnake]

Here:

response.write  cellstart & "<input type='checkbox' name='opt' " & if cint(rsOpt(& "'opt_id'" &)) = cint(qOpt(& "'opt_id'" &)) then & " checked='checked'" & end if &" value="'& opt_id &'" />" & opt_name & "</td>"

There I had to redeem myself



<.

 

[PushCode]

Thanks. I tried your sugestions many different ways, but had no luck so I went a different route.

Here's what I did:

If opt_id = theOptID Then
							    response.write cellstart & "<input type='checkbox' name='opt' value='" & opt_id & "' checked='checked'>" & opt_name & "</td>"
							Elseif theOptID = "" Then
							    response.write cellstart & "<input type='checkbox' name='opt' value='" & opt_id & "'>" & opt_name & "</td>"
							End If