On your update template, use CFPARAM for any field that may in
some cases be missing... Or, on the original display page, you
could use hidden fields for the boxes you don't want to show...
Gene Kraybill
On 13 Jul 2001, at 8:43, Janine Jakim wrote:
> 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
