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.
HTH,
Eron
-----Original Message-----
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 30, 2000 2: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.
