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:
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)