You can delete items according to the key value, this value can be got from custom query, I guess you could further refine the query example below to give a psecific record
<!---say after an edit/update, works quicker than repopulating collection---> <!---get data back---> <CFQUERY NAME="GetBook" DATASOURCE="A2Z"> SELECT BookID, Title, Description FROM Inventory WHERE BookID=#Form.BookID# <CFQUERY> <!---delete old record from the verity collection---> <CFINDEX ACTION="DELETE" COLLECTION="BOOKS" KEY="#Form.BookID#"> <!---nb get updated collection ver back into the collection---> <CFINDEX ACTION="UPDATE" COLLECTION="Books" TYPE="Custom" QUERY="GetBook" Key="BookID" TITLE="Title" Body="Description"> Above from my old Forta Web App Construction Kit, verity section Colm Colm Brazel MA CB Publications www.cbweb.net <http://www.cbweb.net> Macromedia-Dublin UserGroup Manager http://www.mmug-dublin.com [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> Web Site Design & Development, Cold Fusion, general publishing including E-Books. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication,or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify CB Publications by telephone at 353-1-4941625 or e-mail [EMAIL PROTECTED] and delete the e-mail from your system. -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 16 September 2003 16:51 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] verity won't delete records huh? the only way I can delete a specific record is to do the following: <cfset qryDeleteRecords = querynew("key")> <cfset queryaddrow(qryDeleteRecords)> <cfset querysetcell(qryDeleteRecords, "key", "c" & url.course)> <CFINDEX QUERY="qryDeleteRecords" ACTION="DELETE" COLLECTION="#collection#" KEY="key"> W.T.F. ??? > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 16 September 2003 16:33 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] verity won't delete records > > > hmm, odd one this. > > I have a collection that has records in it. When I try to > delete records > from the collection, it doesn't delete them. The key is > correct, as is the > collection. > > Here's my simple code: > > <cfindex action="DELETE" collection="#collection#" > key="c#url.course#"> > > CFMX6.1 win2000 > > The problem is occuring on all verity collections on the server. > > I've tried deleteing and recreating the verity collections, but to no > effect. > > No error is thrown, verity just ignores the delete request. A > refresh of the > collection populates it correctly. > > Has anyone got an idea what the problem might be? > > (moving to K2server not an option in this instance) > > ------------------------------------------------------- > Rich Wild > Senior Web Developer > > ------------------------------------------------------- > e-mango Tel: 01202 755 300 > Gild House Fax: 01202 755 301 > 74 Norwich Avenue West > Bournemouth Mailto:[EMAIL PROTECTED] > BH2 6AW, UK http://www.e-mango.com > ------------------------------------------------------- > This message may contain information which is legally > privileged and/or confidential. If you are not the > intended recipient, you are hereby notified that any > unauthorised disclosure, copying, distribution or use > of this information is strictly prohibited. Such > notification notwithstanding, any comments, opinions, > information or conclusions expressed in this message > are those of the originator, not of e-mango.com ltd, > unless otherwise explicitly and independently indicated > by an authorised representative of e-mango.com ltd. > ------------------------------------------------------- > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
