Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	ASP Help
From:	Cesar Mendoza <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Thu, 4 Jan 2001 15:40:30 -0500
Content-Type:	text/plain
Parts/Attachments:	text/plain (32 lines)

Hi, I have a problem trying to insert a new record to my database using the
SQL INSERT, could somebody help me? This is the code (in VBScript):

<%
dim myConnection
dim myQuery

myQuery = "INSERT INTO Temp_Table VALUES ('test', 'test')"
set myConnection = server.CreateObject ("ADODB.Connection")
myConnection.Open "Temp_DB"
myConnection.Execute (myQuery)
myConnection.Close
%>

Everytime I try it I get an error message that says:

   "Operation must use an updateable query."

and points to this line:

   myConnection.Execute (myQuery)

PLEASE Help Me!

Thanks in advance.

Cesar Mendoza.

              The NOSPIN Group is now offering Free PC Tech
                     support at our newest website:
                          http://freepctech.com

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG