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

Reply via email to