49 : </cffunction>
50 :
51 : <cfquery name="getcumtaxonomy" datasource="#application.ds#">
52 : select ecomm_taxonomy_id * 10000 as master_taxonomy_id, dept, case when typ = '' then 'EMPTY' else typ end as typ, case when subtyp = '' then 'EMPTY' else subtyp end as subtyp_1,
53 : case when web_url = '' or web_url like '% %' then 'INVALID_URL' else web_url end as web_url
|