Yes, I agree. I only used this as an example since he said he already had his query info for one record. At least that was my understanding of his dilemma.
The main point, Pete, that Ray & I are both trying to make is that your CFINDEX can be exactly the same whether your query has returned 1 record or 1,000. You don't need to add all the pound signs, etc., just simply identify the proper fields in the right places and that's it. The number of records returned in the query is irrelevant. If we haven't answered your question, please let us know! Dave -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED] Sent: Friday, August 19, 2005 3:58 PM To: CF-Talk Subject: Re: CFINDEX - how to add/update a single record in an existing collection? Dave, I'm pretty sure, in MX7 at least, you don't need to make a one record query. You can just pass the values. Of course, if you already have the one record query, that would work. ****************************************************************************************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:215887 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
