Re: Dividers

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52014
interpreted = N
texte = 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/ 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)
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/ Steve Craig

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:

[WebDNA] A universal version of WebDNA ... (2008) Trigger time setting (2002) Number of Open Databases (1998) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Large Database Options? (1999) Webmerchant/Cybercash (2000) breaking words (1997) taxrate - off by 1 cent (1997) Talk List Suggestions (1997) Webcat/Webmerchant (1998) Shopping problems with 2.1b3 acgi (1997) [index] (1997) emailer 150 (1997) Searching for all records (1998) webcatalog 2.1.3 ACGI Weirdness? (1998) test... (2007) OT: Mobile Phone "mailto:" (2008) Adding Shipping Costs based on percent of subtotal (1997) Resume Catalog ? (1997) New Plug-in and Type 11 errors (1997)