Ignore:
Timestamp:
07/29/10 00:39:54 (19 months ago)
Author:
eddieballisty
Message:

Oracle case insensitive ordering

File:
1 edited

Legend:

Unmodified
Added
Removed

  • branches/5.2/www/requirements/mura/content/feed/feedGateway.cfc

    r2369 r2586  
    539539        <cfswitch expression="#arguments.feedBean.getSortBy()#"> 
    540540        <cfcase value="menutitle,title,lastupdate,releasedate,orderno,displayStart,created,credits,type,subtype"> 
    541         tcontent.#arguments.feedBean.getSortBy()# #arguments.feedBean.getSortDirection()# 
     541                <cfif dbType neq "oracle"> 
     542                        tcontent.#arguments.feedBean.getSortBy()# #arguments.feedBean.getSortDirection()# 
     543                <cfelse> 
     544                        lower(tcontent.#arguments.feedBean.getSortBy()#) #arguments.feedBean.getSortDirection()# 
     545                </cfif> 
    542546        </cfcase> 
    543547        <cfcase value="rating"> 
Note: See TracChangeset for help on using the changeset viewer.