<cfquery datasource="askseaton" name="get_offices1" result="log">
select s.office_name,u.userid,s.lead_mgr,iIf(u.userid = s.lead_mgr,
u.first , s.lead_note ) as leadMgr
from sourcebook_1 s ,user_info u
where s.active = 1
and office_id not in(36,37,38,73)
order by s.office_number
</cfquery>
is this is correct comparision,please tell me
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324714
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
