Re: Quick Replace Question

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53873
interpreted = N
texte = *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

Andrew Simpson wrote:
you should really have more criteria in your search context so that you knowwhich ONE is going to be replaced.otherwise you're just letting the natural order of the database decide.remember - There can be only one...hehe. always wanted to say that.----- Original Message ----- From: "Stuart Tremain" <development@idfk.com.au>To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Sent: Friday, November 07, 2003 11:06 AMSubject: Re: Quick Replace Question  
I seem to remember the docs saying that you can use anything in REPLACEthat you use in SEARCH.On Friday, November 7, 2003, at 08:51 AM, Matthew A Perosi wrote:    
I can't find it in the docs.Can I use max=1 in a [replace] syntax in Version 4.5?i.e.[replace db=hotel.db&eqROOMdatarq=1&max=1]GUEST=John[/replace]                                  ^^^^^^Thanks,Matt Perosiijo.comnj-singles.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to<WebDNA-Talk-digest@talk.smithmicro.com>Web Archive of this list is at: http://webdna.smithmicro.com/      
RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to    
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>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:

    
  1. Re: Quick Replace Question ( Matthew A Perosi 2003)
  2. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  3. Re: Quick Replace Question ( Tim Robinson 2003)
  4. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  5. Re: Quick Replace Question ( Matthew A Perosi 2003)
  6. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  7. Re: Quick Replace Question ( Stuart Tremain 2003)
  8. Quick Replace Question ( Matthew A Perosi 2003)
*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

Andrew Simpson wrote:
you should really have more criteria in your search context so that you knowwhich ONE is going to be replaced.otherwise you're just letting the natural order of the database decide.remember - There can be only one...hehe. always wanted to say that.----- Original Message ----- From: "Stuart Tremain" <development@idfk.com.au>To: "WebDNA Talk" <WebDNA-Talk@talk.smithmicro.com>Sent: Friday, November 07, 2003 11:06 AMSubject: Re: Quick Replace Question  
I seem to remember the docs saying that you can use anything in REPLACEthat you use in SEARCH.On Friday, November 7, 2003, at 08:51 AM, Matthew A Perosi wrote:    
I can't find it in the docs.Can I use max=1 in a [replace] syntax in Version 4.5?i.e.[replace db=hotel.db&eqROOMdatarq=1&max=1]GUEST=John[/replace]                                  ^^^^^^Thanks,Matt Perosiijo.comnj-singles.com-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to<WebDNA-Talk-digest@talk.smithmicro.com>Web Archive of this list is at: http://webdna.smithmicro.com/      
RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +612 9908 4837-------------------------------------------------------------This message is sent to you because you are subscribed to  the mailing list <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to    
<WebDNA-Talk-digest@talk.smithmicro.com>  
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 <WebDNA-Talk@talk.smithmicro.com>.To unsubscribe, E-mail to: <WebDNA-Talk-off@talk.smithmicro.com>To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.smithmicro.com>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:

Emailing html (1998) Searching a database... (2003) using showpage and showcart commands (1996) Avoiding duplicate db entries (2002) default error on NT? (1997) Problem with CC problem ? (1997) More news on 5.0 (2003) Almost a there but..bye bye NetCloak (1997) Custom WebCat Prefs ... (1997) [WebDNA] WebDNA restart script (2015) Emailer (1997) Verifying both name and password (was: THANKS) (1997) 5.0 Pricing (2003) Wireless WebDNA available today! (2000) Running WebCat from a CD-ROM (1997) Date search - yes or no (1997) Re:listfiles-looking for slick solution (1997) Location of Webcat site in folder hierarchy (1997) [isfile] ? (1997) MacAuthorize order data fields WAS:How To question... (1997)