你写代码了么 打出来看看
http://www./
以下是引用yuxin1382在2007-4-29 17:43:13的发言：
西安：
sql="select * from 表 where 1=1" 这里的1=1是什么意思啊
西安：
sql="select * from 表 where 1=1" 这里的1=1是什么意思啊
条件永远为真...某某人发明的 
2007-04-29 17:44
2007-04-29 17:44
2007-04-29 17:45
2007-04-29 17:46
2007-04-29 20:35
guyer
你好
我现在的代码是这样的：
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!--#include file="conn.asp"-->
<% kc="select * from kcsp"
set rs=conn.execute(kc)
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>商品数据</title>
<style type="text/css">
<!--
.style1 {font-size: medium}
.style2 {
font-size: medium;
font-weight: bold;
}
-->
</style>
</head>
<body>
<div align="center">
<form name="form1" method="post" action="" onchick="retrun ss() ">
<table width="588" border="0" bgcolor="#CCCCCC">
<tr>
<th width="77" height="20" scope="col">快速查找:</th>
<th width="103" scope="col"><select name="select" style="width:90px; height:15px; font-size:15px; background-color:#CCCCCC">
<option value="0">商品编号</option>
<option value="1">商品名称</option>
<option value="2">入库日期</option>
</select></th>
<th width="58" scope="col">条件：</th>
<th width="105" scope="col"><select name="select" style="width:90px; height:15px; font-size:15px; background-color:#CCCCCC">
</select></th>
<th width="143" scope="col"><input name="sqltext" type="text" size="20"></th>
<th width="76" scope="col"><input type="submit" name="Submit" value="查询"></th>
</tr>
</table>
</form>
<p> </p>
<table width="610" border="1" bordercolor="#9966CC">
<tr>
<th bgcolor="#990033" scope="col"> </th>
</tr>
</table>
<table width="610" height="30" border="1" cellpadding="1" bordercolor="#9999CC">
<style>
table {width:160;table-layout: fixed;}
td {white-space: nowrap;}
</style>
<tr>
<th width="50" scope="col"><div align="center">编号</div></th>
<th width="130" scope="col"><div align="center">名称</div></th>
<th width="60" scope="col"><div align="center">型号</div></th>
<th width="40" scope="col">价格</th>
<th width="40" scope="col">数量</th>
<th width="40" scope="col">单位</th>
<th width="60" scope="col">类别</th>
<th width="90" scope="col">入库时间</th>
</tr>
<% do while not rs.eof %>
<tr>
<th width="50" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_id")%></div></th>
<th width="130" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_name")%></div></th>
<th width="60" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_xh")%></div></th>
<th width="40" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_jg")%></div></th>
<th width="40" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_sl")%></div></th>
<th width="40" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_jldw")%></div></th>
<th width="60" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_lb")%></div></th>
<th width="90" nowrap scope="col"><div align="left" class="style1"><%=rs("kcsp_lksj")%></div></th>
</tr><% rs.movenext
loop
%>
</table>
</div>
</body>
</html>
<% rs.close
set rs=nothing
conn.close
2007-04-29 21:15
2007-04-29 21:16
2007-04-30 09:24
2007-04-30 09:30
2007-04-30 11:18