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

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 45635
interpreted = N
texte = depending on the number of results you plan on getting and the size of your database, you can do an rq search on each one of the numbers individually. Stuff them all in a temp database, along with the two sorting fields, then search and sort those results. You'd only need 3 searches, I think, since you could do a range of 400.1 - 400.9. >The PRODUCT_GROUP field only contains one value, but this can contain a '.' > >400.1 >200.3 >14 >81 >231.4 > >So find all records where PRODUCT_GROUP contains a range of values >seperated by commas. > >400.1,4,28.3,14.8,400.1 > > > >> >> As for the GROUPX comparisons and the rq option... >> >> Just to be clear, the PRODUCT_GROUP field has multiple values? Separated by a >> comma? Like 400.2,500,18,2? >> -- > > >------------------------------------------------------------- >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/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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: 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)
depending on the number of results you plan on getting and the size of your database, you can do an rq search on each one of the numbers individually. Stuff them all in a temp database, along with the two sorting fields, then search and sort those results. You'd only need 3 searches, I think, since you could do a range of 400.1 - 400.9. >The PRODUCT_GROUP field only contains one value, but this can contain a '.' > >400.1 >200.3 >14 >81 >231.4 > >So find all records where PRODUCT_GROUP contains a range of values >seperated by commas. > >400.1,4,28.3,14.8,400.1 > > > >> >> As for the GROUPX comparisons and the rq option... >> >> Just to be clear, the PRODUCT_GROUP field has multiple values? Separated by a >> comma? Like 400.2,500,18,2? >> -- > > >------------------------------------------------------------- >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/-- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.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/ John Hill

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:

How to Display text in empty fields (1997) Wanted: Broader string manipulation functions (1997) Next (1997) ups quickcost [repost] (1999) unable to launch acgi in WebCat (1997) Setting up shop (1997) RE: [WebDNA] Ubuntu 14.04 & WebDNA (2017) WebCat and WebTV (1997) Bug Report, maybe (1997) Loss in Form (1998) listfiles, moving files (1998) emailer (1997) Basics of tcpconnect (2006) Wanted: More Math Functions (or, Can You Solve This?) (1997) (OT) SERVER FREEZES ALL AT SAME TIME (2004) 4.0.x find (2000) Introduction/Tutorial/QuickStart (1997) Text data with spaces in them... (1997) [isfile] ? (1997) Fun with dates (1997)