ʹÓÃJQueryºÍASP´òÔìAutoComplete¹¦ÄÜ
¿Í»§¶Ë´úÂ룺
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>ʹÓÃJQueryºÍASP´òÔìAutoComplete¹¦ÄÜ</title>
<script type="text/javascript" src="js/jquery-1.2.1.pack.js"></script>
<script type="text/javascript">
function lookup(inputString) {
if(inputString.length == 0) {
// Hide the suggestion box.
$('#suggestions').hide();
} else {
$.post("showmember.asp", {queryString: ""+escape(inputString)+""}, function(data){
if(data.length >0) {
$('#suggestions').show();
$('#autoSuggestionsList').html(unescape(data));
}
});
}
} // lookup
function fill(thisValue) {
$('#inputString').val(thisValue);
setTimeout("$('#suggestions').hide();", 200);
}
</script>
<style type="text/css">
body {
font-family: Helvetica;
font-size: 11px;
color: #000;
}
h3 {
margin: 0px;
padding: 0px;
}
.suggestionsBox {
position: relative;
left: 30px;
margin: 10px 0px 0px 0px;
width: 200px;
background-color: #212427;
-moz-border-radius: 7px;
-webkit-border-radius: 7px;
border: 2px solid #000;
color: #fff;
}
.suggestionList {
margin: 0px;
padding: 0px;
}
.suggestionList li {
margin: 0px 0px 3px 0px;
padding: 3px;
cursor: pointer;
}
.suggestionList li:hover {
background
Ïà¹ØÎĵµ£º
Active Server Pages ÌṩÄÚ½¨¶ÔÏó£¬ÕâЩ¶ÔÏóʹÓû§¸üÈÝÒ×ÊÕ¼¯Í¨¹ýä¯ÀÀÆ÷ÇëÇó·¢Ë͵ÄÐÅÏ¢¡¢ÏìÓ¦ä¯ÀÀÆ÷ÒÔ¼°´æ´¢Óû§ÐÅÏ¢£¨ÈçÓû§Ê×Ñ¡Ï¡£±¾ÎļòҪ˵Ã÷ÿһ¸ö¶ÔÏó¡£
Application ¶ÔÏó
¿ÉÒÔʹÓà Application ¶ÔÏóʹ¸ø¶¨Ó¦ÓóÌÐòµÄËùÓÐÓû§¹²ÏíÐÅÏ¢¡£
Request ¶ÔÏó
¿ÉÒÔʹÓà Request ¶ÔÏó·ÃÎÊÈκÎÓà HTTP ÇëÇó ......
¡¡¡¡ASPµÄ©¶´ÒѾËãºÜÉÙµÄÁË£¬ÏëÒªÕÒµ½Êý¾Ý¿âµÄʵ¼ÊλÖÃÒ²²»¼òµ¥£¬µ«Õâ²»±íÃ÷ºÚ¿ÍÎ޿׿ÉÈ룬ҲÕýÊÇÕâ¸ö¹Ûµã£¬Ò»°ãµÄ³ÌÐòÉè¼ÆÔ±³£³£Íü¼Ç×ÐϸµÄ¼ì²éÊÇ·ñÓЩ¶´£¬ËùÒÔ²ÅÓпÉÄܵ¼ÖÂÍøÕ¾×ÊÁϱ»ÇÔÈ¡µÄʼþ·¢Éú¡£½ñÌìÎÒÔÚÕâÀïºÍ´ó¼Ò̸̸ASP³£¼ûµÄ°²È«Â©¶´£¬ÒÔÒýÆð´ó¼ÒµÄÖØÊÓ¼°²ÉÈ¡ÓÐЧµÄ·À·¶´ëÊ©¡£(×¢Ò⣬ÔÚ±¾ÎÄÖÐËù½éÉܵķ½·¨Çë´ ......
¡¡1.¼Ç¼¼¯¹Ø±Õ֮ǰÔٴδò¿ª:
¡¡¡¡------------------------------------
¡¡¡¡sql="select * from test"
¡¡¡¡rs.open sql,conn,1,1
¡¡¡¡if not rs.eof then
¡¡¡¡dim myName
¡¡¡¡myName=rs("name")
¡¡¡¡end if
¡¡¡¡sql="select * from myBook"
¡¡¡¡rs.open sql,conn,1,1
¡¡¡¡------------------------------------ ......
×¢£º±¾ÈË°²×°µÄÊÇWindows 7 RC 7100 32λÖÐÎÄÆì½¢°æ ¡£
ÔÚWindows 7ÏÂÃæIIS7µÄ°²×°·½·¨£º
Ò»¡¢½øÈëWindows 7µÄ ¿ØÖÆÃæ°å
£¬Ñ¡Ôñ×ó²àµÄ ´ò¿ª»ò¹Ø±ÕWindows¹¦ÄÜ
¡£
¶þ¡¢ÏÖÔÚ³öÏÖÁË°²×°Windows¹¦ÄܵÄÑ¡Ïî²Ëµ¥
£¬×¢ÒâÑ¡ÔñµÄÏîÄ¿£¬ÎÒÃÇÐèÒªÊÖ¶¯Ñ¡Ôñ
ÐèÒªµÄ¹¦ÄÜ£¬ÏÂÃæÕâÕÅͼƬ°ÑÐèÒª°²×°µÄ·þÎñ¶¼ÒѾѡÔñÁË£¬´ó¼Ò¿ÉÒÔ°´ÕÕ ......
conndb.asp
<%
Session.CodePage=65001
response.Charset="utf-8"
%>
<%
'Êý¾Ý¿âÁ¬½ÓÎļþ
dim conn
dim connstr
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+server.mappath("../date/#heihuhuhuajian.mdb")+";Jet OLEDB:Database Pass ......