请问ASP函数和SQL语句的两个有关问题
日期：2014-05-17 浏览次数：20887 次
请教ASP函数和SQL语句的两个问题
<%
types=request.QueryString("type")
Function types_type(types_name)
if types_name<>"" then
type_sql = "select * from brand where type='"&types_name&"'"
set type_rs=conn.execute(type_sql)
brand_sql = "select * from brand where type_id="&type_rs("id")
set brand_rs=conn.execute(brand_sql)
sql="select * from BI where type="&type_rs("id")'&" and brand="&brand_rs("id")
else
sql="select * from BI order by type,brand"
end if
end Function
if types="Desktop" then
type_name="台式计算机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Notebook" then
type_name="笔记本计算机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Server" then
type_name="服务器"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Office" then
type_name="打印机' or type='复印机' or type='传真机' or type='扫描仪' or type='多功能一体机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Network" then
type_name="网络设备"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
else
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
end if
%>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="98%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">基本设备</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="71" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9"><table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="13" valign="top"> </td>
</tr>
<tr>
<td valign="top"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="left_txt">当前位置：基本设备</td>
<
<%
types=request.QueryString("type")
Function types_type(types_name)
if types_name<>"" then
type_sql = "select * from brand where type='"&types_name&"'"
set type_rs=conn.execute(type_sql)
brand_sql = "select * from brand where type_id="&type_rs("id")
set brand_rs=conn.execute(brand_sql)
sql="select * from BI where type="&type_rs("id")'&" and brand="&brand_rs("id")
else
sql="select * from BI order by type,brand"
end if
end Function
if types="Desktop" then
type_name="台式计算机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Notebook" then
type_name="笔记本计算机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Server" then
type_name="服务器"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Office" then
type_name="打印机' or type='复印机' or type='传真机' or type='扫描仪' or type='多功能一体机"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
elseif types="Network" then
type_name="网络设备"
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
else
sql=types_type(type_name)
response.Write(types_type(type_name))
set rs=conn.execute(sql)
end if
%>
<link href="images/skin.css" rel="stylesheet" type="text/css" />
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
<td valign="top" background="images/content-bg.gif"><table width="98%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
<tr>
<td height="31"><div class="titlebt">基本设备</div></td>
</tr>
</table></td>
<td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
</tr>
<tr>
<td height="71" valign="middle" background="images/mail_leftbg.gif"> </td>
<td valign="top" bgcolor="#F7F8F9"><table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="13" valign="top"> </td>
</tr>
<tr>
<td valign="top"><table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="left_txt">当前位置：基本设备</td>
<
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
