well don't I feel stupid... Thanks!
> -----Original Message----- > From: Ted Wolfley [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 11, 2007 02:23 > To: [email protected] > Subject: RE: Witango-Talk: Stumped > > Hi, > > If D is null in the database, the value of the input box is > null. Set the value of the input box to what the value should > be if checked. > > Ted > > -----Original Message----- > From: Tom Ferguson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 11, 2007 2:13 PM > To: [email protected] > Subject: RE: Witango-Talk: Stumped > > 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 > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
