Hi,

Mark



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

The value of the source setting should be either "file" or "database"
(without the quotes). This isn't the cause of the error though - the
code just checks if the value is file and if not, assumes it's database.
You should change it to just database all the same.


> [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.

When speck reads the configuration file, it thinks that the text [User]
indicates the beginning of a section of the configuration file. Take the
square brackets out of the table name in your queries, i.e. replace
"FROM [User]" with "FROM User". If "user" turns out to be a keyword in
access, you should be able to use double quotes instead of square
brackets - though that's me assuming that access allows quoted identifiers.


> Removing the UPPER functions does not solve ths issue.

Nope, but if you leave it in it will cause another ;-) Access doesn't
have an UPPER() function, it has uCase(). You don't need it either way
though, because string comparisons are case-insensitive in Access.
Change the userget query to:
userget = SELECT user_real_name AS fullname, user_password AS password,
user_email AS email, user_id AS id FROM User WHERE user_name=%


Regards

Mark