Re: Incrementing a number

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18444
interpreted = N
texte = Dear All at WebCaTalk,I have tried the following - Alas in vain - Can somebody put me on the right track????
SKUWe have entered a unique code for this item or you can enter your own stock number if required. DateTodays date has been entered for you ETC. ETC.
I get the following in the SKU fieldError: the 'SEARCH' context requires that you specify a dbThree other queries.SKU is not a term I am familiar with and would like a translation. How do I update skuno.db when and only when the transaction is completed? Is there any information available on time saving tricks of the trade? >On 6/6/98 8:43 AM, greg wrote: > >>When I add a new product, I would like to have the sku field lookup the max >>sku number and add 1 to it. >> >>Can this be done? >Yeap with here is one solution, I don't know if you could do it with a >lookup > >db=yourdb.db&geskudata=0&skusort=1&skusdir=de&max=1][founditems][math][sku] >+1[/math][/founditems][/search]> Pat Naismith, 8, Kilgobbin Road, Stepaside, <> Dublin 18. IRELAND. Phone/Fax. +353 1 295 6780 Mobile +353 1 275 1701 Pat_Naismith@Bigfoot.Com naismith@indigo.ie Associated Messages, from the most recent to the oldest:

    
  1. Re: Incrementing a number (Kenneth Grome 1998)
  2. Re: Incrementing a number (Kenneth Grome 1998)
  3. Re: Incrementing a number (Pat Naismith 1998)
  4. Re: Incrementing a number (greg 1998)
  5. Re: Incrementing a number (Bob Minor 1998)
  6. Incrementing a number (greg 1998)
Dear All at WebCaTalk,I have tried the following - Alas in vain - Can somebody put me on the right track????
SKU[founditems][math][sku] +5[/math][/founditems][/search]>We have entered a unique code for this item or you can enter your own stock number if required. Date[date] size=15>Todays date has been entered for you ETC. ETC.
I get the following in the SKU fieldError: the 'SEARCH' context requires that you specify a dbThree other queries.SKU is not a term I am familiar with and would like a translation. How do I update skuno.db when and only when the transaction is completed? Is there any information available on time saving tricks of the trade? >On 6/6/98 8:43 AM, greg wrote: > >>When I add a new product, I would like to have the sku field lookup the max >>sku number and add 1 to it. >> >>Can this be done? >Yeap with here is one solution, I don't know if you could do it with a >lookup > >db=yourdb.db&geskudata=0&skusort=1&skusdir=de&max=1][founditems][math][sku] >+1[/math][/founditems][/search]> Pat Naismith, 8, Kilgobbin Road, Stepaside, <> Dublin 18. IRELAND. Phone/Fax. +353 1 295 6780 Mobile +353 1 275 1701 Pat_Naismith@Bigfoot.Com naismith@indigo.ie Pat Naismith

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:

Store Example to Use (1998) URL for Discussion Archive (1997) StandardConversions.db (1998) WebCatalog on Linux (2000) Sku numbers (1997) Re:Emailer setup (1997) Pull Down Search (2000) thankyou.tmpl (1997) WC TableGrinder (1997) Sample Tearoom Search Error (1998) WebCat2b12 CGI Mac - [shownext] problem (1997) Download URL & access on the fly ? (1997) Bit off subject -- Faxing orders (1997) Enhancement Request for WebCatalog-NT (1996) Non-Cart Files in Shopping Cart Folder (1997) Change Subtotal (2000) THANKS (1997) Secure Sever and showcart errors (1997) Instructions for Digest (1997) [/application] error? (1997)