Advertisement
Advertisement
| 04.11.2008 at 01:40PM PDT, ID: 23316416 |
|
[x]
Attachment Details
|
||
1: 2: 3: 4: 5: 6: 7: 8: 9: 10: 11: 12: 13: 14: 15: 16: 17: 18: 19: 20: 21: 22: 23: 24: 25: 26: 27: 28: 29: 30: 31: 32: 33: 34: 35: 36: 37: 38: 39: 40: 41: 42: 43: 44: 45: 46: 47: 48: 49: 50: 51: 52: 53: 54: 55: 56: 57: 58: 59: 60: 61: 62: 63: 64: 65: 66: 67: 68: 69: 70: 71: 72: 73: 74: 75: 76: 77: 78: 79: 80: 81: 82: 83: 84: 85: 86: 87: 88: 89: 90: 91: 92: 93: 94: 95: 96: 97: 98: 99: 100: 101: 102: 103: 104: 105: 106: 107: 108: 109: 110: 111: 112: 113: 114: 115: 116: 117: 118: 119: 120: 121: 122: 123: 124: 125: 126: 127: 128: 129: 130: 131: |
---------------------------------------------------------------------------------------------------------------------------------------------
AJAX_Form.asp
---------------------------------------------------------------------------------------------------------------------------------------------
<html>
<head>
<!-- <script src="selectuser.js"></script> --->
<script language="javascript">
var xmlHttp
function showUser(str)
{
xmlHttp=GetXmlHttpObject() //See if it works with users browser.
if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request")
return
}
var url="AJAX_getcustomer.asp"
url=url+"?q="+str
//url=url+"&sid="+Math.random()
xmlHttp.onreadystatechange=stateChanged //calls the stateChanged() function
xmlHttp.open("POST",url,true) '<--When I change to post I get a 'blank page
xmlHttp.send(null)
}
function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
document.getElementById("txtHint").innerHTML=xmlHttp.responseText
}
}
function GetXmlHttpObject()
{
var xmlHttp=null;
try
{
// Firefox, Opera 8.0+, Safari
xmlHttp=new XMLHttpRequest();
}
catch (e)
{
// Internet Explorer
try
{
xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");
}
catch (e)
{
try
{
xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");
}
catch (e)
{
alert("Your browser does not support AJAX!");
return false;
}
}
}
return xmlHttp;
}
</script>
</head>
<body>
<form>
Select a User:
<select name="users" onchange="showUser(this.value)">
<option value="1">John Smith1</option>
<option value="2">John Smith2</option>
<option value="3">John Smith3</option>
<option value="4">John Smith4</option>
</select>
</form>
<p>
<div id="txtHint"><b>User info will be listed here.</b></div>
</p>
</body>
</html>
---------------------------------------------------------------------------------------------------------------------------------------------
AJAX_getcustomer.asp
---------------------------------------------------------------------------------------------------------------------------------------------
<!--#include file = "./includes/ajax_DBConnOpen.asp" -->
<%
response.expires=-1
sql="SELECT * FROM tbl_AJAX_example WHERE uid="
sql=sql & "'" & request.querystring("q") & "'"
set rs = Server.CreateObject("ADODB.recordset")
rs.Open sql, dbconn
response.write("<table>")
do until rs.EOF
for each x in rs.Fields
response.write("<tr><td><b>" & x.name & "</b></td>")
response.write("<td>" & x.value & "</td></tr>")
next
rs.MoveNext
loop
response.write("</table>")
%>
---------------------------------------------------------------------------------------------------------------------------------------------
**************************************************************************************************************
---------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------
ajax_DBConnOpen.asp
---------------------------------------------------------------------------------------------------------------------------------------------
<%
'Create an ADO Connection object
Set DBConn = Server.CreateObject("ADODB.Connection")
'response.end
'Open the connection to the database
DSN = "Driver={SQL Server};Server=localhost;database=darpasid_production_oba;uid=xxx;pwd=xxxxx;"
DBConn.Open DSN
%>
---------------------------------------------------------------------------------------------------------------------------------------------
**************************************************************************************************************
---------------------------------------------------------------------------------------------------------------------------------------------
|