That worked. Thanks.
----- Original Message -----
From: "Matthew W Jones" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 8:54 AM
Subject: RE: CFIF Issue
> try putting a trim around qGetUser.User_Type in the cfif, it is likely
> bringing a space(s) in your result
>
>
> -----Original Message-----
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 14, 2001 8:43 AM
> To: CF-Talk
> Subject: CFIF Issue
>
>
> OK. I have the following code:
>
> <!--- Get the usertype from the database so that we can fire off the
> correct set of queries --->
> <cfquery datasource="#Application.DSN#" name="qGetUser">
> Select User_Type
> From Users
> Where Auth_User = '#CGI.Auth_User#'
> </cfquery>
>
> <!--- Output the variable so that I can be sure what I am seeing.
> Comment this out on the Production Server --->
> <cfoutput>#qGetUser.User_Type#</cfoutput>
>
> <!--- If the User_Type is User, then fire off the query that selects
> ONLY the lab tests that the user is allowed to edit--->
>
> <CFIF qGetUser.User_Type IS "User">
> <cfquery datasource="#Application.DSN#" name="qGetTests">
> SELECT bcon.AutoNumber, bcon.CERNER_Mnemonic, bcon.CERNER_Code
> FROM (Sections INNER JOIN UserSection ON Sections.Section_ID =
> UserSection.Section_ID) INNER JOIN bcon ON Sections.Section_ID =
> bcon.Section_ID
> WHERE (((UserSection.Auth_User)='#CGI.Auth_User#'))
> AND Cerner_Mnemonic <> ''
> Order By Cerner_Mnemonic
> </cfquery>
>
> <!--- If the User_Type is Admin, fire off the query to get all of the
> labs --->
>
> <cfelseif qGetUser.User_Type IS "Admin">
> <cfquery datasource="#Application.DSN#" name="qGetTests">
> SELECT bcon.AutoNumber, bcon.CERNER_Mnemonic, bcon.CERNER_Code
> FROM BCON
> WHERE Cerner_Mnemonic <> ''
> Order By Cerner_Mnemonic
> </cfquery>
> </cfif>
>
> When I run this, the outputted User Type is User (I see it on the screen
> from the <CFOUTPUT> I have above). So I know that the User Type is User.
> However, the CFIF statements are not picking this up. The weird thing is
> that I have a similar application in production that uses the same
> logic, and it works fine. I am baffled!
>
> Thanks,
> Bruce
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
