Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Asp Form
- Thread starter Newbie311
- Start date
try this, all this code requires is your connection string
name is file insert.asp
name is file insert.asp
Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
if request("submit")="Add Record" then
'assuming connstr is your connection string
set conn=CreateObject("ADODB.Connection")
conn.open(connstr)
sql="insert into tblname (field1,field2) values ('"&request("text1")&"','"&request("text2")&"')"
conn.execute(sql)
conn.close
set conn=nothing
response.redirect("thankyou.asp")
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Insert Record</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form name="form1" method="post" action="insert.asp">
<p>
<input name="text2" type="text" >
</p>
<p>
<input name="text2" type="text">
</p>
<p>
<input type="submit" name="Submit" value="Add Record">
</p>
</form>
</body>
</html>- Thread starter
- #5
- Thread starter
- #7
Hi Steven, I managed to fix that problem it occured because in your code you have named two text boxes the same.
I have now posted the current error which is related to the below query.
sql="insert into users(username,password) values('"&request("text1")&"','"&request("text2")&"')"
It gives me a syntax error,Im using an Access DB if that helps?
I have now posted the current error which is related to the below query.
sql="insert into users(username,password) values('"&request("text1")&"','"&request("text2")&"')"
It gives me a syntax error,Im using an Access DB if that helps?
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
