The History of this started from
Thank you for your help. I modified the query and it works fine but the result page does not seem to output the right results.
I want the users to search with ItemNo and any other data and have the result page show the search criteria. e.g if I search with ItemNo and Date, I want the reult page to show the itemno, date and any other data I want.
I have the following query for the result page:
<cfparam name="FORM.AgendaItemNo" default="">
<cfquery name="spResults" datasource="SpeakerCard">
WHERE AgendaItemNo IN ('#FORM.AgendaItemNo#', '#FORM.Comm_CouncilDate#',
ORDER BY SpeakerCard.AgendaItemNo, Comm_CouncilDate, Comm_CouncilName</cfquery>
Then I have my output table.
How do I fix this