Re: Dividers

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52016
interpreted = N
texte = Try this (not tested): [math]myCounter=199[/math] [search db=] [founditems] [num][field1][field2] [showif [num]>[mycounter]] ================== [math]mycounter=[mycounter]+100[/math] [/showif] [/founditems] [/search] >This might work if there were 100s of records but there could be just 20 >returned although the number field could stretch from 101 to 1500. The index >is only counting how many records returned not the value of the number >field. > >I.e. I could in theory have... > >121 >135 >208 >219 >366 >433 >705 >1206 >1405 >1499 > >Any help much appreciated. > >> Try this... >> >> [search db=] >> [founditems] >> >> >> [Num] [Field1] [Field2] >> >> >> [showif [index]\100] > > >> ================== >> > > [/showif] >> > > [/founditems] > > [/search] >> >> Cheers >> >> Paul >> >> On Thursday, July 31, 2003, at 02:46 pm, Steve Craig wrote: >> >>> Hi >>> >>> Sorry about this but my brain has just shut down and I can't think of >>> the >>> logic I need to accomplish a simple thing. I have a database of >>> records that >>> contain a number in one of the fields. I am trying to list out all the >>> records like.. >>> >>> Num Field1 Field2 .... And so on >>> 112 Blah Blah >>> 189 Blah Blah >>> 243 Blah Blah >>> 255 Blah Blah >>> 268 Blah Blah >>> 301 Blah Blah >>> etc etc >>> >>> What I want to do is insert a dividing table row every time the number >>> goes >>> past each unit of 100 ie... >>> >>> Num Field1 Field2 .... And so on >>> 112 Blah Blah >>> 189 Blah Blah >>> ================== >>> 243 Blah Blah >>> 255 Blah Blah >>> 268 Blah Blah >>> ================== >>> 301 Blah Blah >>> >>> I'm sure this is easy but thoughts of my holiday which starts tomorrow >>> are >>> taking over. Thanks for any help. >>> >>> Cheers >>> ======================================== >>> Steve Craig - Asylum Interactive Ltd >>> Tel +44 1224 642960 Fax +44 1224 642962 >>> ======================================== >>> http://www.asylumweb.com >>> Email: steve@asylumweb.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/ >> > >======================================== >Steve Craig - Asylum Interactive Ltd >Tel +44 1224 642960 Fax +44 1224 642962 >======================================== >http://www.asylumweb.com >Email: steve@asylumweb.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: Dividers ( Brian Fries 2003)
  2. Re: Dividers ( Donovan 2003)
  3. Re: Dividers ( Brian Fries 2003)
  4. Re: Dividers ( sallyr@dvinci.com (Sally Reidy) 2003)
  5. Re: Dividers ( "WebDna @" 2003)
  6. Re: Dividers ( Steve Craig 2003)
  7. Re: Dividers ( Paul Willis 2003)
  8. Dividers ( Steve Craig 2003)
Try this (not tested): [math]myCounter=199[/math] [search db=] [founditems] [num][field1][field2] [showif [num]>[mycounter]] ================== [math]mycounter=[mycounter]+100[/math] [/showif] [/founditems] [/search] >This might work if there were 100s of records but there could be just 20 >returned although the number field could stretch from 101 to 1500. The index >is only counting how many records returned not the value of the number >field. > >I.e. I could in theory have... > >121 >135 >208 >219 >366 >433 >705 >1206 >1405 >1499 > >Any help much appreciated. > >> Try this... >> >> [search db=] >> [founditems] >> >> >> [Num] [Field1] [Field2] >> >> >> [showif [index]\100] > > >> ================== >> > > [/showif] >> > > [/founditems] > > [/search] >> >> Cheers >> >> Paul >> >> On Thursday, July 31, 2003, at 02:46 pm, Steve Craig wrote: >> >>> Hi >>> >>> Sorry about this but my brain has just shut down and I can't think of >>> the >>> logic I need to accomplish a simple thing. I have a database of >>> records that >>> contain a number in one of the fields. I am trying to list out all the >>> records like.. >>> >>> Num Field1 Field2 .... And so on >>> 112 Blah Blah >>> 189 Blah Blah >>> 243 Blah Blah >>> 255 Blah Blah >>> 268 Blah Blah >>> 301 Blah Blah >>> etc etc >>> >>> What I want to do is insert a dividing table row every time the number >>> goes >>> past each unit of 100 ie... >>> >>> Num Field1 Field2 .... And so on >>> 112 Blah Blah >>> 189 Blah Blah >>> ================== >>> 243 Blah Blah >>> 255 Blah Blah >>> 268 Blah Blah >>> ================== >>> 301 Blah Blah >>> >>> I'm sure this is easy but thoughts of my holiday which starts tomorrow >>> are >>> taking over. Thanks for any help. >>> >>> Cheers >>> ======================================== >>> Steve Craig - Asylum Interactive Ltd >>> Tel +44 1224 642960 Fax +44 1224 642962 >>> ======================================== >>> http://www.asylumweb.com >>> Email: steve@asylumweb.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/ >> > >======================================== >Steve Craig - Asylum Interactive Ltd >Tel +44 1224 642960 Fax +44 1224 642962 >======================================== >http://www.asylumweb.com >Email: steve@asylumweb.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/ sallyr@dvinci.com (Sally Reidy)

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:

RE: [WebDNA] test 2 (2019) bug in [SendMail] (1997) carriage returns in data (1997) frames & carts (1997) [WebDNA] Digital Ocean /WebDNA is not configured to accept (2019) Execute Applescript (1997) Unknown error: OrderNotCreated (1997) WebCat virtual postcard is done! Thanks for the help! (1998) Just Testing (1997) unsubscribe (1997) RE: Cookies? (1997) problems with 2 tags shakur (1997) New syntax feedback for 4.0 (2000) Public beta 5 of WebCatalog 4.0 is now available (2000) Custom errormessages.db to intercept directory names (2002) WebDNA + MLS (2006) [include file] wrong path or syntax when using / referingtoothe root (2002) search question (2001) Some Questions (1997) faulure to encrypt (or maybe decrypt) (1999)