Re: Dividers
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52015
interpreted = N
texte = [text]NUMbw=1[/text] [search db=&asNUMsort=1&NUMtype=num] [founditems]
| [Num] | [Field1] | [Field2] |
[showif [getchars start=1&end=1][num][/getchars]![NUMbw]] [text]NUMbw=[getchars start=1&end=1][num][/getchars][/text]
| ================== |
[/showif] [/founditems] [/search] ----- Original Message ----- From: "Steve Craig"
To: "WebDNA Talk" Sent: Thursday, July 31, 2003 8:05 AM Subject: Re: Dividers > 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:
[text]NUMbw=1[/text] [search db=&asNUMsort=1&NUMtype=num] [founditems] | [Num] | [Field1] | [Field2] |
[showif [getchars start=1&end=1][num][/getchars]![NUMbw]] [text]NUMbw=[getchars start=1&end=1][num][/getchars][/text] | ================== |
[/showif] [/founditems] [/search] ----- Original Message ----- From: "Steve Craig" To: "WebDNA Talk" Sent: Thursday, July 31, 2003 8:05 AM Subject: Re: Dividers > 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/
"WebDna @"
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:
[isfile] ? (1997)
Mac v. NT (1998)
using showpage and showcart commands (1996)
bug in wn searching NT version? (1997)
OT: Please set your computer's clock (1997)
Hiding HTML and page breaks (1997)
New Featured Site (1999)
Emailer port change (1997)
RequiredFields notes ... (1997)
Using Cookie for client specific info? (1997)
[WebDNA] I'm stuck... :-( (2009)
SiteEdit Pro Update Announcement (1997)
Multiple Pulldowns (1997)
[OT] SSL security in browser (2005)
WebCatalog can't find database (1997)
Multiple catalog databases and showcart (1997)
Location of Browser Info.txt file (1997)
WebMerchant 1.6 and https (1997)
Secure Server (1997)
Lookup & Form Variables (2000)