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:

shipcost (1997) Some Questions (1997) Time for a hard questions. (1997) Norton Internet Security filtering out WebDNA processsed (2004) Bulletin Board (1998) PhotoMill -> PhotoMaster (1997) [WebDNA] Webdna pre-parse script & AJAX response (2010) WebMerchant when CC network is down (1998) Bad Cookie / Internet Option / Internet Explorer (2004) re:check boxes (1997) Fields font size (2003) Email Attachments (1998) Credit Card Gateways (2005) Locking up with WebCatalog... (1997) Banners and sort of random display (1997) Problem with updating 2.1b7 -> 2.1.1 (1998) Regular expression to match email address (2003) Moment of Thanks (1997) For those of you not on the WebCatalog Beta... (1997) problem 'building' field names (2000)