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". - brian On 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:

    
  1. Re: [Math] Problem!!!! ( Lawrence 2004)
  2. Re: [Math] Problem!!!! ( Stuart Tremain 2004)
  3. Re: [Math] Problem!!!! ( Brian Fries 2004)
  4. Re: [Math] Problem!!!! ( Clint Davis 2004)
  5. [Math] Problem!!!! ( Lawrence 2004)
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". - brian On 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)