you can also use the "IN" keyword in the where clause.. IE
WHERE site_id IN (100,101,103) On Tue, Jan 18, 2011 at 10:33 PM, Frank Liu <[email protected]> wrote: > > Hello, > > I have a table like this: > > ID SiteID Job Number_request approval > 1 100 math teacher 4 > 2 100 science teacher 3 > 3 100 english teacher 2 > 4 101 summer helper 3 > 5 101 office assistant 1 > 6 103 office assistant 2 > > Then I created a form with those info and a checkbox with each siteID. > (The form) > > ID SiteID Job Number_request approval > 1 100 math teacher 4 checkbox > 2 100 science teacher 3 checkbox > 3 100 english teacher 2 checkbox > 4 101 summer helper 3 checkbox > 5 101 office assistant 1 checkbox > 6 103 office assistant 2 checkbox > > If any checkboxes are checked, a "Yes" value will be assigned to approval > field in the table. My problem is, for sites with more than one checkboxes > (like siteID 100, 101), how can I know which one I ckecked, which one not > checked based the on the unique ID? or how can I do it? > Thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341021 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
