Re: how do I delete 1 of 2 identical records?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 55107
interpreted = N
texte = Hi Dale,I had this happen once on a more widespread scale. Wasn't pretty. I asked the same question and was provided with some sample code. This was some time ago, so sorry that I can't credit the author, but it went something like this:[search and find all records...][text]prevrecord=nadamatch[/text][founditems][showif [url][sku][/url]=[prevrecord]]
A duplicate was detected for the SKU: [sku] [!]--delete or do you what you need to here --[/!][/showif][text]prevrecord=[url][sku][/url][/text][/founditems][/search]GKAt 06:33 PM 12/26/2003, you wrote:>Hi,>>I have a database that at one point had some poor add record code. As a >result, one record has been duplicated exactly. Any time this record is >updated both records are updated. I need to delete 1 of these records, but >so far my test attempts have resulted in deleting both (using a test >database of course).>>Does anyone have an idea what to do to delete only 1 of 2 identical >records? I tried using &max=1 in replace, but that doesn't seem to have an >effect.>>WebCat 4.5.1 on Linux>>Thanks>>Dale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi Dale,I had this happen once on a more widespread scale. Wasn't pretty. I asked the same question and was provided with some sample code. This was some time ago, so sorry that I can't credit the author, but it went something like this:[search and find all records...][text]prevrecord=nadamatch[/text][founditems][showif [url][sku][/url]=[prevrecord]]A duplicate was detected for the SKU: [sku]
[!]--delete or do you what you need to here --[/!][/showif][text]prevrecord=[url][sku][/url][/text][/founditems][/search]GKAt 06:33 PM 12/26/2003, you wrote:>Hi,>>I have a database that at one point had some poor add record code. As a >result, one record has been duplicated exactly. Any time this record is >updated both records are updated. I need to delete 1 of these records, but >so far my test attempts have resulted in deleting both (using a test >database of course).>>Does anyone have an idea what to do to delete only 1 of 2 identical >records? I tried using &max=1 in replace, but that doesn't seem to have an >effect.>>WebCat 4.5.1 on Linux>>Thanks>>Dale-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Gary Krockover
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
denied access (1997)
Interactive Docs (2007)
Sort Order on a page search (1997)
permission deny help please (2004)
[BULK] [WebDNA] Multiple e-mail sending (2011)
Search in 2 or more catalogs (1997)
PCS Frames (1997)
[WebDNA] File Include HTM (2008)
[random] only for 1-100??? (1997)
[sendmail] questions... (1997)
Cookie still not working (1999)
transferring password & username (2000)
Size limit for tmpl editor ? (1997)
WebDNA to IM connectivity? (2006)
[Webcat 2]Next (1997)
[WebDNA] [OT] ImageMagick or similar (2015)
catagories (1997)
Close-to Comparison Code (1998)
tcpconnect (1999)
HELP WITH DATES (1997)