Trouble executing SQL statement

turbo_rabbit · July 1st, 2005, 03:12 PM

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:
(this it all the code on the 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
   %>

   <% Response.Write(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.

om_prakash · July 3rd, 2005, 02:41 AM

Please modify
AddJob.Execute strsql
as
AddJob = MM_nafpinc_DSN_STRING.Execute(strsql)

Om Prakash

turbo_rabbit · July 6th, 2005, 09:11 AM

I Tried your suggestion and this was the error that I received:

   Microsoft JScript runtime error '800a01b6'

   Object doesn't support this property or method

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

om_prakash · July 6th, 2005, 09:27 AM

Hi,

Can you provide the details, to which line u are getting error:

Any special reason to use javascript as server side..?

Om Prakash

mkayombo · July 6th, 2005, 09:49 AM

correct me if wrong,

The date value should be enclosed with hash
(#7/1/2005#,'Test','test')

ChrisScott · July 6th, 2005, 10:13 AM

You are running an insert query and therefore do not need a recordset object, these are used when getting records out of a db.
You need to create a connection object and then use the Execute() method of that.
The expected ";" error is probably the line AddJob.Execute strsql - in javascript you need to surround method parameters with parenthesis e.g. AddJob.Execute(strsql)
Something like the following should work...

Code:

var conn = Server.CreateObject("ADODB.Connection");
conn.Open(MM_nafpinc_DSN_STRING);
var strsql ="INSERT INTO members (DateAdd,JobTitle,JobDescription) VALUES ('7/1/2005','Test','test');";
conn.Execute(strsql);

Like mkayombo says, you may need to surround the date with hash signs, but this is only applicable to some databases e.g. Access

HTH,

Chris

turbo_rabbit · July 6th, 2005, 01:30 PM

Chris,

That worked perfectly. Thanks everybody for all your help.