I have a display page that shows select boxes/input boxes. Depending on the
subject will depend on if they should fill the box. I have set it so they
don't see a box if the field should not be filled in.
Problem: On submit an update query is run. My query doesn't like blanks
(loop list update query) and fills in the blanks with the field value of the
next field.
So this: A ___ Becomes: A 12
B 12 B 19
C 19 C 3
D 3 D
I fixed the problem by adding a select box with no options and puts a . in
the database as a placeholder. But that is ugly and the user must tab
to/from the field even if the field is useless to them. Any suggestions. I
think the answer is easy, but it's one of those days that I left my brain at
home with my gourmet coffee....
Thanks for all/any help
j
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
