with checkboxes
and provide, as you surmised, a defualt value of 0.
Use IsDefined('FORM.checkbox_name') in the UPDATE to determine whether to
updaytre the field.
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 1:44 PM
To: CF-Talk
Subject: RE: inserting
I have a single file that's supposed to enter form data from several
pages into a database. It checks to see if a form exists and if it
does, then it enters it's value into the database.
The problem that I'm running into is that when checkboxes aren't
checked, they don't exist with
input type=hidden name=c1 value=0
input type=checkbox name=c1 value=a
input type=checkbox name=c1 value=b
-Original Message-
From: Daniel Kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 12:50 PM
To: CF-Talk
Subject: inserting checkboxes into a db
You will have to have some way of tracking within your form data whether
there was originally a checkbox in the page. One easy way to do this is to
simply add a hidden form field within that page.
So, I guess the hidden field has to have a value that indicates the page,
rather than just true and
input type=hidden name=c1 value=0
input type=checkbox name=c1 value=a
input type=checkbox name=c1 value=b
So the hidden sets the default value, right? Here's what I did.
on the page:
input type=hidden name=#checkbox_name# value=0
input name=#checkbox_name# #checked# type=checkbox
, a defualt value of 0.
Use IsDefined('FORM.checkbox_name') in the UPDATE to determine whether to
updaytre the field.
-Original Message-
From: daniel kessler [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 01, 2005 1:44 PM
To: CF-Talk
Subject: RE: inserting checkboxes into a db
input type=hidden
6 matches
Mail list logo
