first thing i would do is check for whitespace, some databases pad out
certain type of fields,trim the value retreived from the db and see if it
makes a difference.
Kola Oyedeji
Web developer
Macromedia Certified Advanced ColdFusion 5 Developer
http://www.Alexandermark.com
(+44)020-8429-7300
> -----Original Message-----
> From: Bruce Sorge [mailto:[EMAIL PROTECTED]]
> Sent: 14 September 2001 14:43
> 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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
