updating database only when a check box is displayed

[jim_jim]

I have a classic asp code page where i hide and show a check box based on a database feild value.It is working fine when the checkbox is displayed and the page is submitted.but when the check box is not displayed because it did not meet a requirement and when i submit the page it is inserting null into the database for a feild.

how do i change the program such that it updates the database only when the control is displayed and it should not update anything when the control is not being displayed


i have a separate database page on which i get the checkbox control using

vTagCustomer = Request.Form("tagcustomer")

Below is the code i have been using to update the database when the check box is checked or not

if not isnull(vTagCustomer) and not vTagCustomer= "" then
SQLStmt = "exec dbo.CUSTOMERTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU4 = Connection.Execute(SQLStmt)
Set RRU4 = NOTHING
else
SQLStmt = "exec dbo.CUSTOMERUNTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU5 = Connection.Execute(SQLStmt)
Set RRU5 = NOTHING

end if

I need the above code to work only if the control tagcustomer is displayed on the code page?

Thanks

[gk53]

I believe it will be much easy to add hidden field on your page and just check value for decision about update data or not....
<input type = "hidden" name="uneatable" value="N" />

<%
if request("uneatable")="Y" then
' your update code
end if
%>
you set original value in asp code and / or change value inside that field with javasript

[jim_jim]

Can you please eloborate on your help

how and why will a hidden feild help in my scenario

the below is the code that i am using to hide and unhide a table column

<%if (vrptdesc6="Y") then %>
      <td colspan="2"> Tag Customer for no reporting &nbsp; &nbsp;
        <input type="checkbox" name="tagcustomer" id= "tagcustomer"  <%if vCustFlag = "Y" then %>checked <%end if%>    value = "Y"  /> </td>
         <% End If %>

will i be able to use the vrptdesc6 value to enable and disable database code.Iam new to coding world

the database code is not in the same page as the asp code.It is in a separate file

I believe it will be much easy to add hidden field on your page and just check value for decision about update data or not....
<input type = "hidden" name="uneatable" value="N" />

<%
if request("uneatable")="Y" then
' your update code
end if
%>
you set original value in asp code and / or change value inside that field with javasript

[sqlconfused]

<%if (vrptdesc6="Y") then %>
      <td colspan="2"> Tag Customer for no reporting * *
        <input type="checkbox" name="tagcustomer" id= "tagcustomer"  <%if vCustFlag = "Y" then %>checked <%end if%>    value = "Y"  /> </td>
<% else %>
 <input type="hidden" name="tagcustomer" id= "tagcustomer"  value = "bypass">
         <% End If %>

if vTagCustomer&"" <> "" and vTagCustomer <> "bypass" then
SQLStmt = "exec dbo.CUSTOMERTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU4 = Connection.Execute(SQLStmt)
Set RRU4 = NOTHING
else
SQLStmt = "exec dbo.CUSTOMERUNTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU5 = Connection.Execute(SQLStmt)
Set RRU5 = NOTHING

end if

The &"" takes care of null or empty strings in one shot.

[sqlconfused]

Be nice if this crappy editor had an edit option. This might be better:

<%if (vrptdesc6="Y") then %>
      <td colspan="2"> Tag Customer for no reporting * *
        <input type="checkbox" name="tagcustomer" id= "tagcustomer"  <%if vCustFlag = "Y" then %>checked <%end if%>    value = "Y"  /> </td>
<% else %>
 <input type="hidden" name="tagcustomer" id= "tagcustomer"  value = "bypass">
         <% End If %>

if vTagCustomer <> "bypass" then
if not isnull(vTagCustomer) and not vTagCustomer= "" then
SQLStmt = "exec dbo.CUSTOMERTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU4 = Connection.Execute(SQLStmt)
Set RRU4 = NOTHING
else
SQLStmt = "exec dbo.CUSTOMERUNTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU5 = Connection.Execute(SQLStmt)
Set RRU5 = NOTHING

end if
end if

[sqlconfused]

Argh! Three times to get it right. The above won't work because even upon deselecting the box the untag won't get processed.


<%if (vrptdesc6="Y") then %>
<td colspan="2"> Tag Customer for no reporting * *
<input type="checkbox" name="tagcustomer" id= "tagcustomer" <%if vCustFlag = "Y" then %>checked <%end if%> value = "Y" /> </td>
<% else %>
<input type="hidden" name="bypass" value = "yes">
<% End If %>[/CODE]

if request.form("bypass") <> "yes" then
if not isnull(vTagCustomer) and not vTagCustomer= "" then
SQLStmt = "exec dbo.CUSTOMERTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU4 = Connection.Execute(SQLStmt)
Set RRU4 = NOTHING
else
SQLStmt = "exec dbo.CUSTOMERUNTAGGING "
SQLStmt = SQLStmt & vReqNum & "; "
Set RRU5 = Connection.Execute(SQLStmt)
Set RRU5 = NOTHING

end if
end if

[jim_jim]

Thanks.It worked