Use one table and just set a flag (yes/no or true/false or 0/1 depending on
your database) field. When people upload a joke the flag is set to No (or 0
or False) by default.
After you review the joke, you set the flag to Yes (or 1 or True).
Then in your CF code ONLY show jokes that have the flag set to Yes.
<cfquery .....>
SELECT *
FROM Jokes
WHERE Flag = Yes (or whatever your flag equals)
</cfquery>
That should work and no coping/duplicate tables and data. If you like you
can then purge all No records later.
Gary McNeel, Jr.
Project Manager - DAC-Net, Research & Graduate Studies
Rice University - Houston
[Lovett Hall] 713-348-6266 (Primary)
[DAC] 713-348-5184
[M] 713-962-0885
[H] 713-723-9240
"Open the pod bay doors please Hal."
Dave Bowman - 2001 (talk about feeling alone)
"I know you and Frank were planning to disconnect me and I am afraid that is
something I cannot allow to happen."
HAL - 2001 (response to Dave)
> -----Original Message-----
> From: Hubert Earl [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 30, 2000 1:18 PM
> To: [EMAIL PROTECTED]
> Subject: Automatically transferring data from one table to another
>
>
> Hi,
>
> Is there a way I may transfer data from one table to another
> automatically?
> I have a table containing jokes which can be accessed thru a browser. I'm
> building another to which anyone can upload jokes. After
> reviewing them, I
> want to be able to transfer any I wish to keep automatically to my first
> table, without having to copy and paste them (for example). I'd
> appreciate
> any suggestions.
>
> Sincerely,
> ---
> Hubert Earl
> ICQ#: 16199853
>
> I develop & maintain web sites internationally. I also build web
> applications using ColdFusion, JavaScript and CGI scripts written in Perl.
> I accept subcontracting work.
>
> **Personal web site: http://www.geocities.com/hfme/
> (please remember to view this with a sense of humor!)
>
> **Business web page: http://home.talkcity.com/MigrationPath/hearl/
>
> ------------------------------------------------------------------
> ------------
> 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.
