I an very new to ASP (this week to be exact, been doing Coldfusion), and so far I have liked coding with it. Anyway here is my problem.

I am tring to do an insert statement with the following code:

    <%
    var AddJob = Server.CreateObject("ADODB.Recordset");
    AddJob.ActiveConnection = MM_nafpinc_DSN_STRING;
    strsql ="INSERT INTO members (DateAdd,JobTitle,JobDescription) VALUES ('7/1/2005','Test','test')"
    AddJob.Execute strsql
    %>

Here is the error that is generated when I try to load the page:

    Microsoft JScript compilation error '800a03ec'

    Expected ';'

    /nafpinc/_admin/employment-act.asp, line 15

    AddJob.Execute strsql

I have tried putting in the ';', but I still receive the same error message.

You have a JavaScript error somewhere in your script. It is not referring to your Insert.

Like I said I am new so if you could point out my error I would appreiate it. I don't see where there can be an error in my script when other than the connection string that is the only code on the page.

The following is the code for the entire page:

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>


<%
var AddJob = Server.CreateObject("ADODB.Recordset");
AddJob.ActiveConnection = MM_nafpinc_DSN_STRING;
strsql ="INSERT INTO members (DateAdd,JobTitle,JobDescription) VALUES ('7/1/2005','Test','test')"

AddJob.Execute strsql
//qDeleteJob.CursorType = 0;
//qDeleteJob.CursorLocation = 2;
//qDeleteJob.LockType = 1;
//**leave comment** qDeleteJob.Open();
//var qDeleteJob = 0;
%>

<% Response.Write(strsql) %>

There is nothing wrong with the "nafpinc_DSN.asp" file. It is used on all my other pages and works fine.

Seems you are using classic ASP code. This is .NET forum. Are you creating a .asp or .aspx page?

Actually if you look at the title of this forum says "ASP and ASP.NET".

Anyways.. I am creating a .asp page.

I See my bad I am in the ASPX section. Can you still help?

I am more familiar with .NET. Perhaps you will get a better and quicker response from on of the ASP forums.

You are missing ; on the end of the following statements.

strsql ="INSERT INTO members (DateAdd,JobTitle,JobDescription) VALUES ('7/1/2005','Test','test')"
AddJob.Execute strsql

In my original post I said I tried that and still got the same error message.

Ok, my bad.

The compiler is probably seeing "AddJob.Execute" without the () and expecting a following ";". Perhaps then the Execute method needs ( )?

AddJob.Execute(strsql);

-Peter