Adding a record to access 1

[MoaD]

When a user wants to download something from my page i want them to enter an email address and store it in an access database. the code below is what i have right now but the SQL statement isn't working. Any help would be great


Table name = tblEmail
Field = txtEmail


<%
emailAdd = Request.Form(&quot;email&quot
SQL = &quot;insert into tblEmail (txtEmail) values (emailAdd)&quot;
dbName = &quot;dsDb&quot;

Set dbCon = Server.CreateObject(&quot;ADODB.Connection&quot
dbCon.Open dbName
dbCon.Execute SQL
%>

I've tested each line and they all work up to the Execute line.

 

[streborr]

Try this,

SQL = &quot;insert into tblEmail (txtEmail) values ('&quot; & emailAdd & &quot;');&quot;

Rick

 

[MoaD]

Thanks alot Rick your the best

 

[Dynapen]

Just for future reference, the best way to test those things, is to have it write out the SQL statment to the browser so you can see it. Then you can copy and paste it into the DB to make sure it works.

Example:

Response.write SQL
Response.end

Originally this would have written out

insert into tblEmail (txtEmail) values (emailAdd)

This way you could have seen that it wasn't handling the value correctly.