Go Back   Dreamweaver Club Forums > Hand Coders Forum > ASP
Register FAQ Members List Search Today's Posts Mark Forums Read

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 05-01-2009, 08:20 PM   #1
Join Date: May 2009
Posts: 1
Default Command | Insert = error...


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@@

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

Does anyone know how to fix this?Thanks!Mitch
mitchel is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT. The time now is 05:49 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2015, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com