ASP links Mysql and reads data

zhaozj2021-02-17 52

<% 'ASP Link MySQL program' Nees need to install MySQLODBC driver download address: http://www.mysql.com/downloads/api-myodbc-2.50.html'E-mail: kaxue@hotmail.com QQ: 484110 HomePage: Www.flyday.net 'Finishing Time: Thursday, May 23, 2002 5:54 PM Win2000 Server IIS5 Test by strConnection = "DSN = User"' striver = "defaultdir =; driver = {myodb driver}; database = bbs" Set adodataconn = server.createObject ("adodb.connection" AdoDataConn, STRCONNECTION

Strquery = "Select * from user where username =" kaxi "" SET RS = Server.createObject ("AdoDb.Recordset") RS.Open StrQuery, StrConnection, 2, 1

Response.write rs. gene.write rs.bof1%>

username

password <% do while not qi = = rs ("username")%>

<% = rs ("password")%> <% rs.movenext loop%> <% else response.write ("Sorry, no data you need") Endiff

rs.close adodataconn = not%>

转载请注明原文地址:https://www.9cbs.com/read-28973.html

9cbs

New Post(0)