and to add to what Chad said: you can go further by interrigating the database schema to automatically tell you what the tables's datatypes, sizes and "nullability" are for data validation.
to be honest, tho, while this works for simple systems, as soon as you throw an "if" that depends on context, you're sunk. You end up writing all these conditional micro business rules that start turning the whole lot into a spaghetti nightmare. but yeah, people have been building forms directly off the db schema since ASP classic (ie: where I first saw it done) hope this helps barry.b > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Chad > Renando > Sent: Wednesday, 8 June 2005 2:19 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: Form Advise. > > > Yes I have. It depends on your level of abstraction. The more > automated you go, the more you need to build allowances for every type > of situation. Once you start down the path, be prepared for more work > than you anticipated. > > Simple in excution, complex in design. It's a balance where each side > is directly proportional to the other. > > Chad > who is simple in execution > > On 6/8/05, Jeremy <[EMAIL PROTECTED]> wrote: > > Hi guys and gals, > > > > I'm about to attempt building a dynamic form based from a > database. I want > > to make it as simple as possible for both user and my > brain. Has anyone > > done such a thing. My issue so far is being radio boxes and > check boxes. > > > > If anyone can point me in the right direction that would be > nice. Below is > > what I have so far. I also played around with Flash vs. XML v-cool. > > > > > > <cfform name="form" method="POST" format="FLASH" > height="400" width="400"> > > <cfformgroup type="accordion"> > > <cfformitem type="HTML">Please > enter your </cfformitem> > > <cfoutput > query="GetInfo"> > > > <cfif #FormRequired# IS 1> > > > <cfset RValue = "Yes"> > > <cfelse> > > > <cfset RValue = "No"> > > </cfif> > > > <cfif #formtype# IS 'CheckBox'> > > > <cfformitem type="HTML">#Question#</cfformitem></cfif> > > > <cfinput type="#formtype#" name="#formname#" > value="#formvalue#" label="#FormLabel#" required="#RValue#" > message="Please Check #FormLabel#"> > > </cfoutput> > > <cfinput > type="Submit" value="Submit" name="Submit"> > > </cfformgroup> > > </cfform> > > > > jeremy > > > > --- > > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
