troubleshooting Question

ASP SQL SYNTAX ERROR

Avatar of Justin Imes
Justin ImesFlag for United States of America asked on
ASPSQL
9 Comments1 Solution356 ViewsLast Modified:
I am trying to put together a simple web app for deleting and adding new posts.

I have a form setup on addnew.asp here is the form code
<form name="addnew" method="post" action="addcodage.asp">

addcodage.asp:

here is the ASP code where it breaks.
 <%  
frm_dbID = Request.Form("ID")
frm_dbDate = Request.Form("DATE")
frm_dbPosition = Request.Form("POSITION")
frm_dbDepartment = Request.Form("DEPARTMENT")
frm_dbDescription = Request.Form("DESCRIPTION")
frm_dbRate = Request.Form("RATE")
frm_dbvisible = Request.Form("VISIBLE")
frm_dbPTFT = Request.Form("PTFT")
frm_dbFile = Request.Form("File")

SQLText = "INSERT INTO Posting (ID, DATE, POSITION, DEPARTMENT, DESCRIPTION, RATE, VISIBLE, PTFT, File) VALUES (" & frm_dbID & "," & frm_dbDate & ",'"& frm_dbPosition & "','" & frm_dbDepartment & "','" & frm_dbDescription & "','" & frm_dbRate & "','"  & frm_dbvisible & "','"  & frm_dbPTFT & "','"  & frm_dbFile & "')"

SQLUser="Provider=SQLOLEDB.1;User ID=****;PASSWORD=****;Initial Catalog=Employment;Data Source=DCABSQL01c"
set recordset = server.createobject("adodb.recordset") <--------BREAKS ON THIS LINE
recordset.open SQLText, SQLUser, 3, 3
      
Response.write(SQLTEXT)

Response.write("<P> Post Successfully Added")

'Do while not Recordset.Eof
'Set Recordset = Nothing
%>

i know i'm doing something simple wrong, if i comment out set recordset and recordset.open everything works but it obviously doesn't insert it into the database.  any suggestions?
ASKER CERTIFIED SOLUTION
_Stilgar_

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros