Skip to main content
P
phil_ashby
Inspiring
June 17, 2008
Answered

IsUserInRole

  • June 17, 2008
  • 2 replies
  • 465 views
Hi guys and gals,

I've been looking at this for two hours now and can't see anything wrong with this code...but when i run it I get this output - the dump from the query shows the f_role field is "agent". The first cfoutput confirms this, the second cfoutput shows it's assigning the login info correctly, as it shows the GetAuthUser is Barney...but the IsUserInRole("agent") says NO...even though it is???!

Does anyone have any idea please???!

Screen output
//////////////////////////////////////////
query - Top 1 of 1 Rows
F_PASSWORD F_ROLE F_USER RID
1 123456 agent Barney 3

agent Barney NO
//////////////////////////////////////////
This topic has been closed for replies.
Correct answer phil_ashby
Why is it that as soon as you hit the POST button you find the answer!

The code is fine...it was the fieldtype in my database - it was set as a nchar and so had trailing spaces...although they weren't output on screen CF was obviously interpreting them and therefore failing on the comparison. Doh!

2 replies

tclaremont
tclaremont
Inspiring
June 24, 2008
I like to use the "#Trim(string)# function upon committing to the database. It takes care of inadvertant leading and trailing spaces entered by data entry operators and text imports.
P
phil_ashbyAuthorCorrect answer
Inspiring
June 17, 2008
Why is it that as soon as you hit the POST button you find the answer!

The code is fine...it was the fieldtype in my database - it was set as a nchar and so had trailing spaces...although they weren't output on screen CF was obviously interpreting them and therefore failing on the comparison. Doh!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices