There are many ways to skin this cat, but it all depends on your checkboxes
and what your trying to accomplish. If you could provide more details, I am
sure you will get some good help!
Paul Giesenhagen
QuillDesign
http://www.quilldesign.com
SiteDirector v2.0 - Commerce Builder
> Does anyone
lto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:29 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?
There are many ways to skin this cat, but it all depends on your
checkboxes and what your trying to accomplish. If you could provide
more details, I am sure you will get some good h
ssage-
From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:48 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?
If you have lets say 10 different checkboxes and each of those
checkboxes relate to a "column" in your database, and if it is checked,
you want
(That's my
disclaimer) In any event, enjoy the day!
~Val
- Original Message -
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 9:32 AM
Subject: RE: Multiple Checkbox update?
> All I need to do is have
thers and probably
better,
J
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 2:33 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
All I need to do is have the action page either enter a 1 into a field
in my DB if the checkbox is defined
On another note, is it possible to incorporatre a checkbox into CFGRID>?
If so, this will work for me?
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:53 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
Then when y
Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 9:52 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
I guess my problem is that I have all of these checkboxes and I need to
update the field associated with it in my databse but they all have the
same name. So, I figured I wo
John
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:14 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
On another note, is it possible to incorporatre a checkbox into CFGRID>?
If so, this will work for me?
-Original Message-
Fr
But it wouldn't display as a checkbox is what your saying?
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:24 AM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
Yep this would be another way of presenting the data,
handy for p
As far as I'm aware,
No!!
Check your documentation,
type in studio click in it and press F1,
J
-Original Message-
From: Kris Pilles [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:29 PM
To: CF-Talk
Subject: RE: Multiple Checkbox update?
But it wouldn't di
MAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, April 09, 2002 10:32 AM
Subject: RE: Multiple Checkbox update?
> As far as I'm aware,
> No!!
>
> Check your documentation,
> type in studio click in it and press F1,
>
> J
>
> -Origi
I agree, this is a internal...not much else our programmer can build
today application...
-Original Message-
From: Valerie L. Criswell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 10:45 AM
To: CF-Talk
Subject: Re: Multiple Checkbox update?
If I remember correctly, Booleans
ailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 09, 2002 3:45 PM
To: CF-Talk
Subject: Re: Multiple Checkbox update?
If I remember correctly, Booleans in cfgrid display a 1 or 0 and require the
user to input 1 or 0 as well (not too user-friendly).
My experience with cfgrid isn't the greatest.
Assuming its for a single record. Something like this should do it.
update atable
'exclude any you don't want' like the submit button
set ,
#PreserveSingleQuotes(afield)#=#PreserveSingleQuotes(fv
Give all the checkboxes the same name (but different values). The values
will be passed in FORM.myCheckboxName as a list. Loop through the list using
CFLOOP and do whatever updates you want.
Or if it suits your purpose, make use of the IN syntax in SQL, as in
UPDATE thisTable
SET y='mynewValue'
Give them all the same name but assign each a different value. Then on the
processing page loop through the list and insert/update accordingly. The
form should submit a single variable with a comma separated list of the
values selected. I typically store all the values in a single DB column and
16 matches
Mail list logo
