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 AMSubject: 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. Theindex> 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:

Re: Dividers ( Brian Fries 2003)
Re: Dividers ( Donovan 2003)
Re: Dividers ( Brian Fries 2003)
Re: Dividers ( sallyr@dvinci.com (Sally Reidy) 2003)
Re: Dividers ( "WebDna @" 2003)
Re: Dividers ( Steve Craig 2003)
Re: Dividers ( Paul Willis 2003)
Dividers ( Steve Craig 2003)

[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 AMSubject: 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. Theindex> 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!

Re: Dividers

2003

Top Articles:

Related Readings: