Hi
first make sure you have a compatible webserver ! ;o)
PWS for 95 is OK
Your website on the internet may not support ASP
Create a DSN like indicated in MyODBC doc file
Then you can try this :
vbscript connection (ODBC DSN required)
*****
<%@ 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>ASP with MySQL</TITLE>
</HEAD>
<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>
******
just copy code above and name your file "test.asp"
Should work... ;o)
///// D W A M W 3 S P A C E /////////////////////
Guillaume de Lafontaine - webmaster@stripped
. Services Internet : http://www.w3space.com
. Annuaire Aquitaine : http://www.aquitanet.com
. Espace TeleTravail : http://www.w3workers.com
-----Message d'origine-----
De : TayeLeg@stripped <TayeLeg@stripped>
À : win32@stripped <win32@stripped>
Date : samedi 6 janvier 2001 02:59
Objet : "Your Help PleaseL"
|
| I designed a database in MySQL on my Window 95 and managed to walk through
|the various queries successfuly. Further, I installed ODBC. Ofcours I have
|conncted to the internet.
|By writting a HTML together withVB Script on an editor (Note Pad)
|I failed to display anything using Browthers (Netscape or IExpl).
|
|After reading books, I realized that I have to use :
| ADO........which I thought was only ODBC for my Win95 case.
|ASP......(Active Server Pages) what I took it for editor
|
| Actually, I am writting a THESIS but stucked. Please tell me what to do?
|
| thank you
|
|---------------------------------------------------------------------
|Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
|posting. To request this thread, e-mail win32-thread4697@stripped
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail win32-unsubscribe@stripped instead.
