Re: [Math] Problem!!!!
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57216
interpreted = N
texte = Try removing the "thousands" from your format - that will insert commas, and resulting numbers like "012,345" which will cause problems for the MATH context.According to WebDNA, [math]012,345+1[/math] = 346 (345+1)As for the SKUtype=num, that's not actually necessary if all the SKUs are properly formatted with the .6d formatting (exactly 6 digits with leading zeros inserted if necessary). Text sorting will work properly with numbers formatted as "000999" "012345" "765432" etc., while the type=num would be necessary if they were "999" "12345" and "765432".- brianOn Apr 2, 2004, at 12:05 PM, Clint Davis wrote:> You need specify that your SKU is a number...>> [search db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&SKUtype=num&max=1]>>> On 4/2/04 1:26 PM, "Lawrence"
wrote:>>> Hi,>>>> I have a strange problem with a [Math] context.>>>> I have a db for which I increase the number with :>> [append db=coord.db]SKU=[Format thousands .6d][!]>> [/!][search>> db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&max=1][founditems][math][SK >> U]+1[/>> math][!]>> [/!][/founditems][/search][/Format][/append]>>>> Once I have reached 10000 I can't increase the number any more!>> If I try to make a simple [append] with an number (ex:10250) There is >> no>> problem. Once this is the last number, if there is a new connection I >> still>> get "10000" as the latest number>>>> If I make a simple db request>> [search db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&max=1]>> [founditems]>> [SKU]
[/founditems][/search]>>>> I get 99999 as an answer !!!!!!>>>> What's wrong with my db Or with Webcatalog??????-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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 removing the "thousands" from your format - that will insert commas, and resulting numbers like "012,345" which will cause problems for the MATH context.According to WebDNA, [math]012,345+1[/math] = 346 (345+1)As for the SKUtype=num, that's not actually necessary if all the SKUs are properly formatted with the .6d formatting (exactly 6 digits with leading zeros inserted if necessary). Text sorting will work properly with numbers formatted as "000999" "012345" "765432" etc., while the type=num would be necessary if they were "999" "12345" and "765432".- brianOn Apr 2, 2004, at 12:05 PM, Clint Davis wrote:> You need specify that your SKU is a number...>> [search db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&SKUtype=num&max=1]>>> On 4/2/04 1:26 PM, "Lawrence" wrote:>>> Hi,>>>> I have a strange problem with a [math] context.>>>> I have a db for which I increase the number with :>> [append db=coord.db]SKU=[Format thousands .6d][!]>> [/!][search>> db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&max=1][founditems][math][SK >> U]+1[/>> math][!]>> [/!][/founditems][/search][/Format][/append]>>>> Once I have reached 10000 I can't increase the number any more!>> If I try to make a simple [append] with an number (ex:10250) There is >> no>> problem. Once this is the last number, if there is a new connection I >> still>> get "10000" as the latest number>>>> If I make a simple db request>> [search db=coord.db&neSKUdata=FIND_ALL&deSKUsort=1&max=1]>> [founditems]>> [SKU]
[/founditems][/search]>>>> I get 99999 as an answer !!!!!!>>>> What's wrong with my db Or with Webcatalog??????-- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/
Brian Fries
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:
Cancel Subscription (1996)
Automatic Forwarding using WebCat (1997)
RE:It just Does't add up!!! (1997)
Summary layout (1997)
Good vs. Bad; also [setHeader] (2002)
emailer stuck (1997)
Bit off subject -- Faxing orders (1997)
FEA REQ: One .hdr, multiple .db's (2003)
searchable list archive (1997)
I'm new be kind (1997)
FW: It gets better... posting problems + Webcat 3.0.7 avail able - did anyone know? (2000)
Trouble with formula.db (1997)
Sort Order on a page search (1997)
Emailer Set Up (1997)
Why WebMerchant not working? (1999)
RE: [WebDNA] Basic Search (2008)
Resume Catalog ? (1997)
Frustration with formulas.db (1999)
Grep issue (2003)
NetSplat and WebCat2 (1997)