Advertisement
Advertisement
| 04.11.2008 at 01:40PM PDT, ID: 23316416 |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
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
%>
---------------------------------------------------------------------------------------------------------------------------------------------
**************************************************************************************************************
---------------------------------------------------------------------------------------------------------------------------------------------
|