?? select_pinmu.asp
字號:
<!--#include file=inc/conn.asp-->
<style type="text/css">
<!--
a:hover { font-size: 12pt; color: #FF0000; text-decoration: underline}
a:link { font-size: 12pt; color: #006699; text-decoration: underline}
a:visited { font-size: 12pt; color: #006699; text-decoration: underline}
a:active { font-size: 12pt; color: #FF0000; text-decoration: none}
a.r1:hover { font-size: 12pt; color: #FF0000; text-decoration: underline overline}
a.r1:link { font-size: 12pt; color: #000000; text-decoration: underline overline}
a.r1:visited { font-size: 12pt; color: #99CC00; text-decoration: underline overline}
a.r1:active { font-size: 12pt; color: #000000; text-decoration: underline overline}
-->
</style>
<body bgcolor="D2E4FC">
<form name="search" method="post" action="select_pinmu.asp">
<p>查詢內容:
<input type="text" name="name">
<input type="submit" name="Submit" value="查詢">
</p>
</form>
<FORM METHOD=POST ACTION="">
查詢結果:
<INPUT NAME="pinmu1" TYPE="text" id="pinmu1">
<INPUT TYPE="button" value="提交" onclick="window.opener.document.forms[0].pinmu.value = this.form.pinmu1.value">
<a href="javascript:window.close();">關閉</a><br>
</FORM>
<p>
<table border="1" width="100%"><tr>
<%
dim rsname,i
i=0
rsname=request("name")
rsname=Trim(request("name"))
set rs=server.CreateObject("adodb.recordset") '(建立recordset對象)
sqlstr="select * from pinmu where GOODSITEMNAME like'%"&rsname&"%' order by id desc"
'---->(message為數據庫中的一個數據表?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -