Try this:
<cffunction name="getUsers" returntype="query" access="remote">
<cfargument name="userID" type="numeric" required="false" default="0"
/>
<cfset var queryUsers = "" />
<cfquery name="queryUsers" datasource="#application.ds#">
SELECT userID, userType, userAccessLevel, userName, firstName,
lastName
FROM Users
WHERE active = '1' OR (#arguments.userID# > 0 AND userID =
#arguments.userID#)
</cfquery>
<cfreturn queryUsers>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 &
Flex 2
Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283636
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
