Error with SQL query included in .asp page.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,
I am working with online recruiting website created using VBscript and SQL
database.
I am not sure why i m geeting this error.

Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/Webr/companyOV.asp, line 12

code looks like:

<%@ Language=VBScript %>
<HTML>
<HEAD>
<%
DIM MYSQL
MYSQL= "INSERT INTO Applicant(FirstName, LastName, Address1, Address2, City,
State, Province, Zip, HomePhone, BusinessPhone, Email, Educlevel,
OtherCertification, DesiredSalary, Company1, DateFrom1, DateTo1, JobTitle1,
Salary1, Duties1, Manager1, ContactNumber1, Company2, DateFrom2, DateTo2,
JobTitle2, Salary2, Duties2, Manager2, ContactNumber2, Company3, DateFrom3,
DateTo3, JobTitle3, Salary3, Duties3, Manager3, ContactNumber3, UnionPosition,
Race, Sex, RUFOP, Requisition, Resume)VALUES ('" & request.form("FirstName")
&"', '" & request.form("LastName") & "', '" & request.form("Address1") & "',
'" & request.form("Address2") & "', '" & request.form("City") & "', '" &
request.form("State") & "', '" & request.form("Province") & "', '" & request.
form("Zipcode") & "', '" & request.form("HomePhone") & "', '" & request.form
("BusinessPhone") & "', '" & request.form("Email") & "', '" & request.form
("Educlevel") & "', '" & request.Form("OtherCertification") & "', '" &
Request.Form("DesiredSalary") & "', '" & request.form("Company1") & "', '" &
request.form("From1") &"', '" & request.form("To1") &"', '" & request.form
("JobTitle1") &"', '" & request.form("Salary1") &"', '" & request.form
("Duties1") &"', '" & request.form("Manager1") &"', '" & request.form
("ContactNumber1") &"', '" & request.form("Company2") & "', '" & request.form
("From2") &"', '" & request.form("To2") &"', '" & request.form("JobTitle2")
&"', '" & request.form("Salary2") &"', '" & request.form("Duties2") &"', '" &
request.form("Manager2") &"', '" & request.form("ContactNumber2") &"', '" &
request.form("Company3") & "', '" & request.form("From3") &"', '" & request.
form("To3") &"', '" & request.form("JobTitle3") &"', '" & request.form
("Salary3") &"', '" & request.form("Duties3") &"', '" & request.form
("Manager3") &"', '" & request.form("ContactNumber3") &"', '"& request.form
("UnionPosition") &"', '"& request.form("Race") &"', '"& request.form("Sex")
&"', '" & request.Form("RUFOP") & "', '" & request.form("Requisition") & "',
'"& request.form("resume") &"')"

Set Con = Server.CreateObject("ADODB.Connection")
Con.Open "AccessDSN","sa",""
'Con.Open "Data Source=" & Server.Mappath("/careers/Web_Recruitment.mdb") &
";Provider=Microsoft.Jet.OLEDB.4.0;"
set Rs= con.Execute(MYSQL)
'Response.Write(MYSQL)
con.Close
Set con=Nothing
%>


Thanks for your help!


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/outlook-prog-forms/200507/1
.

Relevant Pages

  • mysql and mythtv
    ... could not connect to the database". ... 2005-11-23 13:48:51.441 No error type from QSqlError? ... Strange... ...
    (alt.os.linux.suse)
  • Re: redirect if record already exists in database
    ... I'm using an access 2K database. ... Error Type: ... So, if an employee votes already, when they go to vote again, their ... > entire thing in a single query. ...
    (microsoft.public.inetserver.asp.general)
  • Message from Hell in OE 5.0.6
    ... Outlook Express for Mac, version 5.0.6. ... OE crashes with an Error Type 1. ... I walked him through rebuilding the database and ...
    (microsoft.public.internet.outlookexpress.mac)
  • Message from Hell in OE 5.0.6
    ... Outlook Express for Mac, version 5.0.6. ... OE crashes with an Error Type 1. ... I walked him through rebuilding the database and ...
    (microsoft.public.internet.outlookexpress.mac)
  • why my database cannot add new data
    ... everytime while i try to add new data to my database. ... "Error Type: ... Microsoft JET Database Engine ...
    (microsoft.public.inetserver.iis)