[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:
[OT] Who's got a cool link (2002)
Thanks Grant (1997)
PSC recommends what date format yr 2000??? (1997)
Database changes (1998)
Simple search, perhaps (2002)
WC2b15 File Corruption (1997)
Need help with search title (1998)
Bit off subject -- Faxing orders (1997)
Some Questions (1997)
Anybody running directory indexer? (1998)
Size images (2002)
Setting up WebCatalog with Retail Pro data (1996)
Multiple catalog databases and showcart (1997)
[WebDNA] Database Error -oRiGiNaL- (2012)
Setting a range in a search (1998)
Getting total number of items ordered (1997)
maximu values for sendmail! (1997)
[BULK] [WebDNA] triggers.db "next execute" fails to update (2012)
Mac v. NT (1998)
Loss in Form (1998)