[carts] and databases
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11886
interpreted = N
texte = OK so I messed up when I first got started using WebCat2.0 and created a database that doesn't use a [cart] to create a unique record ID.What happened is that somebody used the back button and then went foreward using the html and created to identical records based on a name. If they would have started at my add page entry point I have a checker there to prevent this....but oh well it happened. When we tried to delete these records both with the same name it hung webcat. So what I want to do is go back this weekend and import the database into FilemakerPro and add a field that in the future will be a [cart] number so this problem never occurs again. This is all in a database not used for shopping.So can I just make the field where the [cart] value will go and just fill each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records and then any new records will get the [cart] value? Anybody do this yet? Seems like it should not be a problem. Just looking for somebody elses experince who has done this.Live and Learn.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
Associated Messages, from the most recent to the oldest:
OK so I messed up when I first got started using WebCat2.0 and created a database that doesn't use a
[cart] to create a unique record ID.What happened is that somebody used the back button and then went foreward using the html and created to identical records based on a name. If they would have started at my add page entry point I have a checker there to prevent this....but oh well it happened. When we tried to delete these records both with the same name it hung webcat. So what I want to do is go back this weekend and import the database into FilemakerPro and add a field that in the future will be a
[cart] number so this problem never occurs again. This is all in a database not used for shopping.So can I just make the field where the
[cart] value will go and just fill each recored like 1,2,3,4,5,6 and so forth for these 225 some odd records and then any new records will get the
[cart] value? Anybody do this yet? Seems like it should not be a problem. Just looking for somebody elses experince who has done this.Live and Learn.=============================================== Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com ===============================================
grichter@panavise.com (Gary Richter)
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:
[/application] error? (1997)
WebCat2 Append problem (B14Macacgi) (1997)
WebCatalog [FoundItems] Problem - LONG - (1997)
Ampersand (1997)
Emails sent twice (2000)
WebCat2: Items xx to xx shown, etc. (1997)
Re:How to Display text in empty fields (1997)
Great product and great job ! (1997)
re: keep W* in front applescript? (try Cron) (1998)
HomePage Caution (1997)
Searching for more than one catagory (2000)
Snake Bites (1997)
[WebDNA] Was: wiki Now: Object-oriented programmng (2009)
WebCat B13 Mac CGI -- Frames question (1997)
MORE: Is it possible to pause or wait a process (2000)
Bulletin Board needed (2007)
Running _every_ page through WebCat-error.html (1997)
ShipToState question (1998)
[Webcat 2]Next (1997)
searchable list archive (1997)