Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-12 Thread S . Isaac Dealey
> Thank you so much. > I got it working. > Daniel You're very welcome, congratulations. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://www.sys-c

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-12 Thread Daniel Kang
Thank you so much. I got it working. Daniel On 4/12/05, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > Oops! Sorry -- typo... that should be value="..." instead of > name="..." > > > > > > > > > > >insert into tFormCategory > > (formid,categoryid,altcategoryname) > >values ('#se

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread S . Isaac Dealey
Oops! Sorry -- typo... that should be value="..." instead of name="..." > > > > >insert into tFormCategory > (formid,categoryid,altcategoryname) >values ('#session.formid#','#x#', name="#altcatname#" > null="#yesnoformat(not altcatmodified)#">) > > > This reurns errors

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread Daniel Kang
insert into tFormCategory (formid,categoryid,altcategoryname) values ('#session.formid#','#x#', ) This reurns errors below: Attribute validation error for tag CFQUERYPARAM. The tag does not allow the attribute(s) NAME. The valid attribute(s) are CFSQLTYPE,LIST,MAXLENGTH,NUL

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread S . Isaac Dealey
> I see your point! I will try that as you suggest. Good luck! :) Hope my examples were helpful. :) s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://macromedia.breezecentral.com/p49777853/ http://

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread Daniel Kang
I see your point! I will try that as you suggest. On Apr 11, 2005 1:18 PM, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > These are predefined departments arent they? > > Even if they aren't, why would you subject yourself to the horror of > adding a database column each time a user adds a catego

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread S . Isaac Dealey
These are predefined departments arent they? Even if they aren't, why would you subject yourself to the horror of adding a database column each time a user adds a category? That exactly the sort of problem relational databases were designed to solve -- so you wouldn't need to add columns. (That's

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-11 Thread Daniel Kang
The challenge here is that the number of checkboxes are not defined, meaning the user (to make it simple, let us say a user) can add any number of checkboxes (20, 40, 50, etc). This also makes very hard (=whenever the user wants to add one checkbox, I have to add the checkbox on the CF page and h

Re: Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-10 Thread S . Isaac Dealey
Typically you would have a separate form page where administrative users can manage the list of categories available on a given form... In your database you would have a table containing a list of forms and a table containing a list of categories and a cross-reference table to show whish categories

Adding/removing/modifying checkboxes/dropdown boxes dynamically in CF??

2005-04-10 Thread Daniel Kang
I am looking for a CF functionality, tag, or way that can allow users add/remove/modify checkboxes/dropdown boxes dynamically. Checkboxes are preferable if possible than dropdown boxes. 1) Adding checkboxes/ dropdown boxes In "Category" section, there are categories like "1 North, 2 North, 2 Sou