This is how our POS inhouse RAD tool works for the CRUD screens. I personally tend to stray away on forms built outside of it to some degree. The reason is sometimes we want default values on a create screen.
On 10/3/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > >>if it exists, then I know I am on an edit or view > page and to output the query, the other side would be to create a blank > query to leave the form blank, > > Actually, you don't have give you all this trouble. > In all my edit templates, I transmit the id of the record I want to work > on. > When adding a new record, the id will be 0 > But I still make the same query WHERE itemId = #id#. > If id = 0, CFQUERY returns an empty query, but all fields are defined > with empty values. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
