I have tried to read from my checkbox using request.form, but I don't believe I have done it right. Also, do I need to set my checkbox value to false or 0 when updating SQL server?

'declare variable
dim nsfCheck

'Initialize variable
nsfCheck = False

'=======================
' nsfCheck Flag Function
'=======================
Function nsfCheckFlagChecked(nsfCheck)


If (nsfCheck = True) Then
nsfCheckFlagChecked = True
Else
nsfCheckFlagChecked = False
End If
End Function

If (nsfCheck = true) Then
If application("ODBC_Oracle") Then
strSQL = strSQL & "UPDATE BadCheckReconciliation (FirstNoticeDate, NSFcheckFlag), " & vbcrlf
strSQL = strSQL & " (SET BadCheckReconciliation_seq.nextval, SQLDate( FeeTransdt ),nsfCheck) " & vbcr
strSQL = strSQL & "UPDATE Journal ( BadCheckReconciliationIdnt) " & vbcrlf
strSQL = strSQL & " FROM BadCheckReconciliation" & vbcrlf
else 'SQL 7.0
strSQL = strSQL & "UPDATE BadCheckReconciliation BCR" & vbcrlf
strSQL = strSQL & "SET FirstNoticeDate = FeeTransdt,NSFcheckFlag = nsfCheck" & vbcrlf
strSQL = strSQL & "UPDATE Journal J" & vbcrlf
strSQL = strSQL & "SET J.BadCheckReconciliationIdnt = BCR.BadCheckReconciliationIdnt" & vbcrlf
StrSQL = strSQL & " FROM BadCheckReconciliation BCR" & vbcrlf

End If
End If

<INPUT TYPE=CHECKBOX NAME=nsfCheck VALUE=False><BR>

Ty

;;;but I don't believe I have done it right
tricky to tell without seeing your checkbox and the way you are looking at it. If you checkbox is called 'someName' then you look at the value by <%= request.form("someName") %> providing you have used method="post" inside your form tag otherwise use <%= request.querystring("someName") %>

;;;Also, do I need to set my checkbox value to false or 0 when updating SQL server?
if the field is required and its a true false field yes. I tend to make a true false field have a default value. EG I have a field called 'inactive' I make it true/false data type and set a default insert value of 0 (false) - this way you only need to address it if you are inactivting a record. IMO using default values is a very good practice

Wind is your friend
Matt

This is my checkbox:

dim nsfCheck
nsfCheck = "0"

<td><input type="checkbox" name="nsfCheck" value="0"></td>
Function nsfCheckFlagChecked(nsfCheckBox)

If (nsfCheck = True) Then
             nsfCheckFlagChecked = True
             Else
             nsfCheckFlagChecked = False
            End If
End Function




Ty

;;;I have tried to read from my checkbox using request.form, but I don't believe I have done it right.

You did not post the problematic code in relation to this question. Read from your checkbox on the page it posts to providing you are using method=post using:
<%= trim(request.form("nsfCheck")) %>

Whay are you comparing your checkbox to? You code says:
nsfCheck = "0"
then you ask a server side function:
If (nsfCheck = True) Then
You have set nsfCheck to a string value of "0" - this is not true or false, its a string containing 0.

I have no idea what you are trying to do with the checkbox however, If you want to compare someValue against someVariable, I would:
<input type="checkbox" name="nsfCheck" value="<% if somevariable = someValue then response.write "checked" end if %>">




Wind is your friend
Matt