How can I connect to my MySQL database
using ASP/Javascript?
The
code would look like this:
<%@ LANGUAGE = JScript%>
<html>
<%
var conn,result;
conn = Server.CreateObject("ADODB.Connection");
conn.Open("DSN=YOUR_DSN;Username=YOUR_ID;Password=YOUR_PWD");
result=conn.Execute("SELECT * FROM table");
while (!result.eof) {
Response.Write(result("FIELD1") + " : " +
result("FIELD2") +
" " + result("FIELD3") + "<BR>");
result.MoveNext();
}
result.close();
%>
</body>
</html>
How can I connect to MySQL via ASP/VBScript?
The
code would look like this:
<%@ LANGUAGE="VBSCRIPT" %>
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MyConn.Open "YOUR_DSN"
SQL_query = "SELECT * FROM your_table WHERE your_field LIKE
'%abc%';"
Set RS = MyConn.Execute(SQL_query)
%>
<HTML>
<HEAD>
<TITLE>Document Title</TITLE>
</HEAD>
<BASEFONT FACE="arial">
<BODY>
<p><b><% Response.Write SQL_query %></b></p>
<%while not RS.eof%>
<%=RS("FIELD1")%> <%=RS("FIELD2")%> <%=RS("FIELD3")%><br>
<%RS.MoveNext%>
<%wend%>
<%
RS.Close
MyConn.Close
</BODY>
</HTML>
