I'm querying a table to return * (fname, lname, ID, email, Type_ID_fk) after
passing in form variables.
This is working. I can dump the query and see it all. (Jeff, Small, 1,
[EMAIL PROTECTED], 1)
Type_ID_fk is a foreign key to a table. I only really have two types of
users, but the types are stored in another table with information about the
type, etc. I store the ID to the type in the login table.
Now...here's where it gets interesting.
<cfloginuser name="#Login.FirstName# #Login.LastName#"
password="#OwnerEmail#" roles="#Login.OwnerTypeID_fk#">
throws the error. *however*
<cfloginuser name="#Login.FirstName# #Login.LastName#"
password="#OwnerEmail#" roles="1">
does NOT throw an error. Even though the *VALUE* of #Login.OwnerTypeID_fk#
IS '1'.
Why does it throw an error if I dynamically put a '1' in there, and not
throw one if I explicitly put in '1'?
----- Original Message -----
From: "Pete Freitag" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, September 17, 2004 1:17 PM
Subject: Re: Completely baffled...
> Sounds like your looking at the wrong file. Make sure that the error
> isn't thrown from one of your included templates, custom tags,
> Application.cfm, etc.
>
> Also if your using client variables could be this one:
> http://www.petefreitag.com/item/163.cfm
>
> ______________________________________
> Pete Freitag
> http://www.cfdev.com/
> Author of the CFMX Developers Cookbook
> http://www.petefreitag.com/bookshelf/
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
