Re: Sku numbers
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11627
interpreted = N
texte = >>The trouble I found with using a cart value for a SKU is that if a user is>>adding multiple records they might use the browsers back button to return>>to the add_record.tmpl. If that happens then they will entering records>>with identical cart values.>>Try this: don't ever set cart=[cart] in any of the URLs that lead to these>pages. On your page that actually adds the new record (a page like>AdValidator.tmpl) that has the [Append db=xxx.db]...[/Append] context in>it, use sku=[cart]. SInce you got to this page with no cart= in the URL,>WebCatalog will make up a new one that is guaranteed unique.Hi Grant,I tried this technique once, but it creates a whole new problem you may nothave seen before. I agree that it resolves the Back button problem, but itcreates a new 'Reload' button problem:When the user click the Reload button on the [append] page you describedabove, a new duplicate record is appended - with exactly the same data asthe previous record.What makes this even worse is that the user can simply continue to clickthe Reload button - hundreds or thousands of times - and each time thatbutton is clicked, another identical duplicate record is appended to thedatabase!Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html
Associated Messages, from the most recent to the oldest:
>>The trouble I found with using a cart value for a SKU is that if a user is>>adding multiple records they might use the browsers back button to return>>to the add_record.tmpl. If that happens then they will entering records>>with identical cart values.>>Try this: don't ever set cart=
[cart] in any of the URLs that lead to these>pages. On your page that actually adds the new record (a page like>AdValidator.tmpl) that has the [Append db=xxx.db]...[/Append] context in>it, use sku=
[cart]. SInce you got to this page with no cart= in the URL,>WebCatalog will make up a new one that is guaranteed unique.Hi Grant,I tried this technique once, but it creates a whole new problem you may nothave seen before. I agree that it resolves the Back button problem, but itcreates a new 'Reload' button problem:When the user click the Reload button on the
[append] page you describedabove, a new duplicate record is appended - with exactly the same data asthe previous record.What makes this even worse is that the user can simply continue to clickthe Reload button - hundreds or thousands of times - and each time thatbutton is clicked, another identical duplicate record is appended to thedatabase!Sincerely, Ken Grome ..... ken@iav.comhttp://usarea.net/home.html
Kenneth Grome
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:
carriage returns in data (1997)
set header in DB (no cart) (2003)
billing system (2003)
Previous and Next Solution (2004)
TaxTotal Problem (1997)
reading a cookie problem (1998)
Database wiped clean (2005)
ShowNext (1997)
How true is this? (1999)
Caching [include] files ... (1997)
[random] only for 1-100??? (1997)
RequiredFields template (1997)
Seeking Better Display of results... (1997)
Document Contains no data, or showcart error. (1997)
Layers,Dreamweaver and WebCat Code (2000)
(no subject) (1997)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
Aaron kant add (or whatever it was) (2000)
PROBLEM (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)