Re: Quick Replace Question
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53878
interpreted = N
texte = you see... i just finished restructuring the database of a large web site and created a new front end for users. but the customer went into the old admin pages i created for them 6 months ago and started attempting to change things. (i'm still working on a version 2 of the admin pages) before i knew it they had duplicated records and deleted the SKUs of records that were in the database. so i actually had 11 records duplicated at least 3 times each. all of the duplications were the same, and all of them were without SKUs. after yelling at the customer for letting there new employee dick around i had to figure out how to save a single record from each set, but delete the rest. it would be easy if i could just turn the system off, download the database, make the edits by hand and then reupload. but i could not. thus my problem. thankfully the [replace&max=1] does work and i got the problem solved. and it actually did not matter how many parameters i used in the replace syntax either. interesting eh? stupid customers. matt Andrew Simpson wrote: >ah, okay. Just seems a weird thing to do then if you know how many results >are going to be replaced. Is there some performance advantage in telling it >to do only as many as you know there are? > > > > >*obviously* i would have more criteria. that was a simple example for demo >purposes only. >i just wanted to know if it would work before i tried it on a live customer >database of more than 10000 records. > >i remembered seeing it written somewhere that everything in a [search] would >work in a [replace] and [delete] also, but i just wanted to get someone else >to confirm it before putting my neck on the chopping block. > >thanks, >matt > > >------------------------------------------------------------- >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/ > > > ------------------------------------------------------------- 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:
you see... i just finished restructuring the database of a large web site and created a new front end for users. but the customer went into the old admin pages i created for them 6 months ago and started attempting to change things. (i'm still working on a version 2 of the admin pages) before i knew it they had duplicated records and deleted the SKUs of records that were in the database. so i actually had 11 records duplicated at least 3 times each. all of the duplications were the same, and all of them were without SKUs. after yelling at the customer for letting there new employee dick around i had to figure out how to save a single record from each set, but delete the rest. it would be easy if i could just turn the system off, download the database, make the edits by hand and then reupload. but i could not. thus my problem. thankfully the [replace&max=1] does work and i got the problem solved. and it actually did not matter how many parameters i used in the replace syntax either. interesting eh? stupid customers. matt Andrew Simpson wrote: >ah, okay. Just seems a weird thing to do then if you know how many results >are going to be replaced. Is there some performance advantage in telling it >to do only as many as you know there are? > > > > >*obviously* i would have more criteria. that was a simple example for demo >purposes only. >i just wanted to know if it would work before i tried it on a live customer >database of more than 10000 records. > >i remembered seeing it written somewhere that everything in a [search] would >work in a [replace] and [delete] also, but i just wanted to get someone else >to confirm it before putting my neck on the chopping block. > >thanks, >matt > > >------------------------------------------------------------- >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/ > > > ------------------------------------------------------------- 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/
Matthew A Perosi
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:
WebCat2b12 CGI Mac - [shownext] problem (1997)
Search design (1997)
Execute Applescript (1997)
japanese characters (1997)
mimeheaders to allow back button to work on a posted page? (2004)
Listserver problem (1997)
Quickie question on the email templates (1997)
is [math] busted somehow in 3.05b10? (1999)
[WebDNA] List Files question (2009)
[WebDNA] WebDNA Euro Hosting (2014)
Stupid question (2003)
mac hack (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Access Denied! But why? (1997)
Protecting Realms (1998)
list archives (2004)
[WebDNA] Instructions for install on CentOS 5.7? (2011)
[WriteFile] problems (1997)
WebCatalog 2.1b3 - Plugin or cgi ? (1997)
hidden (phantom) file downloads (2000)