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:
| |
- 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:
totals (1997)
Location of Webcat site in folder hierarchy (1997)
showcart is slow (1998)
WebCatalog Plug-in for Webstar. (1997)
Locking up with WebCatalog... (1997)
includes and cart numbers (1997)
Bit off subject -- Faxing orders (1997)
mod_webcatalog2.so.2-40 is garbled (2008)
WebCat2 several catalogs? (1997)
portal (2002)
Bug Report, maybe (1997)
Keep away (1997)
WC Database Format (1997)
PSC recommends what date format yr 2000??? (1997)
Download capabilities (1997)
[cart]'s ever get recycled? (2000)
The word TYPE in search contexts and fields (1998)
server2003 issue (OT) (2006)
mac os HOG? (2001)
2.1 Stuff (1998)