um... ok. I intended to set the value of "D" on the form to the current value in the database. If the database is null, it will be unchecked, if the database is 1 it will be checked. I must be having a space cadet moment, but doesn't checking the box make the value "1"??
> -----Original Message----- > From: William M Conlon [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 11, 2007 01:21 > To: [email protected] > Subject: Re: Witango-Talk: Stumped > > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
