I have a database with a Datasheet field. I want this field to read a variable, #File.ClientFile#. But I can't get it to work. Before or during a <CFUPDATE> how do I set the value of a field to a variable?
The cfupdate tag looks for the existence of form variables that have been submitted by a form. It will take all form variables avaialable and try to insert their values into the table specified into fields that match the form variables. If your form has variables that shouldn't go into the database, use the "formFields" attribute to specify which ones it should use. With CF 4.5, you can now set form fields to a value like this <cfset form.myFile = #File.ClientFile#> so you can modify form variables before a <cfupdate>.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.