Re: Unique SKUs

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31981
interpreted = N
texte = Christopher:What I do is search on the Sku field to find the largest number, then I add 1 to it and assign that to the new record. This is in a database file where I started the SKU's at 1 and just need to generate unique IDs that have no other meaning. SallyAt 12:28 PM 5/17/00 -0300, you wrote: >Hi, > >Still flailing away learning WebCat 3 (5.0 will be out before I learn >it at this rate :) > >The Question: >How do I get a unique SKU to be automatically generated when using an >append context or command? > > >The Details: >I'm building a simple contact database application. I've used the >Database Helper as a starting point, and I've got most of it working. >Editing & deleting records works great. I've got it sorting things >nicely. The light is dawning. But... > >Append context. When adding records to the contacts.db, the SKU >should be generated on the fly -- as a unique character string -- by >WebCat. How do I do this? I tried passing > > > >in the form, but this enters > > %5Bsku%5D > >into the SKU field -- not exactly what I'm looking for... (I realise >the field doesn't need to be visible to pass the value, but it's the >same result -- I get a new record okay, but the SKU is always >%5Bsku%5D). > > >Regards, > >Christopher Mackay, Multimedia Developer >Tantramar Interactive, http://www.tantramar.com/ >506/364-1097 cell: 364-7659 fax: 536-2409 > >------------------------------------------------------------- >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/ > > ------------------------------------------------------------- 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: Multiple Unique SKUs (Clint Davis 2000)
  2. Re: Multiple Unique SKUs (John Peacock 2000)
  3. Re: Multiple Unique SKUs (Kim Ingram 2000)
  4. Multiple Unique SKUs (Clint Davis 2000)
  5. Re: Unique SKUs (Joseph D'Andrea 2000)
  6. Re: Unique SKUs (WebDNA Support 2000)
  7. Re: Unique SKUs (Clint Davis 2000)
  8. Re: Unique SKUs (Robert Wade 2000)
  9. Re: Unique SKUs (Sally Reidy 2000)
  10. Unique SKUs (Christopher Mackay 2000)
Christopher:What I do is search on the Sku field to find the largest number, then I add 1 to it and assign that to the new record. This is in a database file where I started the SKU's at 1 and just need to generate unique IDs that have no other meaning. SallyAt 12:28 PM 5/17/00 -0300, you wrote: >Hi, > >Still flailing away learning WebCat 3 (5.0 will be out before I learn >it at this rate :) > >The Question: >How do I get a unique SKU to be automatically generated when using an >append context or command? > > >The Details: >I'm building a simple contact database application. I've used the >Database Helper as a starting point, and I've got most of it working. >Editing & deleting records works great. I've got it sorting things >nicely. The light is dawning. But... > >Append context. When adding records to the contacts.db, the SKU >should be generated on the fly -- as a unique character string -- by >WebCat. How do I do this? I tried passing > > [url][sku][/url]> > >in the form, but this enters > > %5Bsku%5D > >into the SKU field -- not exactly what I'm looking for... (I realise >the field doesn't need to be visible to pass the value, but it's the >same result -- I get a new record okay, but the SKU is always >%5Bsku%5D). > > >Regards, > >Christopher Mackay, Multimedia Developer >Tantramar Interactive, http://www.tantramar.com/ >506/364-1097 cell: 364-7659 fax: 536-2409 > >------------------------------------------------------------- >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/ > > ------------------------------------------------------------- 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/ Sally Reidy

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:

Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) Image maps/Webcat (1997) Calendar (1997) still facing truncated [texta] problem (2000) $append (1998) SiteGuard Use Question (1997) How long until WebDNA makes the list? :( (2004) WebCat editing, SiteGuard & SiteEdit (1997) oops private message leaked into talk list (1997) Mass Mail (2000) Great product and great job ! (1997) When to use [convertchars] ?!?!? (2000) suffix mapping for NT? (1997) Hiding HTML and breaking the page (1997) [WebDNA] [OT] Free Windows FTP client recommendations (2009) New Webcatalog for Mac (1997) A matter of time (1997) Setting up WebCatalog with Retail Pro data (1996) WebCatalog for Postcards ? (1997) Field names beginning with Reg.. (2002)