|JoelG||-- 09-08-2010 @ 7:53 AM|
Using dreamweaver, I am trying to pass the value from multiple check boxes to a page where I can query my db and have it return and display the results. The name of the check box on the form page is cb_cont. All of the values from the check box are looking for date from same column from within the same table.
If i just check one record in the form and submit it, then i get the result i want, if I select multiple records i return no error but also no result.
I know that the multiple values are being passed because if i display the results of contID as follows:
It shows me the multiple values on the query page ie:1, 11, 13, 26
My code is as follows:
<cfset contID = #form.cb_cont#>
<cfparam name="contID" default="11,9" type="Numeric">
<cfquery name="rs_recipients" datasource="sms">
WHERE ID IN (<cfqueryparam value="#contID#" cfsqltype="cf_sql_numeric">)
<table width="80%" border="0" cellspacing="0" cellpadding="0">
Any help is appreciated. I only have 3 hairs left, then i have to quit.
|EasyCFM.COM ColdFusion Forums :||http://archive.easycfm.com/forums|