chern0byl
09-18-2001, 08:07 PM
I am trying to get into my dads MySQL DB to update his site while he is on holidays.this is the only thing he asks me to do and i cant http://www.sharkyforums.com/ubb/smile.gif)
<%
name=request.querystring("Name")
mail=request.querystring("Mailid")
cat=Request.querystring("ret_max")
Response.Write(cat)
dim con,rs,db
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={****:mysql://mysql.gocampingireland.com/********};uid=********;pwd=********;"
set con=server.createobject("adodb.connection")
con.open(ConnectionString)
set rs=server.createobject("adodb.recordset")
'con.connectionstring="Driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("/data/camping.mdb")
'con.open
'con.execute("insert into subscription(name,mail,category) values('"&name&"','"&mail&"','"&cat&"')")
con.execute("insert into subscription(name,mail,category) values('"&name&"','"&mail&"','"&cat&"')")
con.close
set con=nothing
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<center><h2><font color="crimson"><b>Your Mail Id Has Been Added</b></font></h2></center>
<P>*</P>
</BODY>
</HTML>
Right i wanna now how i access it to edit it.
the above is his email DB.
*=the bits only i should know http://www.sharkyforums.com/ubb/smile.gif
------------------
Ashley Lyn Cafagna (http://www.boards.ie/members/chernobyl/ashley.jpg)
EON Help (i hope) (http://www22.brinkster.com/chernobyl/)
[This message has been edited by chern0byl (edited September 18, 2001).]
<%
name=request.querystring("Name")
mail=request.querystring("Mailid")
cat=Request.querystring("ret_max")
Response.Write(cat)
dim con,rs,db
ConnectionString="DRIVER=org.gjt.mm.mysql.Driver;URL={****:mysql://mysql.gocampingireland.com/********};uid=********;pwd=********;"
set con=server.createobject("adodb.connection")
con.open(ConnectionString)
set rs=server.createobject("adodb.recordset")
'con.connectionstring="Driver={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("/data/camping.mdb")
'con.open
'con.execute("insert into subscription(name,mail,category) values('"&name&"','"&mail&"','"&cat&"')")
con.execute("insert into subscription(name,mail,category) values('"&name&"','"&mail&"','"&cat&"')")
con.close
set con=nothing
%>
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<center><h2><font color="crimson"><b>Your Mail Id Has Been Added</b></font></h2></center>
<P>*</P>
</BODY>
</HTML>
Right i wanna now how i access it to edit it.
the above is his email DB.
*=the bits only i should know http://www.sharkyforums.com/ubb/smile.gif
------------------
Ashley Lyn Cafagna (http://www.boards.ie/members/chernobyl/ashley.jpg)
EON Help (i hope) (http://www22.brinkster.com/chernobyl/)
[This message has been edited by chern0byl (edited September 18, 2001).]