You could just cfparam the value with a zero: <cfparam name="form.availabletest" default="0" /> .. . .
INNER JOIN dbo.People AS p ON p.people_id=ps.peopleSummary_peopleID WHERE peopleSummaryPeriod=#getcurrentperiod.peopleSummaryPeriod# AND ps.peopleSummary_peopleID IN (#form.availabletest#) .. . . And, yes, you can use a cfqueryparam, but it doesn't address this issue. Cheers, Kris ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290161 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
