Checkbox - checked - uncheked in the EDIT mode

Discussion in 'C#' started by ewb13, Apr 3, 2009.

  1. #1
    Hi guys

    Using Classical ASP code

    Access - field name: aprova_jpg_sim - Type: "Yes/No"

    I show part of the code...

    ======== INSERTING ============

    ' 0 = false
    ' 1 = true

    If var_aprova_jpg_sim = "checkbox" then
    var_aprova_jpg_sim = 1
    else
    var_aprova_jpg_sim = 0
    end if


    ======== EDITING ============

    When I EDIT the register the checkbox does not show "checked"
    it remains "unchecked"

    Part of the code below....

    select case Request.QueryString("salvar")
    case "ok"
    :
    :
    var_aprova_jpg_sim = Request.Form("c_aprova_jpg_sim") '11
    :
    :
    :
    if var_aprova_jpg_sim = "" then var_aprova_jpg_sim = Chr(10)
    :
    :
    var_aprova_jpg_sim = Replace(var_aprova_jpg_sim , "<", "&lt;")
    var_aprova_jpg_sim = Replace(var_aprova_jpg_sim , ">", "&gt;")
    var_aprova_jpg_sim = Replace(var_aprova_jpg_sim , "'", "''")
    :
    :


    SQL = "UPDATE tabela SET nome_resp_vendas = '" & var_nome_resp_vendas ....
    & var_horario_entr_arq & "', aprova_jpg_sim = '" & var_aprova_jpg_sim & "', aprova_jpg_nao = '" & var_aprova_jpg_nao & "' WHERE id = " & Request.QueryString("id")

    Conexao.execute(SQL)
    Call Fecha_Tabelas

    Response.Redirect("pesquisa.asp")

    end select
    SQL = "SELECT * FROM tabela WHERE id = " & Request.QueryString("id")
    set rs = Server.CreateObject("ADODB.RecordSet")
    rs.Open SQL, conexao, 3

    var_id = rs("id")
    :
    var_aprova_jpg_nao = rs("aprova_jpg_nao")
    :

    rs.Close
    set rs = nothing
    Call Fecha_Tabelas
    'conexao.Close
    'set conexao = nothing
    %>

    <html>
    <head>
    <title>.: Altrerando Registro :.</title>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <link href="estilos.css" rel="stylesheet" type="text/css">

    Here is my doubt

    <input name="c_aprova_jpg_sim" type="checkbox" id="c_aprova_jpg_sim"
    value="<%If var_aprova_jpg_sim Then
    var_aprova_jpg_sim = 1
    Else
    var_aprova_jpg_sim = 0
    End If
    %>">


    ' resulta zero = 0

    </form>
    </body>
    </html>


    Thank you :)

    J.P. / Brasil
     
    ewb13, Apr 3, 2009 IP
  2. engager

    engager Peon

    Messages:
    28
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    try use true/false instead of 1/0 when assigning values to boolean field
     
    engager, Apr 7, 2009 IP
  3. emlak

    emlak Peon

    Messages:
    50
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    try converting values to cdbl or cstr
     
    emlak, Apr 8, 2009 IP