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 Consultant 808-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:

    
  1. Re: Auto SKU's (Kenneth Grome 2000)
  2. Re: Auto SKU's (Paul Willis 2000)
  3. Re: Auto SKU's (Jason Tyler 2000)
  4. Re: Auto SKU's (Marty Schmid 2000)
  5. Re: Auto SKU's (WebDNA Support 2000)
  6. Re: Auto SKU's (Jeff Logan 2000)
  7. Re: Auto SKU's (Jason Tyler 2000)
  8. Re: Auto SKU's (Jeff Logan 2000)
  9. Re: Auto SKU's (Jason Tyler 2000)
  10. Auto SKU's (Jeff Logan 2000)
>>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 Consultant 808-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)