<%
dim rs_awe,sql_awe,awe_link,awe_link_en,temp_awe
temp_awe= "awe"
set rs_awe = Server.CreateObject("adodb.recordset")'connection the db search awe's link
sql_awe = "select * from t_awe where n_falg='"&temp_awe&"'"
rs_awe.Open sql_awe,conn,1,1
If not (rs_awe.eof and rs_awe.bof) then
awe_link = "/ydm/"&rs_awe("n_path")
else
awe_link = "#"
End If
rs_awe.close
'sql_awe = "select * from t_awe where n_falg=awe_en" 'connection the db search awe_en's link
' rs_awe.Open sql_awe,conn,1,1
' If not (rs_awe.eof and rs_awe.bof) then
' awe_link_en = "/ydm/"&rs_awe("n_path")
' else
' awe_link_en = "#"
' End If
' rs_awe.close
%>
<%
dim rs_price,sql_price,price_link,prick_link_en,temp_price
temp_price = "price"
set rs_price = Server.CreateObject("adodb.recordset")
sql_price = "select * from t_awe where n_falg='"&temp_price&"'" 'connection the db search price's link
rs_price.Open sql_price,conn,1,1
If not (rs_price.eof and rs_price.bof) then
price_link = "/ydm/"&rs_price("n_path")
else
price_link = "#"
End If
rs_price.close
'sql_price = "select * from t_awe where n_falg=price_en"
' rs_price.Open sql_price,conn,1,1
' If not (rs_price.eof and rs_price.bof) then 'connection the db search price_en's link
' price_link_en = "/ydm/"&rs_price("n_path")
' else
' price_link_en = "#"
' End If
' rs_price.close
%>
<%
dim rs_ab_us,sql_ab_us,ab_us_link,ab_us_link_en,temp_ab_us
temp_ab_us= "ab_us"
set rs_ab_us = Server.CreateObject("adodb.recordset")
sql_ab_us = "select * from t_awe where n_falg='"&temp_ab_us&"'" 'connection the db search ab_us's link
rs_ab_us.Open sql_ab_us,conn,1,1
If not (rs_ab_us.eof and rs_ab_us.bof) then
ab_us_link = "/ydm/"&rs_ab_us("n_path")
else
ab_us_link = "#"
End If
rs_ab_us.close
'sql_ab_us = "select * from t_awe where n_falg=ab_us_en" 'connection the db search ab_us_en's link
' rs_ab_us.Open sql_ab_us,conn,1,1
' If not (rs_ab_us.eof and rs_ab_us.bof) then
' ab_us_link_en = "/ydm/"&rs_ab_us("n_path")
' else
' ab_us_link_en = "#"
' End If
' rs_ab_us.close
%>
<%
dim rs_cross_servirce,sql_cross_servirce,cross_servirce_link,cross_servirce_link_en,temp_cross_servirce
temp_cross_servirce = "cross_servirce"
set rs_cross_servirce = Server.CreateObject("adodb.recordset")
sql_cross_servirce = "select * from t_awe where n_falg='"&temp_cross_servirce&"'"
rs_cross_servirce.Open sql_cross_servirce,conn,1,1
If not (rs_cross_servirce.eof and rs_cross_servirce.bof) then
cross_servirce_link = "/ydm/"&rs_cross_servirce("n_path")
else
cross_servirce_link = "#"
End If
rs_cross_servirce.close
' sql_cross_servirce = "select * from t_awe where n_falg=cross_servirce_en"
' rs_cross_servirce.Open sql_cross_servirce,conn,1,1
' If not (rs_cross_servirce.eof and rs_cross_servirce) then
' cross_servirce_link_en = "/ydm/"&rs_cross_servirce("n_path")
' else
' cross_servirce_link_en = "#"
' End If
' rs_cross_servirce.close
%>
<%
dim rs_one_stop,sql_one_stop,one_stop_link,one_stop_link_en,temp_one_stop
temp_one_stop = "one_stop"
set rs_one_stop = Server.CreateObject("adodb.recordset")
sql_one_stop = "select * from t_awe where n_falg='"&temp_one_stop&"'"
rs_one_stop.Open sql_one_stop,conn,1,1
If not(rs_one_stop.eof and rs_one_stop.bof) then
one_stop_link = "/ydm/"&rs_one_stop("n_path")
else
one_stop_link = "#"
End If
rs_one_stop.close
'sql_one_stop = "select * from t_awe where n_falg=one_stop_en"
' rs_one_stop.Open sql_one_stop,conn,1,1
' If not(rs_one_stop.eof and rs_one_stop.bof) then
' one_stop_link_en = "/ydm/"&rs_one_stop("n_path")
' else
' one_stop_link_en = "#"
' End If
' rs_one_stop.close
%>
<%
dim rs_limo,sql_limo,limo_link,limo_link_en,temp_limo
temp_limo = "limo"
set rs_limo = Server.CreateObject("adodb.recordset")
sql_limo = "select * from t_awe where n_falg='"&temp_limo&"'"
rs_limo.Open sql_limo,conn,1,1
If not(rs_limo.eof and rs_limo.bof) then
limo_link ="/ydm/"&rs_limo("n_path")
else
limo_link = "#"
end if
rs_limo.close
'sql_limo = "select * from t_awe where n_falg=limo_en"
' rs_limo.Open sql_limo,conn,1,1
' If not(rs_limo.eof and rs_limo.bof) then
' limo_link_en ="/ydm/"&rs_limo("n_path")
' else
' limo_link_en = "#"
' end if
' rs_limo.close
%>
