I don't know if this is causing all of your problems, but you're missing
pound signs around the JokeID value in the <OPTION> tags. The corrected
version:
<SELECT MULTIPLE NAME="a" SIZE="5">
<CFOUTPUT QUERY="Review">
<OPTION VALUE="#JokeID#">#JokeTitle#</OPTION>
</CFOUTPUT>
</SELECT>
> I have a review form which is supposed to submit the request to a review
> action file to call a single unapproved joke from a joke database for
> approval or deletion. Instead, the following problems occur:
>
> 1. all unapproved jokes appear, except those submitted to the database
> after the form and action file were created.
> 2. jokes submitted to the database after the form and action file were
> created never appear.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists