Can someone help in figuring out this error!
This is my query:
<cfquery name="q" datasource="#APPLICATION.DB#" USERNAME="#APPLICATION.UN#" PASSWORD="#APPLICATION.PW#">
select groupidfk AS group
from #variables.tableprefix#permissions
where rightidfk = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.right#" maxlength="35">
and resourceidfk = <cfqueryparam cfsqltype="cf_sql_varchar" value="#arguments.resource#" maxlength="35">
</cfquery>
This is the error I get: Incorrect syntax near the keyword group
If I take the alias out and not rename it group then the query works just fine. But I need that in there for a bunch of other code to work properly.
Ideas?
Anthony
