It's an int. regular ol' foreign key, nothing fancy.
> Honestly, I've never used anything but strings for the ROLES attribute,
> although I can see why you might want to do that.
Oh, I know! I know! I mean, I figured it would just be good practice to pull
the roles into another table, because they want to keep additional
information, not just the string with the role type, so naturally I just
pulled it out into another table. Not to mention, wouldn't you want to do
this to "roll up" your user roles? Couldn't I say, use that rule to say
something like:
<cfif IsUserInRole() GT 1>
Right?
Oh, and to add to this. I went ahead and re-wrote the query so it's a join
and actually returns the string of the type. So instead of
ToString(Login.OwnerType_fk) I just actually pass in the string with the
guy's role.
Oh well. I got it to work, and found something that stumped people in the
process. All in all a good day, I'd say.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
