Need help figuring out why Access throws up on this query. I don't see anything wrong with it.
select a.id, a.title, a.body, a.projectidfk, a.useridfk, a.posted, p.name as project, u.name as author from lh_announcements a left join lh_projects p on a.projectidfk = p.id left join lh_users u on a.useridfk = u.id where 1=1 <cfif structKeyExists(arguments, "projectidfk") and len(arguments.projectidfk)> and (a.projectidfk in (<cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.projectidfk#" list="true">) or a.projectidfk = '' ) </cfif> order by a.posted desc [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'a.projectidfk = p.id left join lh_users u on a.useridfk = u.id'. Thanks, Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
