..i tried to insert data's to a table and its working ..but the only problem is when i click the button Submit(to add data)its adding 2 rows of data...1 is the data's which i entered n the other 1 is a blank row of data...so when i log out n run the form again..error occured..saying that confilcts in a primary key..coz there is a blank rows in the table...
the code is like this
<%
dim connstring,strsql
dim strname,stremail
strname=request.form("frmname")
stremail=request.form("frmemail")
connstring="Provider=SQLOLEDB;User ID="name";Password="password"
set my_conn=server.createobject("ADODB>Connection")
my_conn.Open connstring
strsql="INSERT INTO UserEmails(Name,email)values("&"'"&strName&'",'"&s tremail&"')"
set rs=my_conn.execute(strsql)
%>
Linear Mode
