Re: SKU Question
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24369
interpreted = N
texte = Try this:[searchdb=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 MessagingServer.>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 MessagingServer.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:
Try this:[searchdb=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 MessagingServer.>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 MessagingServer.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)