[mitchel]

Hi:

I have used the Insert Command a zillion times in DW MX 2004 but in DW CS3 I cannot get it to work even with the most simplest attempts.

I keep geeting the error:

Microsoft VBScript compilation error '800a0408'

Invalid character
/comp/compinsert.asp, line 4 Dim cmdInsert__@@varName@@

*************************
CODE<%
Dim cmdInsert__@@varName@@
cmdInsert__@@varName@@ = "@@defaultValue@@"
If (@@runtimeValue@@ <> "") Then
cmdInsert__@@varName@@ = @@runtimeValue@@
End If
%>
<%Set cmdInsert = Server.CreateObject ("ADODB.Command")
cmdInsert.ActiveConnection = MM_xxxxxxxxxxxx_STRING
cmdInsert.CommandText = "INSERT INTO lookup_company (company_name) VALUES ('test' ) "
cmdInsert.CommandType = 1
cmdInsert.CommandTimeout = 0
cmdInsert.Prepared = true
cmdInsert.Execute()
%>
*************************

Does anyone know how to fix this?Thanks!Mitch