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:
email bounce check (2002)
New Mac Public Beta Available (1997)
PCS Customer submissions ? (1997)
whole word search bringing irrelevant results.. (2000)
WebCat2 - Getting to the browser's username/password data (1997)
Using Applescript to process WebCatalog functions (1998)
What is the default seed for the encrypt context? (2000)
Variable Math (1998)
Will webdna execute before a [redirect]? (1999)
For Newbies (2002)
Share cost of training videos! (1998)
Is a cart really unique? (2002)
For those of you not on the WebCatalog Beta... (1997)
test (2000)
writing orders to a db (1997)
Running _every_ page through WebCat ? (1997)
Waitfor file (2000)
Summary search -- speed (1997)
Roundup function? (1997)
Feature: TCPconnect via SSL (1999)