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

Reply via email to