16
Hello happy campers,
gotta another question for the grey matter that you all share.
In the script below, what is "YOUR_DSN"? How can I find out my DSN?
How can you describe it in laymans, and what is a good example?
As always, thankyou.
<%@ 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")%> <%=R S("FIELD3")%><br>
<%RS.MoveNext%>
<%wend%>
<%
RS.Close
MyConn.Close
</BODY>
</HTML>
