Hi,
I just updated to 6.0.16 (or so claims the minor version file). In
webskin/fourq/displayLibrary, this changeset:
https://farcry.jira.com/source/changelog/FC?cs=11748 introducted:
SELECT objectid AS [key]
This throws an error on MySQL 5.0.x, since [] are not how you delimit
reserved keywords, as far as I understand. Similar code has been used before
in types.cfc: getLibrarySearchResults (is this even used?)
<cfif lcase(application.dbtype) EQ "mssql"> <!--- Dodgy MS SQL only
code --->
<cfquery datasource="#application.dsn#" name="qSearchResults">
SELECT objectID as [key] , label FROM
#application.dbowner#[#variables.typename#]
WHERE label like <cfqueryparam cfsqltype="cf_sql_varchar"
value="%#arguments.criteria#%">
Order by label
</cfquery>
<cfelse> <!--- Dirty hack to get this query working for MySQL and
possibly Postgres --->
<cfquery datasource="#application.dsn#" name="qSearchResults">
SELECT objectID as "key" , label FROM
#application.dbowner##variables.typename#
WHERE lower(label) like <cfqueryparam
cfsqltype="cf_sql_varchar" value="%#arguments.criteria#%">
Order by label
</cfquery>
</cfif>
Should I submit as bug?
Tomek
--
You received this message cos you are subscribed to "farcry-dev" Google group.
To post, email: [email protected]
To unsubscribe, email: [email protected]
For more options: http://groups.google.com/group/farcry-dev
--------------------------------
Follow us on Twitter: http://twitter.com/farcry
