Duplicate Entries in Database


Old 02-07-2011, 01:08 PM
FitDay Member
Thread Starter
Join Date: Feb 2011
Posts: 2
Exclamation Duplicate Entries in Database

Within FitDay.com, if you search on "fennel bulb raw", you will find multiple entries for various forms of the food; however, up top, you will notice that there are two entries for "fennel bulb raw" specifically, both differing ONLY in a comma placement:

Fennel bulb, raw (1 oz = 4.5 calories)

Fennel, bulb, raw (1 oz = 8.8 calories)

It wouldn't be so bad and I wouldn't care so long as the calories matched up in the serving size, but they don't. That's problematic and makes me question the validity of other entries or more common things, like green beans or lettuce, which are both so varied.
wwcitizen is offline  
Reply With Quote
Old 02-07-2011, 01:38 PM
FitDay Premium Member
mecompco's Avatar
Join Date: May 2010
Posts: 2,621

Thank you for pointing that out. I'm sure in a database with thousands of records there are bound to be some inconsistancies. Even food nutritional lables have been found to be, in some cases, grossly inaccurate.

Unless there is a big difference, I don't lose much (any) sleep over it. I do, agree that it would be a good idea to clean up the database as much as possible and I will create a thread for the admins.

mecompco is offline  
Reply With Quote

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Thread Tools
Search this Thread
Display Modes

Contact Us Archive Advertising Cookie Policy Privacy Statement Terms of Service