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 doingthis 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 tosomehow 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 being30310624904012.2. Not so. It turns out that the moment I setSKUtype=num, bw is no longer functional. It seems trivial that bw shouldwork 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 doingthis 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 tosomehow 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 being30310624904012.2. Not so. It turns out that the moment I setSKUtype=num, bw is no longer functional. It seems trivial that bw shouldwork 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)