Mark, I'll like to suggest you to use DataMgr. DataMgr is a great time saver tool and could be the answer to your needs.
http://datamgr.riaforge.org/ Cheers Marco Antonio C. Santos On Jan 9, 2008 2:56 PM, Mark Fuqua <[EMAIL PROTECTED]> wrote: > I think I need to be using 'IN' within my WHERE clause but I can't seem to > get it to work. I have a column with a comma delimited list. This is the > latest attempt and it craps out too. > > > > SELECT.. > > > > ...WHERE JobFileJob = #session.jobId# AND '#session.UserRole#' IN > (JobFileAccessLevel) > > > > JobFileAccessLevel is a field in the database table that contains a comma > delimited list of access levels. > > > > Maybe I'm barking up the wrong tree entirely. What I'm trying to do is. > > > > ..WHERE jobFileJob=#session.jobId# and jobFileAccessLevel CONTAINS > '#session.UserRole#' > > > > But I don't think 'contains' exists. > > > > Thanks, > > > > Mark > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
