[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 adatabase that doesn't use a [cart] to create a unique record ID.What happened is that somebody used the back button and then went forewardusing the html and created to identical records based on a name. If theywould have started at my add page entry point I have a checker there toprevent this....but oh well it happened. When we tried to delete theserecords both with the same name it hung webcat. So what I want to do is goback this weekend and import the database into FilemakerPro and add a fieldthat in the future will be a [cart] number so this problem never occursagain. 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 filleach recored like 1,2,3,4,5,6 and so forth for these 225 some odd recordsand 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 elsesexperince 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 adatabase that doesn't use a
[cart] to create a unique record ID.What happened is that somebody used the back button and then went forewardusing the html and created to identical records based on a name. If theywould have started at my add page entry point I have a checker there toprevent this....but oh well it happened. When we tried to delete theserecords both with the same name it hung webcat. So what I want to do is goback this weekend and import the database into FilemakerPro and add a fieldthat in the future will be a
[cart] number so this problem never occursagain. 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 filleach recored like 1,2,3,4,5,6 and so forth for these 225 some odd recordsand 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 elsesexperince 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:
using showpage and showcart commands (1996)
Initiating NewCart (1997)
Protecting webdelivery (1997)
WebDNA Server Spec (2004)
duplicate cart numbers (2002)
Further on formula.db failure to calculate shipCost (1997)
WebCat2b15MacPlugin - [protect] (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
determining plug-ins? (1998)
Sort Order on a page search (1997)
Sorting a summary (2000)
[WebDNA] Searching for multiple value [search .... 1,2,3] (2015)
Running _every_ page through WebCat-error.html (1997)
Emailer on NT! (1998)
read and write you own cookies with webcat (1997)
Can a Get or Post throw off a Ping? (1998)
A little syntax help (1997)
Problems with [Applescript] (1997)
Database Upload (2000)
Search/sort in URL Was: GuestBook example (1997)