Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2002
    Posts
    6

    Post Unanswered: Checkbox with the same name truncates at a space

    When I use SQL to populate a checkbox and give the checkboxes all the same name, when I retrieve it a name containing a space is truncated at the space. How can I get the whole name?

    <%while NOT rs.EOF%>
    <INPUT TYPE=CHECKBOX NAME="code" value=<%=rs("code")%> <%If request.Form("code") = rs("code") then%> CHECKED <%End If%>><%=rs("code")%><br>
    <%rs.MoveNext
    wend
    rs.Close%>

    strStatus_code = Request.Form("code")

    gives me Active, Inactive, Phase

    what I want is gives me Active, Inactive, Phase Out


  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    This is not a problem with SQL, but with the way you are writing out the values.

    Place quotes around the value when you write them out for display, so that when you do a view source from the browser you should see.

    "Active"
    "Inactive"
    "Phase Out"


    <%while NOT rs.EOF%>
    <INPUT TYPE=CHECKBOX NAME="code" value=" <%=rs("code")%>"
    <%If request.Form("code") = rs("code") then%> CHECKED <%End If%>>" <%=rs("code")%>" <br>
    <%rs.MoveNext
    wend
    rs.Close%>
    MCDBA

  3. #3
    Join Date
    Mar 2002
    Posts
    6

    Talking

    Worked perfectly!! Thank you. Suzy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •