help with duplicate records posted
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 20033
interpreted = N
texte = I have just found something I did not anticipate. I have a database setup for a local town where people in the community can post items for sale or services etc. a kind of builetin board. I have created admin pages that allow one of the township admins to go and approve new postings. No problem. It doesn't get alot of use yet so I had not seen this before. I am creating a unique SKU using a time and date stamp, this is how I search for the items using the admin pages. Anyhow, someone in the town posted their item to the database twice. I guess they did that by reloading their form which gave it an identical SKU as the first time they posted. Now if I go to the admin pages to approve it, It brings up both the records as ifthey were one, 'cause essentially they are the same record althought they exist twice in the database. So if I delete the record it will remove both and if I approve it it will approve both and display both.Has anyone dealt with this? Should I be searching the database to see if the record exists before I append to the database? Any help would be great.Thanks,Charles _______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer Systems
Associated Messages, from the most recent to the oldest:
I have just found something I did not anticipate. I have a database setup for a local town where people in the community can post items for sale or services etc. a kind of builetin board. I have created admin pages that allow one of the township admins to go and approve new postings. No problem. It doesn't get alot of use yet so I had not seen this before. I am creating a unique SKU using a time and date stamp, this is how I search for the items using the admin pages. Anyhow, someone in the town posted their item to the database twice. I guess they did that by reloading their form which gave it an identical SKU as the first time they posted. Now if I go to the admin pages to approve it, It brings up both the records as ifthey were one, 'cause essentially they are the same record althought they exist twice in the database. So if I delete the record it will remove both and if I approve it it will approve both and display both.Has anyone dealt with this? Should I be searching the database to see if the record exists before I append to the database? Any help would be great.Thanks,Charles _______________________________________________________________ Charles Kline ckline@macsultants.com MacSultants Professional Solutions for Computer Systems
charles kline
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:
help with duplicate records posted (1998)
virtual domain service (1997)
Forcing a NEWCART (1997)
WebCatalog Beta Documentation (1997)
WebCat2 beta 11 - new prefs ... (1997)
Further tests with the infamous shipCost (1997)
popups, netscape vs explorer (1997)
Problems getting parameters passed into email. (1997)
Search inside Include (1998)
Math with Time (1997)
supressing math results (1997)
(2000)
Problems passing [SKU] with $Replace in 2.0 (1997)
Quitting WebMerchant ? (1997)
Memory Parameters (1998)
Country & Ship-to address & other fields ? (1997)
[WebDNA] ImageMagick troubleshooting (2009)
TCPconnect & XML (2008)
WebCat for Site Search? (1997)
[append] problem (1997)