Hi Adam,
Adam Churvis wrote:
If you want to bypass DatabaseBlocks.cfc for add, edit, and delete forms,
just modify your action pages such that you keep the ValidateForm and
ValidateInput custom tag calls, but replace the InsertRecord, UpdateRecord,
or DeleteRecord custom tags and their associated child tags with the
invocation call to your stored procedure.
Regarding this approach, I assume the best way back to the list is just
using a cflocation call immediately following the invocation call, a la
<cfscript>
// Insert record if validation is passed
Application.Aircraft.InsertAircraft(Form.Aircraft, Form.Comments);
</cfscript>
<cflocation
url="#Application.urlRoot#/admin/aircraft/aircraftlist.cfm?refresh=1">
?
The generated SPs appear to be working good so far for single table
updates. Do you guys have plans to generate SPs for more complex
forms? If not, in the examples you are working on for the help file, it
would be useful to see examples of invoking SPs on add/edit forms that
have chooser controls on them. I have a couple forms with these and I
would be interested to see how you would handle this.
Jeff
