Eron Cohen wrote:
>
> Earl,
>
> Rather than have two tables, why not have a checkbox field in the database
> table labled "Approved".
> When you go to output your jokes, just make sure you have something like
> WHERE Approved=1, that way people viewing the site will only see your
> approved jokes. This is easier to do and more efficient than having two
> seperate tables.
>
I'm kind of curious about this too. I've set up a link submission form
using one table with the "Approve" column, but I'm also allowing
modifications to existing records. If I cause the "Approve" flag to be
reset when someone changes a link, I take it out of service. I can't
allow them to modify my live table, so I'd kind of like to use this
method that Earl is asking about.
Thanks,
John Allred
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
