Re: Delete problem

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62845
interpreted = N
texte = I think it is working, but not the way you expect. When you do a search, the max parameter only limits the founditems context and not the numfound tag. What you are doing works in an arbitrary way if there are more than one match and I'mnot sure why you'd want Webcatalog deleting one record over the other. Bill -----Original Message----- From: Stuart Tremain Sent: Thu, 25 Aug 2005 16:54:48 +1000 To: "WebDNA Talk" Subject: Re: Delete problem Well I understand why [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq= [JobNum]&max=1&JOBNUMsumm=T] works. Seems that max=paramater does not work so the summ cuts the found items to only one. According to the docs: "Any valid search parameters are allowed, as defined in the Search command and [Search] context." But it seems that max=paramater is not a valid search command. Hey SM how about adding that one it, sure would be handy ! Stuart Tremain idfk web developments, sydney, australia On 25 Aug 2005, at 4:42 PM, Stuart Tremain wrote: > Hi > > We are serving from w2k WebDNA v6 > > This works > [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq=[JobNum] > &max=1&JOBNUMsumm=T] > ie deleted only the first matching record found > > This deletes ALL matching records: > [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq=[JobNum]&max=1] > > Any idea what is going on ? > > > Stuart Tremain > idfk web developments, sydney, australia > > > > ------------------------------------------------------------- > 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 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/ ------------------------------------------------------------- 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: Delete problem ( devaulw@onebox.com 2005)
  2. Re: Delete problem ( Stuart Tremain 2005)
  3. Delete problem ( Stuart Tremain 2005)
I think it is working, but not the way you expect. When you do a search, the max parameter only limits the founditems context and not the numfound tag. What you are doing works in an arbitrary way if there are more than one match and I'mnot sure why you'd want Webcatalog deleting one record over the other. Bill -----Original Message----- From: Stuart Tremain Sent: Thu, 25 Aug 2005 16:54:48 +1000 To: "WebDNA Talk" Subject: Re: Delete problem Well I understand why [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq= [JobNum]&max=1&JOBNUMsumm=T] works. Seems that max=paramater does not work so the summ cuts the found items to only one. According to the docs: "Any valid search parameters are allowed, as defined in the Search command and [search] context." But it seems that max=paramater is not a valid search command. Hey SM how about adding that one it, sure would be handy ! Stuart Tremain idfk web developments, sydney, australia On 25 Aug 2005, at 4:42 PM, Stuart Tremain wrote: > Hi > > We are serving from w2k WebDNA v6 > > This works > [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq=[JobNum] > &max=1&JOBNUMsumm=T] > ie deleted only the first matching record found > > This deletes ALL matching records: > [Delete db=sitedata/meterjobs.db&eqJOBNUMdatarq=[JobNum]&max=1] > > Any idea what is going on ? > > > Stuart Tremain > idfk web developments, sydney, australia > > > > ------------------------------------------------------------- > 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 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/ ------------------------------------------------------------- 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/ devaulw@onebox.com

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:

Referrer field to header field conversion (1997) Simple Database close connection (2001) If Empty ? (1997) Google does it... can WebDNA? Showing only the section with (2003) RequiredFields notes ... (1997) Problems w/ heavy use of cart header fields? (1998) [WebDNA] sort parameters in search (2015) Allow-Deny: Solved with [Getchars] (1998) billing system (2003) [OT] Regular Expressions (2003) [WebDNA] Re-sending email (2018) Emailer setup (1997) emailer (1997) Clickable maps and WebCatalog? (1996) Safe command=append (1999) HomePage Caution (1997) Date search bug (1998) Secure Server basic question... (1997) My slower response (1997) Creating folders and deleting files (1997)