numero = 18444
interpreted = N
texte = Dear All at WebCaTalk,I have tried the following - Alas in vain - Can somebody put me on theright track????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 6780Mobile +353 1 275 1701Pat_Naismith@Bigfoot.Com naismith@indigo.ie
Associated Messages, from the most recent to the oldest:
Dear All at WebCaTalk,I have tried the following - Alas in vain - Can somebody put me on theright track????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 6780Mobile +353 1 275 1701Pat_Naismith@Bigfoot.Com naismith@indigo.ie
Pat Naismith
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...