Re: SKU generator?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 19846
interpreted = N
texte = The following code produces a sequential SKU when a record is added. Just modify the database name.Larry>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 > ======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 fax: 360/748-4299 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)
The following code produces a sequential SKU when a record is added. Just modify the database name.[math][sku] + 1[/math][/founditems][/search]>Larry>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 > ======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 fax: 360/748-4299 Larry Hewitt

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:

apparent variable variable display? (2000) OT: Limit on # of Pulldown entries (1997) Trouble with Netscape (1998) Shownext and search context (2000) 3.0 [TEXT] variables (1998) [protect] on NT? (1997) calender with business days (1998) nesting limits? (1998) [math] and ceil (2004) Search for starts with and ends with? (2003) RE: too many nested [xxx] (1997) Pithy questions on webcommerce & siteedit (1997) WebCatb15 Mac CGI -- [purchase] (1997) [dos] command question (1997) Integration with SQL (1997) Running 2 two WebCatalog.acgi's (1996) Email notification to one of multiple vendors ? (1997) PSC recommends what date format yr 2000??? (1997) minimalist shopping cart. (1997) Access Denied! But why? (1997)