Web Development

Ask something
Discussion Locked

ASP TO EMAIL AND DATABASE ERROR

0 helpful
4 replies

by rmg

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to post data to a database and email it at the same time from a web page form. I get an error when I try to do this. Help!

Here is the form page:

Here is the action page:

<%@ Language=VBScript %>
<%
dim connectstr

connectstr="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=emails;Data Source=VCSESUPPLYCHAIN"
dim conn
set conn=server.createobject("adodb.connection")
with conn

.open connectstr
.execute "INSERT INTO emailtrack(To,From,Subject,Body) Values('" & request("rcptaddr") & "','" & request("sndraddr") & "','" & request("subject") & "','" & request("body") & "')"

.close
end with
set conn=nothing

dim objsendmail
set objsendmail=server.CreateObject("cdonts.newmail")
objsendmail.To="ryan_gardner@non.hp.com"
objsendmail.From="ryan_gardner@non.hp.com"
objsendmail.Subject="This is a test"
objsendmail.Body="This is the body of the test"
objsendmail.Send
%>

Here is the error I get:

Microsoft OLE DB Provider for SQL Server error '80040e14'

Incorrect syntax near the keyword 'To'.

/buypower/apptest/esender.asp, line 11

What can I do to fix this?!?

4 replies

by madestroitsolutions

My dear friend, for your future reference, when you get this type of error ("incorrect syntax...") it usually refers to your SQL statement.
You are requesting values from a FORM. The correct syntax is:

Request.form("MyField")

You are writing:

Request("MyField")

You can retrieve values from either form or querystring, so you need to tell the request object what collection you are retrieving the field from.

Also, If I was you, I would do it with an ADO recordset. For some reason Insert SQL statements tend to yield errors all the time. I have done countless projects with them, and I still have problems when I use them with ADO connections, so create an ADO recordset object, use the Addnew method, assign the values to the fields ( Rs01.fields(0) = xxx ) issue the Update method and thats it!

Try it, and if you have any other problems, feel free to drop a line at: webmaster@KingsDistributors.com

Good luck!

This discussion is closed to new replies.