Very nice. I like that a lot and will be stealing it in the future :)
> -----Original Message----- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 03, 2006 4:15 PM > To: CF-Talk > Subject: Re: CFIF Statement > > >>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. > > -- > _______________________________________ > REUSE CODE! Use custom tags; > See http://www.contentbox.com/claude/customtags/tagstore.cfm > (Please send any spam to this address: [EMAIL PROTECTED]) > Thanks. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:255262 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
