Well I don't want this to sound like an ad so I'll simply say that if you
have been considering trying it, I would definitely recommend doing so
before you write this dynamic-form-from-database code as it could really
help with that.
_____
From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 28 July 2004 3:43 p.m.
To: CF-Talk
Subject: Re: Help! - Dynamically Generate Forms from SQL DB - Bad Idea?
Mat -
Thanks for the reply.
1st - Regarding my code below - I was considering passing the FormType
(radio, text, textarea) variable througha if / case or tag that appropriate
spits out the same code.
Your right -they all essentially do the same thing.
As for terra forms - I have watched that product page and watched the
samples grow and grow. I have considered many times - but all too frequently
by these code pieces or tags and find they are not easy to use, limited etc.
I do however plan on downloading terraform and giving it a try.
Personally since I purchased your tag sortable about a month ago- and was
pretty happy with the code I will give terra forms.
I had seen that demo on the dynamic form generated -but not sure how that
all works into your tag so am curious. It seems as if you have already done
what I am looking to do here.
And I liked terra forms file upload enhancement. ( I am faced with quite an
elaborate file upload / tag / note it type solution )
Anyhow - The basis for all this was that I am tossed between html forms and
flash forms and then thought - hey - if I store the information about the
forms in a database - can I use it not only for html forms, but to create an
XML document to help develop flash forms - then further more - PDF forms
etc....
Thanks for the reply!
Jason
P.S. - I added a few lines of code to your sortable to support images -
makes it even more fun to use!
>It's certainly possible, and I've seen it done a few times and done it
>myself many times. The biggest problem is that HTML form fields have such
an
>inconsistent interface. For example, compare the HTML markup for a set of
>radio buttons with a select box: very different, yet the two widgets
>effectively do the same thing. I use a product called TerraForm
[disclosure:
>I sell it] to build forms which acts as an intermediary between the
>developer and the HTML, providing a consistent markup. This makes doing
what
>you want to do much easier as the appearance of the field is simply
>controlled by one database field. Example here:
>http://www.eswsoftware.com/products/terraform/gallery/dynamic.cfm . Also,
>check out this product by Bill Kaigler:
>http://www.cfcodewriter.com/content.cfm?contentnbr=41
>
>
>
>With the code you have written below, would you have one record for each
>radio button? How about one record for all the radio buttons, then another
>field containing a list of allowed values. You could use the same syntax
for
>checkboxes or select boxes. I'd also recommend a field for a human-friendly
>field name, and a field tracking whether the field is required or not.
>
>
>
>
>
> _____
>
>From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Wednesday, 28 July 2004 1:24 p.m.
>To: CF-Talk
>Subject: Help! - Dynamically Generate Forms from SQL DB - Bad Idea?
>
>
>
>Hello List -
>
>I am looking to store information about variables nad form fields in a db
to
>conditionally build html forms -
>
>
>Has anyone stored the variable name, and the form type in a database - and
>built the form dynamically on the fly?
>
>I can't seem to find any references to it and am thinking because it must
be
>a bad idea.
>
>Basically - store
>name | type | state
>LastName text
>LastName text
>HowToContact radio checked
>
>Then build components that write the html form- ie - if it's a radio
button
>-
><cfoutput><input type="#type#" name="#VarName#" #state#></cfoutput>
>
>Another purpose is - if I decide to do forms in Flash - perhaps I can have
>the database spit out an XML document to use to build the flash interface.
>
>Perhaps have the DB spit out XML/ or another format to build PDF forms
>etc....
>
>Too complex? Bad Idea - Any products already allowing this (NOT Hosted
>servies)
>
>Thanks!
>Jason
>
> _____
_____
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Adam Haskell
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Aaron DC
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Claude Schneegans
- Re: Help! - Dynamically Generate Forms from SQL DB ... Claude Schneegans
- Re: Help! - Dynamically Generate Forms from SQL DB - Bad... Matt Robertson
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Matthew Walker
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Matthew Walker
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Micha Schopman
- RE: Help! - Dynamically Generate Forms from SQL DB - Bad... Micha Schopman
- Small query question.. techmike
- Re: Small query question.. Jason Lemahieu
- Re: Small query question.. (Updated, SQL Sy... techmike
- Re: Small query question.. (Updated, SQ... techmike
- Re: Small query question.. (Updated, SQ... Jochem van Dieten
- Re: Help! - Dynamically Generate Forms from SQL DB ... millerj
- Re: Help! - Dynamically Generate Forms from SQL DB ... Dan O'Keefe