CF8: Why would I be getting an access error with this query?

[Rick Faircloth]

Hi, all.

 

I'm getting an access denied error because of line 36 (middle line) in this
query:

 

     <cfquery name="get_user" datasource="#dsn#" password="#password#"
username="#username#">

                select * from users where user_email =
'#trim(form.user_email)#' and user_password = '#trim(form.user_password)#'

     </cfquery>

 

For CF 8, does anyone see anything wrong with the syntax?

 

Would case be a problem anywhere?

 

Thanks,

 

Rick




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Enterprise web applications, build robust, secure 
scalable apps today - Try it now ColdFusion Today
ColdFusion 8 beta - Build next generation apps

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288867
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4