What about this [delete] situation?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17002
interpreted = N
texte = Will the following delete context delete *exactly* the same record as the one retrieved by the search context below?All the parameters are exactly the same in both contexts.You see, in an effort to make sure that it will be *impossible* for the delete context to delete any OTHER record than the one retrieved by the search, I have turned ranking off so the items will be retrieved in exactly the database order -- and I have set the maximum number of records to 1 so there's no chance of more than one record being retrieved.I know for a fact that this technique works properly in the search context, so my question has to do with the delete context. All I need to know is whether or not the delete context behaves exactly the same as the search context when using parameters like rank=off and max=1?Or will the delete context ignore either the rank=off parameter OR the max=1 parameter ... and therefore end up deleting some record or records *other than* the first matching record in the db? [search db=calendar.db&bwcalendarDatedatarq=02/29/&eqartistIDdatarq=[artistID]&rank=off&max=1][delete db=calendar.db&bwcalendarDatedatarq=02/29/&eqartistIDdatarq=[artistID]&rank=off&max=1]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: What about this [delete] situation? (PCS Technical Support 1998)
  2. What about this [delete] situation? (Kenneth Grome 1998)
Will the following delete context delete *exactly* the same record as the one retrieved by the search context below?All the parameters are exactly the same in both contexts.You see, in an effort to make sure that it will be *impossible* for the delete context to delete any OTHER record than the one retrieved by the search, I have turned ranking off so the items will be retrieved in exactly the database order -- and I have set the maximum number of records to 1 so there's no chance of more than one record being retrieved.I know for a fact that this technique works properly in the search context, so my question has to do with the delete context. All I need to know is whether or not the delete context behaves exactly the same as the search context when using parameters like rank=off and max=1?Or will the delete context ignore either the rank=off parameter OR the max=1 parameter ... and therefore end up deleting some record or records *other than* the first matching record in the db? [search db=calendar.db&bwcalendarDatedatarq=02/29/&eqartistIDdatarq=[artistID]&rank=off&max=1][delete db=calendar.db&bwcalendarDatedatarq=02/29/&eqartistIDdatarq=[artistID]&rank=off&max=1]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

WebCatalog stalls (1998) WebDNA 6.0 backwards compatible? (2004) Problems with command=replace in realm (2000) Newbie search question (between two dates) (2001) Site Search Concepts (2003) Shell context. (2002) [WebDNA] Integration with QuickBooks (2011) Webmerchant confirmation hooks? (1997) read and write you own cookies with webcat (1997) Review comparison by PC Magazine: Open for On-line Business (1997) practicing safe queries.. (2000) Backwards list behavior ... (1997) TIP of the DAY - to work or not work (2004) Big Databases (1997) Checkboxes (1998) Exclamation point (1997) problem: mail changed (1997) RE: Signal Raised (1997) CommitDatabase vs. CloseDatabase (2001) Price + Texte (1999)