Thank you,
Below is the entire original code
<InvalidTag LANGUAGE="JavaScript">
function mapwin(url) {
window.open(url,"win",'toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=0,width=450,height=400');
}
function adwin(url) {
window.open(url,"win",'toolbar=0,location=0,directories=0,status=0,menubar=0,scrollbars=1,resizable=0,width=450,height=400');
}
</SCRIPT>
<CFQUERY NAME="catlist" DATASOURCE="endless" username="endlessm"
password="endless97">
select *
from dircategory
order by cat_order
</CFQUERY>
<CFIF IsDefined("url.subcat_id") IS True>
<CFSET mode = "subcategory">
</CFIF>
<CFSET mode = "directory">
<CFIF IsDefined("url.cat_id") IS True>
<CFIF #url.cat_id# IS "103">
<CFELSE>
<CFSET mode = "category">
</CFIF>
</CFIF>
<CFSET mode = "subcategory">
<CFIF IsDefined("url2.cat_id") IS True>
<CFIF #url2.cat_id# IS "100">
<CFSET mode = "subcategory">
<CFELSE>
<CFSET mode = "category">
</CFIF>
</CFIF>
<CFIF IsDefined("url.directory_id") IS True>
<CFSET mode = "ad">
</CFIF>
<CFIF IsDefined("criteria") IS True>
<CFSET mode = "search">
</CFIF>
<CFSET ct = 0>
<CFIF mode IS "search">
<CFSET criteria = LCASE(criteria)>
<CFQUERY NAME="get_dir" DATASOURCE="endless" username="endlessm"
password="endless97">
SELECT directory.*, mapcode.name as mapname
FROM directory, mapcode
WHERE 0 = 0
AND directory.active_flg = 'Y'
AND directory.map_code = mapcode.mapcode
<!--- Check for textbox search --->
<cfif trim(criteria) GT 0>
AND
(
<CFLOOP LIST="#criteria#" INDEX="ThisWord" DELIMITERS= " ">
<CFIF ct GT 0>
OR
</CFIF>
LOWER(directory.company_name) LIKE '%#ThisWord#%'
OR LOWER(directory.address) LIKE '%#ThisWord#%'
OR LOWER(directory.location) LIKE '%#ThisWord#%'
OR LOWER(directory.short_desc) LIKE '%#ThisWord#%'
<CFSET ct = ct + 1>
</CFLOOP>
)
</cfif>
</CFQUERY>
</CFIF>
<CFIF mode IS "category">
<cfif cat_id IS "105">
<CFQUERY NAME="find_events" DATASOURCE="endless" username="endlessm"
password="endless97">
select *
from directory
where subcat_id = '119'
AND directory.active_flg = 'Y'
AND county_id <> 105
order by dir_start_date
</CFQUERY>
</cfif>
<CFIF mode IS "dining">
<cfif cat_id IS "103">
<CFQUERY NAME="find_dining" DATASOURCE="endless" username="endlessm"
password="endless97">
select *
from directory
where subcat_id = '120, 121, 122, 123, 160' AND
directory.active_flg = 'Y'
order by Company_Name
</CFQUERY></cfif></cfif>
<CFIF mode IS "seedo">
<cfif cat_id IS "100">
<CFQUERY NAME="find_seedo" DATASOURCE="endless" username="endlessm"
password="endless97">
select *
from directory
where subcat_id = '100, 101, 102, 103, 104, 105, 106, 107, 108'
AND directory.active_flg = 'Y'
order by Company_Name
</CFQUERY></cfif></cfif>
<cfset category_flg = '#cat_id#'>
<CFQUERY NAME="subcat_list" DATASOURCE="endless" username="endlessm"
password="endless97">
select *
from dirsubcategory
where cat_id = '#cat_id#' order by subcat_name
</CFQUERY></cfif>
<CFIF mode IS "ad">
<CFQUERY NAME="get_ad" DATASOURCE="endless" username="endlessm"
password="endless97">
select * from directory Where directory_id = '#directory_id#'
</CFQUERY></cfif>
<CFIF mode IS "subcategory">
<CFIF IsDefined("url.cat_id") IS True>
<CFQUERY NAME="get_subcat" DATASOURCE="endless"
username="endlessm" password="endless97">
select '' SUBCAT_NAME
from dirsubcategory
where subcat_id = '120'
</CFQUERY></CFIF></CFIF>
<cfset category_flg = '#url.cat_id#'>
<CFIF mode IS "subcategory">
<CFIF IsDefined("url2.cat_id") IS True>
<CFQUERY NAME="get_subcat" DATASOURCE="endless"
username="endlessm" password="endless97">
select '' SUBCAT_NAME
from dirsubcategory
where subcat_id = '100'
</CFQUERY></CFIF></CFIF>
<cfset category_flg = '#url2.cat_id#'>
<CFQUERY NAME="subcat_list" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from dirsubcategory
where cat_id = '#url.cat_id#' order by subcat_name
</CFQUERY>
<CFQUERY NAME="get_dir" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from directory
where subcat_id IN (select subcat_id from dirsubcategory
where cat_id = '#url.cat_id#') AND
directory.active_flg = 'Y' AND county_id <> 105
order by company_name
</cfquery>
<CFQUERY NAME="get_nearby" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from directory
where subcat_id IN (select subcat_id from dirsubcategory
where cat_id = '#url.cat_id#') AND
directory.active_flg = 'Y' AND county_id = 105
order by company_name
</cfquery>
<CFELSE>
<CFQUERY NAME="get_cat" DATASOURCE="endless"
username="endlessm" password="endless97">
select * from dirsubcategory where subcat_id =
'#subcat_id#'
</CFQUERY>
<CFQUERY NAME="get_subcat" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from dirsubcategory
where subcat_id = '#subcat_id#'
</CFQUERY>
<cfset category_flg = '#get_cat.cat_id#'>
<CFQUERY NAME="subcat_list" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from dirsubcategory
where cat_id = '#get_cat.cat_id#' order by subcat_name
</CFQUERY>
<CFQUERY NAME="get_dir" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from directory
where subcat_id = '#subcat_id#' AND directory.active_flg
= 'Y' AND county_id <> 105
order by company_name
</cfquery>
<CFQUERY NAME="get_nearby" DATASOURCE="endless"
username="endlessm" password="endless97">
select *
from directory
where subcat_id = '#subcat_id#' AND directory.active_flg
= 'Y' AND county_id = 105
order by company_name
</cfquery>
<HEAD><TITLE>Endless Mountains Directory</TITLE></HEAD>
<BODY bgcolor="#FFFF99" link="#8F2730" alink="#8F2730"
vlink="#8F2730" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<cfinclude template="head.include">
<table width="780" cellspacing="0" cellpadding="0" border="0">
<tr><td width="145" valign="top">
<cfinclude template="navbar500_left.include">
<br>
</td> <td width="35" > </td>
<td width="401" valign="top"><TABLE CELLSPACING="0"
CELLPADDING="0" BORDER="0" WIDTH="401">
<cfif mode IS "directory"><cfinclude template="directory_body.include"></cfif>
<cfif mode IS "category"><cfinclude template="directory2_detail.cfm"></cfif>
<cfif mode IS "subcategory"><cfinclude template="directory2_detail.cfm"></cfif>
<cfif mode IS "ad"><cfinclude template="ad_detail.cfm"></cfif>
<cfif mode IS "search"><cfinclude
template="directory_search.cfm"></cfif></table></td>
<td width="35" > </td> <td width="164" valign="top"><br>
<cfinclude
template="navright.include">
</td></tr></table></BODY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1447
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
