Ændre i MySQL
Hej, jeg har konverteret min ACCESS database til MySQL, og forsøger nu at få dette ASP-script til at virke. Hvad skal ændres udover connection for at skrive i MySQL-databasen?<%
Response.Buffer = true
Response.CacheControl = "no-cache"
Response.Expires = -1
%>
<!-- #include file="Adovbs.inc" -->
<%
strNews = Request.Form("News")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={mysql};SERVER=mysql.mondohosting.net;UID=xxx;PWD=xx;DATABASE=xx"
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL="SELECT * FROM News WHERE idNews=" & strNews
rs.Open strSQL, Conn, 1, 3
if not rs.eof then
if len(Request.Form("NewsHeader")) < 1 then
strRedirect = "News.asp"
Response.Redirect strRedirect
end if
if len(Request.Form("Source")) < 1 then
strRedirect = "News.asp"
Response.Redirect strRedirect
end if
rs("NewsHeader") = Request.Form("NewsHeader")
rs("Source") = Request.Form("Source")
end if
rs.update
rs.Close
set rs = Nothing
strRedirect = "News.asp"
Response.Redirect strRedirect
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<P> </P>
</BODY>
</HTML>
