Hi Hubert,
>I'm having a problem controlling the output of a form. .....
>
>form, in part:
>
>Joke title #5:
><SELECT NAME="a">
><OPTION>
> <CFOUTPUT QUERY="Titles">
><OPTION VALUE="#JokeID#">#JokeTitle#
></cfoutput>
></select><P>
>
>The form action template:
>
><CFQUERY
>DATASOURCE="Jokes"
>NAME="JokeData">
>SELECT Joke
>FROM WordJokes
>WHERE JokeTitle=JokeTitle
></CFQUERY>
The query should be:
<CFQUERY DATASOURCE="Jokes" NAME="JokeData">
SELECT Joke
FROM WordJokes
WHERE JokeID IN (#form.a#)
</CFQUERY>
as you ended up with a list of JokeIDs in a form var called 'a'
--
Yours,
Kym
------------------------------------------------------------------------------
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.
