Alter session in cfquery

Question

Hi everybody,

Should it be a possibility to use the alter session in a query ?
I would like to make something like this:
<cfquery>
ALTER SESSION SET NLS_COMP = LINGUISTIC;
ALTER SESSION SET NLS_SORT = GENERIC_BASELETTER;
select geo_indication from eccgis where country_fk = 'PT' and geo_indication like 'O%';
</cfquery>
As this is good in sqlDeveloper (oracle, without cfquery...), the query gives an error in Cf (semi-columns?).
Does anyone get an idee ?

Thanks in advance,
Michel

mmcurtis · Accepted Answer

Thank you very much.This is now resolved:The sort order has also implications on the SEARCH mechanism  Looking for Oxxxxxx you do not find Óbidosand now:Search do not look at upcase and accent anymore.Michel

Newsgroup_User · Answer

mmcurtis wrote:> > ALTER SESSION SET NLS_COMP = LINGUISTIC;> ALTER SESSION SET NLS_SORT = GENERIC_BASELETTER;> select geo_indication from eccgis where country_fk ='PT' and geo_indication > like 'O%';> > As this is good in sqlDeveloper (oracle, withoutcfquery...), the query gives > an error in Cf (semi-columns?).Try: ALTER SESSION SET NLS_COMP = LINGUISTIC ALTER SESSION SET NLS_SORT = GENERIC_BASELETTER select geo_indication from eccgis where country_fk = 'PT'and geo_indication like 'O%' Jochem-- Jochem van DietenAdobe Community Expert for ColdFusion

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded