Re: SKU Question

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 24369
interpreted = N
texte = Try this:[search db=mydb.db&grSKUdata=0&SKUsdir=de&max=1][math][founditems][sku][/founditems] +1[/math][/search]Should search for biggest sku and add 1 to it. I think . . . .:) Jesse Williams Proudman - NineWire Production http://www.ninewire.com <-> Jesse@ninewire.com Innovative and Creative Web Design and Hosting> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Rodolfo de la Garza > Sent: Saturday, November 13, 1999 9:41 PM > To: WebCatalog Talk > Subject: Re: SKU Question > > > I tried what Jesse recommend using it this way: > > [search db=mydatabase.db&eqSKUdata=[sku]][founditems][showif > [numFound]=0] [append] > [/showif][/founditems] > > If it is the first time I use this SKU, I suppose that [numFound] will be > 0 but it doesn't append it, I don't know why. > > Am I doing somethig wrong? > > On the other hand, Howard said: > > you could generate the SKU on the same form > where they enter the rest of the info, and on the submitted page,. Then, > if they go back and submit again, the record > will not be added because the replace will already see a record with that > sku, so it will replace it, otherwise if it doesn't aleady exist, it will > add it. > > > I don't understand, what does use a replace with append=t means. > I'm just learning. > > Ken said: > use an append context and put the code that creates your SKU inside the > context instead of in the form > > I'm using the append context and I can do it. It is true the SKU will be > not duplcated (Good Idea) but the item will be duplicated with different > SKU. > > Are there a way to prevent this? > > Thanks for your support. > > Rodolfo de la Garza > > > > > The 11/13/99 12:47 PM Jesse Williams Proudman lists@ninewire.com wrote > > >On the page that appends it, check to see if the sku is in use with a > >search. > > > >Jesse Williams Proudman - NineWire Production > > http://www.ninewire.com <-> Jesse@ninewire.com > > Innovative and Creative Web Design and Hosting > > > >> -----Original Message----- > >> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > >> Behalf Of Rodolfo de la Garza > >> Sent: Saturday, November 13, 1999 10:47 AM > >> To: WebCatalog Talk > >> Subject: SKU Question > >> > >> > >> Hi there, > >> > >> How can I prevent SKU to be duplicated by error? > >> If the user click the back button and submit again the item > the SKU will > >> be duplicated. > >> > >> Any Idea? > >> > >> Thanks. > >> > >> > >> ------------------------------------------------------------- > >> Brought to you by CommuniGate Pro - The Buzz Word Compliant > >> Messaging Server. > >> To end your Mail problems go to . >> >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: SKU Question (Aaron Lynch 1999)
  2. Re: SKU Question (Jesse Williams Proudman 1999)
  3. Re: SKU Question (J. A. Hill 1999)
  4. Re: SKU Question (Rodolfo de la Garza 1999)
  5. Re: SKU Question (Aaron Lynch 1999)
  6. Re: SKU Question (Rodolfo de la Garza 1999)
  7. Re: SKU Question (Kenneth Grome 1999)
  8. Re: SKU Question (Howard Wolosky 1999)
  9. Re: SKU Question (Jesse Williams Proudman 1999)
  10. SKU Question (Rodolfo de la Garza 1999)
Try this:[search db=mydb.db&grSKUdata=0&SKUsdir=de&max=1][math][founditems][sku][/founditems] +1[/math][/search]Should search for biggest sku and add 1 to it. I think . . . .:) Jesse Williams Proudman - NineWire Production http://www.ninewire.com <-> Jesse@ninewire.com Innovative and Creative Web Design and Hosting> -----Original Message----- > From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > Behalf Of Rodolfo de la Garza > Sent: Saturday, November 13, 1999 9:41 PM > To: WebCatalog Talk > Subject: Re: SKU Question > > > I tried what Jesse recommend using it this way: > > [search db=mydatabase.db&eqSKUdata=[sku]][founditems][showif > [numFound]=0] [append] > [/showif][/founditems] > > If it is the first time I use this SKU, I suppose that [numFound] will be > 0 but it doesn't append it, I don't know why. > > Am I doing somethig wrong? > > On the other hand, Howard said: > > you could generate the SKU on the same form > where they enter the rest of the info, and on the submitted page,. Then, > if they go back and submit again, the record > will not be added because the replace will already see a record with that > sku, so it will replace it, otherwise if it doesn't aleady exist, it will > add it. > > > I don't understand, what does use a replace with append=t means. > I'm just learning. > > Ken said: > use an append context and put the code that creates your SKU inside the > context instead of in the form > > I'm using the append context and I can do it. It is true the SKU will be > not duplcated (Good Idea) but the item will be duplicated with different > SKU. > > Are there a way to prevent this? > > Thanks for your support. > > Rodolfo de la Garza > > > > > The 11/13/99 12:47 PM Jesse Williams Proudman lists@ninewire.com wrote > > >On the page that appends it, check to see if the sku is in use with a > >search. > > > >Jesse Williams Proudman - NineWire Production > > http://www.ninewire.com <-> Jesse@ninewire.com > > Innovative and Creative Web Design and Hosting > > > >> -----Original Message----- > >> From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On > >> Behalf Of Rodolfo de la Garza > >> Sent: Saturday, November 13, 1999 10:47 AM > >> To: WebCatalog Talk > >> Subject: SKU Question > >> > >> > >> Hi there, > >> > >> How can I prevent SKU to be duplicated by error? > >> If the user click the back button and submit again the item > the SKU will > >> be duplicated. > >> > >> Any Idea? > >> > >> Thanks. > >> > >> > >> ------------------------------------------------------------- > >> Brought to you by CommuniGate Pro - The Buzz Word Compliant > >> Messaging Server. > >> To end your Mail problems go to . >> >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to >> >> > > >------------------------------------------------------------- >Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. >To end your Mail problems go to . > >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to > ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Jesse Williams Proudman

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:

[WebDNA] [OT] WebDNA Payment Processing Integration Recommendations? (2011) problems with WebCat-Plugin (1997) Is this possible in simple search? question? (1998) WebCommerce: Folder organization ? (1997) pictures / referrer etc. (1998) spawn (1998) TCPconnect & XML (2008) Looking up two prices in database? (1997) Location of Browser Info.txt file (1997) [searchString] (1997) Template transformed itself into a database? (1998) Bannerad Demo (1998) email problem (2005) Colocator Upgrading OS (2004) AOL and webcat (1998) Crediting money back to a customer (2000) WebMerchant/MacAuthorize (1998) Show next 2 examples that work (1997) emailer cc to figured out (1997) Here we go again...WebDNA - SQL- Clustering (2006)