no, because you assign the value as the column, assign VALUE="1" and then when it is checked, it will be 1.

--

Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/

On Apr 11, 2007, at 11:13 AM, Tom Ferguson wrote:

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=B188C6555103D10 A
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

Reply via email to