My multiple selects are generated from the third table (lists of label values)
Here's the concept of my list table (without the bells and whistles) List Table Columns UUID [varchar(35)] (NewID SQL UUID with hyphens removed id eg: 3284902783490278907238904)) DisplayOrder [int] = order of display in list GroupName [varchar(50)] = group so you can drop the group out easily in a query (eg: Product Type/Country) Label [varchar(100)] = checkbox label, select display label (eg: Compact Disc Split Track/Australia) Value_ID = an unique integer within the group (eg: 3444/23) Value_Text = a text representation of the label (eg: cdst/aud) Permissions = used if the field is sensitive, display for admin, but not for site user. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Sent: Wednesday, 8 June 2005 3:43 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Form Advise. Thanks Ricardo, I was onto something like that as I got your message. Still having issues trying to get my head round multiple select boxes etc etc. But I'll work it out. Chad...dood you worry me. J. > It isn't that bad. but it depends on how much flexibility you want > your forms to have. > > I can't give you our custom tag. but it goes a little something like : > > <cfcase value=3D"checkbox"> > <cfloop list=3D"#attributes.defaultvalue#" index=3D"i"> > <input name=3D"#attributes.name#" id=3D"#i#" > value=3D"#i#"><label>#i#</= > label> > </cfloop> > </cfcase> > > watch your id's. you may want to have a counter in there and > manipulate the data or something. or you could end up with a invalid > value. > > but you can put other attributes in there as well. Jon added #jscode# > to it aswell so it can save custom javascript eg: "onBlur=3D'doThis(); > onFocus=3D'doThat();'" > > HTH > > Ricardo > > > > On 6/8/05, Jeremy <[EMAIL PROTECTED]> wrote: > > Hi Ricardo, > >=20 > > Yeah thats what I'm upto at the moment or at least my thoughts are > >up to that level. I have just been playing around with arrays and > >putting all the data into that but i reckon its going to be a pain in the ass. > >=20 > > Interesting on the Checkboxes, and radio stuff. Do you have an > >example of this you could show me or is is IP encrypted...hehe. > >=20 > > Its funny, everyone who responded off list and on list...are > >saying...whoooa...yucky pucky jeremy.... > >=20 > > thanks for your help!! > >=20 > > Jeremy > >=20 > > > jeremy, > > > > > > most of our application is based on forms that are generated from > > > a dat= > abas=3D > > > e. > > > all of the fields are able to have a default value. > > > > > > For check boxes, radio groups and selects i pass a list as the > > > default value, loop over it to get the options. > > > > > > Ricardo. > > > > > > > > > > > > On 6/8/05, Jeremy <[EMAIL PROTECTED]> wrote: > > > > Hi guys and gals, > > > >=3D20 > > > > I'm about to attempt building a dynamic form based from a > > > >database. I= > wan=3D > > > t > > > > to make it as simple as possible for both user and my brain. Has > > > > anyo= > ne > > > > done such a thing. My issue so far is being radio boxes and > > > > check box= > es. > > > >=3D20 > > > > If anyone can point me in the right direction that would be > > > >nice. Bel= > ow i=3D > > > s > > > > what I have so far. I also played around with Flash vs. XML v-cool. > > > >=3D20 > > > >=3D20 > > > > <cfform name=3D3D"form" method=3D3D"POST" format=3D3D"FLASH" > > > >height= > =3D3D"400" wi=3D > > > dth=3D3D"400"> > > > > <cfformgroup type=3D3D"accordion"> > > > > <cfformitem type=3D3D"HTML">Please enter > > > > your= > </cff=3D > > > ormitem> > > > > <cfoutput > > > > query=3D3D"= > GetInf=3D > > > o"> > > > > <cfif > > > > #FormRe= > quir=3D > > > ed# IS 1> > > > > > > > > <cfse= > t RV=3D > > > alue =3D3D "Yes"> > > > > <cfelse> > > > > > > > > <cfse= > t RV=3D > > > alue =3D3D "No"> > > > > </cfif> > > > > <cfif > > > > #formty= > pe# =3D > > > IS 'CheckBox'> > > > > > > > > <cffo= > rmit=3D > > > em type=3D3D"HTML">#Question#</cfformitem></cfif> > > > > <cfinput > > > > type= > =3D3D"=3D > > > #formtype#" name=3D3D"#formname#" value=3D3D"#formvalue#" > > > label=3D3D"#F= > ormLabel#"=3D > > > required=3D3D"#RValue#" message=3D3D"Please Check #FormLabel#"> > > > > </cfoutput> > > > > <cfinput > > > > type=3D3D"Su= > bmit" =3D > > > value=3D3D"Submit" name=3D3D"Submit"> > > > > </cfformgroup> > > > > </cfform> > > > >=3D20 > > > > jeremy > > > >=3D20 > > > > --- > > > > You are currently subscribed to cfaussie as: > > > >[EMAIL PROTECTED] To unsubscribe send a blank email to > > > >[EMAIL PROTECTED] > n.co=3D > > > m.au > > > > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > > > > >=20 > > --- > > You are currently subscribed to cfaussie as: > >[EMAIL PROTECTED] To unsubscribe send a blank email to > >[EMAIL PROTECTED] > m.au > > 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/ ---------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. ---------------------------------------------------- --- 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/
