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:

shocart strange behavior (1999) Purchased cart being overwritten - still !?? (1997) [WebDNA] Clarifying talklist emails (2020) customizing the color of user's pages (1997) WebCat2: Formulas.db question (1997) Post size Limit? (1998) For those of you not on the WebCatalog Beta... (1997) totals (1997) displaying New products (using [date]) (1997) WebCat2 beta 11 - new prefs ... (1997) how to determine the actual file format of an image file? (2002) validatin (1998) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] Quotes invited - not for profit WebDNA site. (2016) Adding up weights (1998) sorting dates (1999) Group search - using contexts (2000) Founditems context returning only 1 item (1997) RE: path hierarchy notation (1998) Success Stories (1997)