Re: Auto SKU's
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33460
interpreted = N
texte = >>How do I set it up so sku's are automatically assigned in my databases?>>In order to assist with this type of request, WebCatalog 4.0 has a>new set of tags in [search] which quickly give you the min, max, avg,>and sum of a numeric field column. You can use this to calculate the>highest sku number and then add 1 to it with a [math] context.>>[search db=blah&neskudata=[blank]]>next sku is: [math][max field=sku]+1[/math]>[/search]We have always been able to do a search to get this value in webcat2 and webcat3 with this code:[search db=blah&neskudata=[blank]&deskusort=1&max=1]next sku is: [math][sku]+1[/math][/search]So as everyone can see, versions 2 and 3 can do the same thing without needing any of the special new tags in version4 ...================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>>How do I set it up so sku's are automatically assigned in my databases?>>In order to assist with this type of request, WebCatalog 4.0 has a>new set of tags in [search] which quickly give you the min, max, avg,>and sum of a numeric field column. You can use this to calculate the>highest sku number and then add 1 to it with a [math] context.>>[search db=blah&neskudata=[blank]]>next sku is: [math][max field=sku]+1[/math]>[/search]We have always been able to do a search to get this value in webcat2 and webcat3 with this code:[search db=blah&neskudata=[blank]&deskusort=1&max=1]next sku is: [math][sku]+1[/math][/search]So as everyone can see, versions 2 and 3 can do the same thing without needing any of the special new tags in version4 ...================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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://search.smithmicro.com/
Kenneth Grome
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:
Separate SSL Server (1997)
Timer Values on [redirect] (1998)
Deleting Orders (1997)
authenticate broken when url not fully specified? (2000)
decrypt and summ problems (1999)
Plugin or CGI or both (1997)
Calendar Program (2004)
[WebDNA] Cheap tiny VPS running WebDNA 7.0 FastCGI !!! (2010)
accountnum using [listwords] (2001)
Thanks ! (1997)
"top" Clarification ( for apache ) (2008)
RAM variables (1997)
Weird bug, or is there something amiss? (1997)
Help name our technology! (1997)
OT-ssh help (2004)
Spaces causing netscape to act weird . . . (2002)
restarting service remotely on NT (1997)
Fun with Dates - finally resolved but.... (1997)
Separate SSL Server (1997)
WebCat and WebTV (1997)