Hubert:
I've found just setting an extra Yes/No column (called "Pending" in this
example)
in your main table. When a joke is submitted, it automatically sets "Pending" to
Yes.
Then, build a page that shows all of the items with Pending checked "Yes", and
build it so all chosen id's get changed to "No" for Pending.
Otherwise, you could build a page to do it manually, or hourly/daily/weekly
with CFSCHEDULE.
Joel
"Hubert Earl" <[EMAIL PROTECTED]> wrote in message
001301bfca63$6da3fd20$2e0020c4@a6h8m9">news:001301bfca63$6da3fd20$2e0020c4@a6h8m9...
: 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.
