when you select multiple checkboxes and pass those through a form, they will be in a comma delimited list... So you could easily do something like
select * from foo, goo where foo.salesid = goo.salesid and goo.salesid in (<cfqueryparam cfsqltype="cf_sql_numeric" value="#form.salesids#" list="yes" />) On 1/24/07, John Eubanks <[EMAIL PROTECTED]> wrote: > I have two tables: One with sales people, and another has information > relevant to those sales people. I am joining them based off of a sales id. > I also have a form that displays with checkboxes for updating these people. > My question is this: How do I pass multiple checkbox parameters through so > that tons of rows don't show up, based on this id? For example: If I check > 3 sales people, I only want three rows to show up on the next page, which I > can update, instead of 100 rows 20 rows per person. Below is the select > statement: > > <cfquery name="SalesInfo" datasource="SomeSource"> > SELECT RepFinder_Basic.*,RepFinder_Ext.* > FROM RepFinder_Basic,RepFinder_Ext > WHERE RepFinder_Basic.RepId IN (#Form.RepId#) > AND RepFinder_Basic.RepId = RepFinder_Ext.RepId > </cfquery> > > Any suggestions? I am pretty much begging for help on this one right now. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2455 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
