IsUserInRole

[phil_ashby]

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
//////////////////////////////////////////

[phil_ashby · Accepted solution]

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!

[tclaremont]

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.