Hi some days,, uhh
I seem to be struggling with this today and just can't sort it out, so
simple yet so difficult mmm.
<cfquery name="qry_checkLoginUser" datasource="#application.dsn#"
username="#application.gateway#" password="#application.key#">
SELECT uid
FROM dbo.users
WHERE uid = '#session.checkMilfordLogin#'
</cfquery>
I'm just running this query so I can block out a login user from certain
functions of secured site.
so I 'm saying
<cfif isdefined("form.sample")>
<cfif qry_checkLoginUser.recordCount eq 1 and qry_checkLoginUser.uid
eq 'test'>
<!--- test being a test username and password stored in the users
table purely for restricted access ---->
<cfset error listappend .... and do the rest>
<cfelse>
go ahed and to the business....
Done this before but I have forgot
Thanx very much in advance
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
