Hello - I am trying to set up the Speck security file to pull from a
database as opposed to a file. However I get a ColdFusion error.

Here is my .users file

[options]
source = c:\Program Files\Apache
Group\Apache2\htdocs\CRAFT\Craft_QA_OcalaNF_v08.24.2007.mdb

[database]
userlist = SELECT user_name AS user, user_real_name AS fullname,
user_password AS password, user_email AS email FROM [User]
userget = SELECT user_real_name AS fullname, user_password AS
password, user_email AS email, user_id AS id FROM [User] WHERE
UPPER(user_name)=UPPER(%)

And the error I get is
The string "st.User.WHERE UPPER(user_name)" is not a valid ColdFusion
variable name.
Valid variable names must start with a letter, and can only contain
letter, numbers, and underscores.

Removing the UPPER functions does not solve ths issue. What am I
missing? Thanks,
Todd Pierce
Research Scientist
University of North Carolina - Asheville