Thanks, Nick.
This makes sense, as it's probably simpler than trying to maintain two
sets of tables. However, there may be a downside: I have five templates,
plus a search form that look at these links. Four of them list all of
the links in various ways. For each, I would have to add the display
flag. Given that the number of links is likely to climb to nearly 10,000
at some point, do you think there would be a performance penalty?
Thanks so much for the opinion.
--John
Nick Slay wrote:
>
> Hi John,
>
> Personally, I'd have a StatusFlag on my Link Table. Let people submit
> links directly to the Links table and set the StatusFlag to 0,
> (Pending). Create yourself a password protected admin script that let's
> you update the StatusFlag, then once the Links have been approved, set the
> StatusFlag to 1 (Ok). The page on your site that lists the links then
> only needs to query the records that have a StatusFlag = 1.
>
> HTHAL
>
> Nick
>
> At 06:42 15/05/00 -0500, you wrote:
> >I accept submissions for links to be listed on one of my sites.
> >Originally, this was merely by E-mail. Then I set up a form, so I could
> >get as many fields filled in as possible and save some research time.
> >The form generated an E-mail to me and the sender.
> >
> >Now, I'd like to have submitters enter the info directly in my database.
> >Should I let them enter it in my main tables, or should I create
> >separate tables and, once I approve the submissions, copy them to the
> >main tables?
> >
> >If I do it the first way, I'd need to set up a flag to allow display,
> >once I've approved the submission. Any thoughts on the best way to do
> >this?
> >
> >TIA,
> >--John Allred
> >
> >
> >--
> >John Allred / Jackson, Mississippi
> >Webmaster, Mississippi Counties
> >http://www.mscounties.com/
> >------------------------------------------------------------------------------
> >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.
>
> ------------------------------------------------------------------------------
> 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.
--
John Allred / Jackson, Mississippi
Webmaster, Mississippi Counties
http://www.mscounties.com/
------------------------------------------------------------------------------
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.
