Forums

This topic is locked

Problem with update record

Posted 13 Aug 2002 10:53:58
1
has voted
13 Aug 2002 10:53:58 Nathan Pollux posted:
i've got a problem with the update of a record
on my local machine it works perfectly but online i get
"Microsoft OLE DB Provider for ODBC Drivers error '80040e14' "
saying there's a syntax error in my update instruction line 111

red is line 111

If (Not MM_abortEdit) Then
' execute the update
Set MM_editCmd = Server.CreateObject("ADODB.Command"
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
<font color=red>MM_editCmd.Execute</font id=red>
MM_editCmd.ActiveConnection.Close

what did i do wrong ?

i'd like to post my source but the forum doesn't accept (too long)
so i put it in a txt file on server : www.sarum.be/testing/ecc.txt

i'm quite desperate 'cause it's kind'a urgent
anyone who can help ?
i'd be very gratefull.
thx

I scream in dev/null so nobody can hear me being frustrated.

Replies

Replied 13 Aug 2002 17:20:47
13 Aug 2002 17:20:47 Jeremy Conn replied:
Have you checked to make sure your permissions are set correctly for that folder?

(DWMX|IIS5|WXP|ASP/VB)
*Connman21*
www.conncreativemedia.com
Replied 13 Aug 2002 17:25:49
13 Aug 2002 17:25:49 Nathan Pollux replied:
could it be
because adding a new record and deleting a record works fine
Replied 14 Aug 2002 08:22:40
14 Aug 2002 08:22:40 Nathan Pollux replied:
everything is set correctly
i don't understand because i van add and delete record without a problem

Reply to this topic