Saving form data to database

[dylan03]

HELLLLLLLLLLP! I used MS FrontPage's database interface to create a webpage that is supposed to save the form data to the database.

I created and verified the connection between the db & webpage. I can enter information into the webpage (

http://www.automaxxmotors.com/creditapp.asp),

and I receive a confirmation page, but it doesn't save the information to the database.

Can anyone help me figure out what I am doing wrong?

 

[kcsants]

This is a HUGE question..... there is a lot that could go wrong....

1. ADODB Connection
EXAMPLE:
Actionvar=Request.QueryString("actionvar&quot

path=Server.MapPath(".&quot

Set conn = server.createobject("adodb.connection&quot
StrConnString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & path & "\YOURACCESSDATABASE.mdb;Persist Security Info=False"
conn.Open StrConnString

2. SQL Statement
EXAMPLE:
SQLstmt = "INSERT INTO YOURDATABASETABLE (DATA1,DATA2)"
SQLstmt = SQLstmt & " VALUES ("
SQLstmt = SQLstmt & "'" & DATA1 & "'" & ", "
SQLstmt = SQLstmt & "'" & DATA2 & "'" & &quot "
conn.execute(SQLstmt)

3. Code Syntax

The list could go on and on...... start with the above.
GOOD LUCK!!!!!!!!!!!!!!!!!