You wrote:
---
The form action template:
<CFQUERY
DATASOURCE="Jokes"
NAME="JokeData">
SELECT Joke
FROM WordJokes
WHERE JokeTitle=JokeTitle
</CFQUERY>
---
Try:
<cfquery name="JokeData" datasource="Jokes">
SELECT Joke
FROM WordJokes
WHERE JokeID IN (#Form.a#)
</cfquery>
And I'd rename the Selects from "a" to something more meaningful like
"JokeID"
___________________________________________
Sean Brown <[EMAIL PROTECTED]>
http://www.westcar.com/
"Either way you get your dog back"
-Anonymous
___________________________________________
-----Original Message-----
From: Hubert Earl [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 25, 2000 2:18 AM
To: [EMAIL PROTECTED]
Subject: Problem controlling output
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.
------------------------------------------------------------------------------
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.
