Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45630
interpreted = N
texte = I disagree here .. If I specify a wbrk on my search .. Say &FIELDwbrk=, then I would expect that to carry into the field as well, no just the search string.I am essentially looking for 'strings' in the search and am specifying what breaks up the strings.300.5,2.2,100,5 is a string broken up with ,'s if I add &wbrk=, to the search I would think this was also used to break up the field .. Especially when using &FIELDword=ww.Perhaps my logic is wrong ? Alain > I think the results you see are valid. If one of the words you're matching is > 2 then 400.2 is a match because 2 is surrounded on both sides by a word > separator (space and period). Remember, You're looking at text, not numbers. > The wbrk parameter affects the search string - not the values in the database > field. You're correct that wo is not a valid comparison operator for numeric > fields. In this case you should do this (I haven't tested, so it may need > debugging, but it should get you started): > > [search > db=products.db&GROUP1field=BLAH&GROUP2field=BLAH&eqGROUP1data=400.2&GROUP1type > =num&eqGROUP2data=400.9&GROUP2type=num...] > > If you have a variable number of items you can set up the GROUPX parameters in > a loop context. > > I hope this helps clear some things up and get's your signoff so you can get > paid :> > > John. > >> I saw this in the archives a few days ago and now it has affected us .. >> We have a search as follows >> >> [search db=products.db&woGROUPdata=400.2,400.9,2&GROUPword=ww&GROUPwbrk=,] >> >> This unfortunately returns groups as follows >> >> 51.2 >> 800.2 >> 400.2 >> 2 >> 400.9 >> >> As you can see the results are not as they should be .. When we take 2 out >> of the search string this works perfectly. We have tried all sorts of other >> delimiters and the results are the same. >> >> Can someone please confirm this and let us know when a fix is coming ?? Ken >> mentioned in his response he knew of this a couple of years ago - WebDNA >> cannot ignore it's internet delimiters when &wbrk= is specified in the >> search ? Perhaps this could be squeezed into the 4.5.1 patch ? > > ------------------------------------------------------------- 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: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Rob Marquardt 2002)
  2. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (John Hill 2002)
  3. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Dennis J. Bonsall, Jr. 2002)
  4. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Dennis J. Bonsall, Jr. 2002)
  5. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Alain Russell 2002)
  6. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Stuart Tremain 2002)
  7. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Scott Anderson 2002)
  8. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Alain Russell 2002)
  9. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (John Hill 2002)
  10. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Rob Marquardt 2002)
  11. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (John Hill 2002)
  12. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Alain Russell 2002)
  13. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (John Hill 2002)
  14. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Bob Minor 2002)
  15. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Tim Robinson 2002)
  16. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (Alain Russell 2002)
  17. Re: URGENT: NO BUG, woFIELDdata & FIELDword=ww (John Hill 2002)
I disagree here .. If I specify a wbrk on my search .. Say &FIELDwbrk=, then I would expect that to carry into the field as well, no just the search string.I am essentially looking for 'strings' in the search and am specifying what breaks up the strings.300.5,2.2,100,5 is a string broken up with ,'s if I add &wbrk=, to the search I would think this was also used to break up the field .. Especially when using &FIELDword=ww.Perhaps my logic is wrong ? Alain > I think the results you see are valid. If one of the words you're matching is > 2 then 400.2 is a match because 2 is surrounded on both sides by a word > separator (space and period). Remember, You're looking at text, not numbers. > The wbrk parameter affects the search string - not the values in the database > field. You're correct that wo is not a valid comparison operator for numeric > fields. In this case you should do this (I haven't tested, so it may need > debugging, but it should get you started): > > [search > db=products.db&GROUP1field=BLAH&GROUP2field=BLAH&eqGROUP1data=400.2&GROUP1type > =num&eqGROUP2data=400.9&GROUP2type=num...] > > If you have a variable number of items you can set up the GROUPX parameters in > a loop context. > > I hope this helps clear some things up and get's your signoff so you can get > paid :> > > John. > >> I saw this in the archives a few days ago and now it has affected us .. >> We have a search as follows >> >> [search db=products.db&woGROUPdata=400.2,400.9,2&GROUPword=ww&GROUPwbrk=,] >> >> This unfortunately returns groups as follows >> >> 51.2 >> 800.2 >> 400.2 >> 2 >> 400.9 >> >> As you can see the results are not as they should be .. When we take 2 out >> of the search string this works perfectly. We have tried all sorts of other >> delimiters and the results are the same. >> >> Can someone please confirm this and let us know when a fix is coming ?? Ken >> mentioned in his response he knew of this a couple of years ago - WebDNA >> cannot ignore it's internet delimiters when &wbrk= is specified in the >> search ? Perhaps this could be squeezed into the 4.5.1 patch ? > > ------------------------------------------------------------- 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/ Alain Russell

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:

Text data with spaces in them... (1997) Uh...can someone help me out with the b10? (1997) Been meaning to ask... (1997) Talk List Suggestions (1997) Repeating Fields (1997) WC2b15 File Corruption (1997) Cart Number sequence (1997) How do I specify a & character in Grep? (2000) Running 2 two WebCatalog.acgi's (1996) Need relative path explanation (1997) RE: [isfolder] and [filename] (1997) Shopping Cart Problem (1998) Not really WebCat (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Trouble with Category search (2000) db Translation (2002) New syntax feedback for 4.0 (2000) Just Testing (1997) tab as word delimiter (2000) Can you do this??? and other stuff (1997)