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:2454 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
