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:

Ok here is a question? (1997) F3 crashing server (1997) unclear on a simple [cart] ? (1998) add to cart within a page? (1997) Problems problems problems (1997) Execute Applescript (1997) Finding unused SKU's in a database (2002) emailer don't work (1998) TaxTotal Problem (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) (1997) Optional new-style syntax for WebCatalog 4.0 (2000) partial credits (2003) LookUp Tag (1997) Help name our technology! I found it (1997) redirect within a showif (1998) Country & Ship-to address & other fields ? (1997) detecting already used [cart]? (2005) Re1000001: Setting up shop (1997) Searching multiple fields from one form field (1997)