You've defined the checked value of "D" to be "NULL". when you check
it, you get NULL submitted
Bill
William M. Conlon, P.E., Ph.D.
To the Point
2330 Bryant Street
Palo Alto, CA 94301
vox: 650.327.2175 (direct)
fax: 650.329.8335
mobile: 650.906.9929
e-mail: mailto:[EMAIL PROTECTED]
web: http://www.tothept.com
On Apr 11, 2007, at 10:06 AM, Tom Ferguson wrote:
I've got a form that has a series of checkboxes. They are defined as
follows:
<INPUT NAME="D" TYPE=CHECKBOX VALUE="<@COLUMN 'BlastMailList.D'>"
<@IFEQUAL
<@COLUMN "BlastMailList.D" ENCODING=MULTILINE> "1">CHECKED</@IF>>D
If I check one of the checkboxes, it does not update the field in the
database. When I put it in debug mode, the args are there but the
newly
checked arg shows a null value.
However, if I uncheck one of the checked values, it works.
What am I missing here??
Here is the debug: A, B, and C have a value of 1 in the database. I
checked D, but it comes across as null.
[Application File] [50] START /intranet/editBlastList.taf
Tango_2000_Server
_function=update&BlastMailList_uid1=21&_UserReference=B188C6555103D10A
461CF0
DC A=1 B=1 C=1 D= [EMAIL PROTECTED] FirstName=Mike J=1
LastName=Beatty
Salutation= Total Length of Postargs: 83
[user$ Vars] [50] numAffected=1 variableTimeout=30
[If Action] [50] IfForm
[ElseIf Action] [50] ElseIfList
[ElseIf Action] [50] ElseIfDetail
[ElseIf Action] [50] ElseIfUpdate
[Update Action] [50] Update1
[Warning] [50] Missing argument: E
[Warning] [50] Missing argument: F
[Warning] [50] Missing argument: G
[Warning] [50] Missing argument: H
[Warning] [50] Missing argument: I
[Query] [50] UPDATE dbo.BlastMailList SET
FirstName=?,LastName=?,eMail=?,Salutation='',A='1',B='1',C='1',D=NULL,
E=NULL
,F=NULL,G=NULL,H=NULL,I=NULL,J='1' WHERE (ID=21)
[BoundVals] [50] [v1='Mike'; v2='Beatty'; v3='[EMAIL PROTECTED]']
[Results Action] [66] UpdateResponse
[Changed Vars] [66] user$numAffected=1
[Return Action] [66] Return
[user$ Vars] [66] numAffected=1 variableTimeout=30
______________________________________________________________________
__
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
