UID may be reserved but you can try: [UID] = #URL.dupid# -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 15, 2006 11:21 AM To: CF-Talk Subject: CFQuery simple but not working, strange Hey All, Argh! I've stared at this error for 10 minutes and i can't see what' wrong with my query. This query is checking to see if a username already exists before adding a new username to the app_users table. UID is the primary key in the app_users table and URL.dupid is the triggered redirect when the recordcount is GT 0 when checking for matches against existing usernames. This URL.dupid is always an number and in this instance the value is coming across ok. See below. The web site you are accessing has experienced an unexpected error. Please contact the website administrator. The following information is meant for the website developer for debugging purposes. Error Occurred While Processing Request Error Executing Database Query. Syntax error (missing operator) in query expression 'UID = 271'. The error occurred in C:\CFusionMX7\wwwroot\admin\user_database_admin.cfm: line 502 Called from C:\CFusionMX7\wwwroot\admin\user_database_admin.cfm: line 1 Called from C:\CFusionMX7\wwwroot\admin\user_database_admin.cfm: line 502 Called from C:\CFusionMX7\wwwroot\admin\user_database_admin.cfm: line 1 500 : select * 501 : from app_users 502 : where UID = #URL.dupid# 503 : </CFQUERY> 504 : <!--- GO GET THE NAME OF THE DUPLICATE ID TO OUTPUT HERE ---> ------------------------------------------------------------------------ -------- SQL select * from app_users where UID = <cfoutput>271</cfoutput> DATASOURCE wfi_access VENDORERRORCODE 3092 SQLSTATE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243617 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54