SKU generator?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19849
interpreted = N
texte = Is there a way to generate a SKU dynamically?Here is the issue. I have a database I set up for a local township. People in the town will submit records to the database announcing activities etc. (kind of a bulletin board). The township administrators want to be able to approve the postings before they go live. So I set up a hidden field that gets submitted with each new posting called APPROVED which by default is set to False. When you search the postings as a user you only get to see the records that are APPROVED as True.If you go in as the Admin. you only see the records that have APPROVED set to False. On the Admin. page I have a link which I want to change the status of the record to APPROVED = True. I have the link set up the way I thought it would work but it changes the status of ALL the records.I looked at the samples in the general store and they seem to be using the SKU in the link to specify the record to change. I am not using a SKU, but the records do have a title field and I tried to use it in the same manner without any luck. Is there a way to generate a unique SKU without the person posting having to add it in with their new posting? Can someone give me a little advice on this??Thanks,-- -= Charles Kline =- _____________________________________ Pixel Dust Productions -- MacSultants ckline@webtown.com ckline@macsultants.com http://www.webtown.com http://www.macsultants.com Associated Messages, from the most recent to the oldest:

    
  1. Re: SKU generator? (Peter Ostry 1998)
  2. SKU generator? (charles kline 1998)
  3. Re: SKU generator? (Larry Hewitt 1998)
Is there a way to generate a SKU dynamically?Here is the issue. I have a database I set up for a local township. People in the town will submit records to the database announcing activities etc. (kind of a bulletin board). The township administrators want to be able to approve the postings before they go live. So I set up a hidden field that gets submitted with each new posting called APPROVED which by default is set to False. When you search the postings as a user you only get to see the records that are APPROVED as True.If you go in as the Admin. you only see the records that have APPROVED set to False. On the Admin. page I have a link which I want to change the status of the record to APPROVED = True. I have the link set up the way I thought it would work but it changes the status of ALL the records.I looked at the samples in the general store and they seem to be using the SKU in the link to specify the record to change. I am not using a SKU, but the records do have a title field and I tried to use it in the same manner without any luck. Is there a way to generate a unique SKU without the person posting having to add it in with their new posting? Can someone give me a little advice on this??Thanks,-- -= Charles Kline =- _____________________________________ Pixel Dust Productions -- MacSultants ckline@webtown.com ckline@macsultants.com http://www.webtown.com http://www.macsultants.com charles kline

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:

Calculating multiple shipping... (1997) webCatalog and Stocks (1998) Bug Report, maybe (1997) Cant get my own subtotal (2001) Group Updates (1998) [MATH] and Dates (1998) upgrading (1997) Fun with Dates - any progress? (1997) Protect (1997) Great product and great job ! (1997) Summary layout (1997) [WebDNA] Crashing Database (2011) expired beta (1997) Plugin or CGI or both (1997) Here we go again... (2006) [OT] gMail accounts (2004) [WebDNA] [OT] Recommended SSL Cert providers (2010) WebCatalog f2 Installation (1997) WebCat on 10.0.4 - iTools 6.0 (2001) WebCat2: multiple currency support (1997)