Hello Hubert,
you might change your query. The old query just gives you all
jokes, but you only want the 5 jokes, selected in the form
> <CFQUERY
> DATASOURCE="Jokes"
NAME="JokeData">>
> SELECT Joke
> FROM WordJokes
> WHERE JokeTitle=JokeTitle
> </CFQUERY>
You are not using any variable coming from your form... You might
like to look at somthing similar to the following:
SELECT JokeID, JokeTitle, Joke
FROM WordJokes
ORDER BY JokeTitle
WHERE JokeID in
(#form.jokeid1#,
#form.jokeid2#,
#form.jokeid3#,
#form.jokeid4#,
#form.jokeid5#)
you would have to change your form fields accordingly to make this work.
There is nothing wrong with your output...:-))
Good luck
Birgit
Tuesday, April 25, 2000, 2:17:42 AM, you wrote:
> Hi,
> I'm having a problem controlling the output of a form. I have a form which
> allows the user to choose up to 5 joke titles from a joke database, and a
> form action template which should result in the output of just those 5
> jokes, the titles of which were chosen on the form. However, the entire
> database gets output. I've pasted the code of the form and action template
> below. Please advise me.
> The form code:
> <CFQUERY
> DATASOURCE="Jokes"
NAME="Titles">>
> SELECT JokeID, JokeTitle
> FROM WordJokes
> ORDER BY JokeTitle
> </CFQUERY>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <html>
> <head>
> <title>Jokes</title>
> </head>
> <body>
> <h1>JOKES</h1>
> <FORM ACTION="jokesaction.cfm" METHOD="POST">
> Please select joke titles from the contents of the select boxes below. You
> may select up to five titles at a time.<P>
> Joke title #1:
> <SELECT NAME="a">
> <OPTION>
> <CFOUTPUT QUERY="Titles">
> <OPTION VALUE="#JokeID#">#JokeTitle#
> </cfoutput>
> </select><P>
> Joke title #2:
> <SELECT NAME="a">
> <OPTION>
> <CFOUTPUT QUERY="Titles">
> <OPTION VALUE="#JokeID#">#JokeTitle#
> </cfoutput>
> </select><P>
> Joke title #3:
> <SELECT NAME="a">
> <OPTION>
> <CFOUTPUT QUERY="Titles">
> <OPTION VALUE="#JokeID#">#JokeTitle#
> </cfoutput>
> </select><P>
> Joke title #4:
> <SELECT NAME="a">
> <OPTION>
> <CFOUTPUT QUERY="Titles">
> <OPTION VALUE="#JokeID#">#JokeTitle#
> </cfoutput>
> </select><P>
> Joke title #5:
> <SELECT NAME="a">
> <OPTION>
> <CFOUTPUT QUERY="Titles">
> <OPTION VALUE="#JokeID#">#JokeTitle#
> </cfoutput>
> </select><P>
> <INPUT TYPE="submit" VALUE="Submit choice(s)">
> <INPUT TYPE="reset" VALUE="Clear">
> </FORM>
> </body>
> </html>
> ----------------------------------------------------------------------------
> ------------------------------------------
> The form action template:
> <CFQUERY
> DATASOURCE="Jokes"
NAME="JokeData">>
> SELECT Joke
> FROM WordJokes
> WHERE JokeTitle=JokeTitle
> </CFQUERY>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML>
> <HEAD>
> <TITLE>JokeAction</TITLE>
> </HEAD>
> <BODY>
> <CFOUTPUT QUERY="JokeData">#Joke#</CFOUTPUT>
> </BODY>
> </HTML>
> ---
> Hubert Earl
> ICQ#: 16199853
> I develop & maintain web sites internationally. I also build web
> applications using CGI scripts written in Perl. I accept subcontracting
> work.
> **Personal web site: http://www.geocities.com/SiliconValley/Peaks/8702/
> (please remember to view this with a sense of humour!)
> **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.
