The goal: New records in a table of service providers will be added by site
visitors via Web form and action pages but need to be approved before
displaying on the Web site. To accomplish this, the display page will be
populated by a query including a WHERE clause requiring " yes" in a newly
added column. The action page will send an e-mail to notify the site
moderator, who will in turn activate the record by editing a yes or no
radio
button in the app's passworded back end.
The problem: In order to have the existing 13,000+ records continue to
display, it will be necessary to update all existing records with a
default
"yes" in this new column. How is that best done? Do I use a <CFLOOP> tag
or
is the an attribute with <CFUPDATE> that will do the trick?
I've been searching through Ben Forta's ColdFusion MX WACK but haven't
found
anything specifically applicable. If it's in there, a page number would be
helpful.
Thanks for the help.
El
