CFUPDATE to ignore fields

[jmcg]

IS there a way to have CFUPDATE ignore certain fields in the form.

I am using CFUPDATE as there are too many changeable form fields (of different types) to write the SQL manually, however want to ignore some fields that do not exist in the table.

Is this possible, and if so, how? Thanks

 

[cfSearching]

IIRC, there are two options:

- Use StructDelete to remove the extra fields from the FORM structure. If you still need some of the value, duplicate(..) the form structure first
- Use an explicit "formFields" list


----------------------------------

http://cfsearching.blogspot.com/

 

[jmcg]

thanks

will try the formfields to defined rather than exclude. Or better yet spend a few hours and sort it into a proper SQL as CFUPDATE is not very good.

Thanks for the tips anyway.

 

[cfSearching]

Yes, in the long run, regular sql is the better option.

----------------------------------

http://cfsearching.blogspot.com/