update & insert operation, asp, vbscript, Ms Access

Dilruba · #1 (**permalink**) 11-12-07, 11:06

I have used the following codes:

Code:

connectionString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\progam files\mail.mdb"

ConnectionDb = connectionString

‘ execute the update

Set MM_editCmd = Server.CreateObject("ADODB.Command")

MM_editCmd.ActiveConnection = MM_editConnection

MM_editCmd.CommandText = sql

MM_editCmd.Execute

MM_editCmd.ActiveConnection.Close

[/code]

Teddy · #2 (**permalink**) 11-12-07, 12:31

Care to be a little more specific than "not working"?

gvee · #3 (**permalink**) 11-12-07, 12:39

At a guess, you're leaving an extra comma on the end of your SQL statement...
E.g.

Code:

UPDATE mytable
SET   field1 = '1', field2 = '2',
WHERE 1 = 1

Internet Services

Web Development

Digital Marketing

Consumer Tech