Come on, grow up and get real. How can you say that PHP is
much clearer? This example was very clear, and almost identical
to how you could do it in PHP:
<%
$MyConn = mysql_connect([arguments]);
$SQL_query = "SELECT * FROM your_table WHERE your_field LIKE '%abc%'";
$RS = mysql_query($SQL_query);
%>
<HEAD>
<TITLE>PHP with MySQL</TITLE>
</HEAD>
<BODY>
<p><b><% echo $SQL_query %></b></p>
<% while($r=mysql_fetch_row($RS)):%>
<%=$r("FIELD1")
%> <%=$r("FIELD2")%> <%=$r("FIELD3")%><br>
<%endwhile%>
<%
mysql_free_result($RS);
mysql_close($MyConn);
%>
At 03:47 6.1. 2001, David Patte wrote the following:
--------------------------------------------------------------
>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/
>
>---------------------------------------------------------------------
>Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
>posting. To request this thread, e-mail win32-thread4699@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.
------end of quote------
____________________________________________________________
Cynic:
A member of a group of ancient Greek philosophers who taught
that virtue constitutes happiness and that self control is
the essential part of virtue.
cynic@stripped
