using bw in a search on a numeric field

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 27291
interpreted = N
texte = I have a need to have SKU's that are a subset of a main SKU. I am doing this through a fairly logical method of:30310624904012 (parent SKU) 30310624904012.1 (sub SKU) 30310624904012.2 (etc..) 30310624904012.3 (etc..)At some point in my program new SKU's need to be added, so I need to somehow find the next available subSKU. Here is my code snippet:[TEXT SHOW=F]SKU=30310624904012[/TEXT] [SEARCH DB=somedb.db&eqTYPEdatarq=AD&bwSKUdatarq=[SKU]&SKUtype=num&deSKUsort=1] [FOUNDITEMS] [TEXT SHOW=T]NEWSKU=[SKU].[MATH][LISTWORDS WORDS=[SKU]&DELIMITERS=.][SHOWIF [INDEX]=2][WORD][/SHOWIF][/LISTWORDS]+1[/MATH][/TEXT] [/FOUNDITEMS] [/SEARCH]In my database I do have 30310624904012.1 so NEWSKU should end up being 30310624904012.2. Not so. It turns out that the moment I set SKUtype=num, bw is no longer functional. It seems trivial that bw should work either way.Can this be fixed and/or is there a workaround?Thanks!--- jereme claussen --b-r-o-k-e-n-m-a-c-h-i-n-e-- jtc@brokenmachine.com -http://www.brokenmachine.com/ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
  1. using bw in a search on a numeric field (100-Watt Puppeteer 2000)
I have a need to have SKU's that are a subset of a main SKU. I am doing this through a fairly logical method of:30310624904012 (parent SKU) 30310624904012.1 (sub SKU) 30310624904012.2 (etc..) 30310624904012.3 (etc..)At some point in my program new SKU's need to be added, so I need to somehow find the next available subSKU. Here is my code snippet:[TEXT SHOW=F]SKU=30310624904012[/TEXT] [SEARCH DB=somedb.db&eqTYPEdatarq=AD&bwSKUdatarq=[SKU]&SKUtype=num&deSKUsort=1] [founditems] [TEXT SHOW=T]NEWSKU=[SKU].[math][LISTWORDS WORDS=[SKU]&DELIMITERS=.][SHOWIF [INDEX]=2][WORD][/SHOWIF][/LISTWORDS]+1[/MATH][/TEXT] [/FOUNDITEMS] [/SEARCH]In my database I do have 30310624904012.1 so NEWSKU should end up being 30310624904012.2. Not so. It turns out that the moment I set SKUtype=num, bw is no longer functional. It seems trivial that bw should work either way.Can this be fixed and/or is there a workaround?Thanks!--- jereme claussen --b-r-o-k-e-n-m-a-c-h-i-n-e-- jtc@brokenmachine.com -http://www.brokenmachine.com/ ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 100-Watt Puppeteer

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:

Can't find templaes (1997) HomePage Caution (1997) How to put the Trademark Symbol (%99) in Sendmail? (2003) Webcat4.5 on Windows Apache2 (2005) Questions (1998) Netscape v. IE (1997) vCards for Contact management (2004) WebCat2b12 Mac.acgi--[searchstring] bug (1997) 4.5.1 on Panther? (2004) Re:2nd WebCatalog2 Feature Request (1996) WC2b15 File Corruption (1997) Paranoid about serial numbers...not (1998) WebCatb15 Mac CGI -- [purchase] (1997) apparently to problem isolated (1997) Cart creation techniques (was Problems with Price field) (1997) auto adding SKUs w/DB helper (1998) can WC render sites out? (1997) Web Catalog 2 demo (1997) PIXO (1997) Saving [referrer] for later use (1997)