I have never seen vbscript before - wow - sure glad I use PHP - alot
clearer :)
Guillaume wrote:
>
> 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.
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4698@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.
--
David Patte
Relative Data, Inc.
----------------------
MyStars! 2.7 "Shareware for Stargazers"
24 Hr Bus. Phone/Fax: 1 (613) 728-4240
Website #1: http://www.relativedata.com/
Mirrorsite: http://www.relativedata.ca/
Website #2: http://www.mystarslive.com/
