Problems trying to execute an update

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Problems trying to execute an update

Logged in as: Guest

arrSession:exec spGetSession 2,3,35048

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> ASP >> Problems trying to execute an update
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Problems trying to execute an update - 6/1/2006 4:59:56 AM

imustbeanonymous

Posts: 4
Score: 0
Joined: 5/31/2006
Status: offline

I hate ASP. I also hate access but the noob who worked here before me and my predecessor decided that ASP 3.0 and Access were the best things that ever happend to the internet. I'm a PHP developer and I can't handle BASIC style syntax.

This:

Doesn't work.

This:

Microsoft JET Database Engine (0x80040E14)
Expected query name after EXECUTE.

Is the error.

Now, I'm not always the fastest or brightest when it comes to scripting or programming but I know there is a query name after execute. I see it, right there, it's named 'sql'.
I know that the error reporting for ASP isn't the best or most accurate, and I also know that error number can mean there is something wrong with your query but I don't see what it is.
If you do, I would appreciate the help.

Thanksss.

Post #: 1

RE: Problems trying to execute an update - 6/1/2006 5:13:46 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

Does this work?

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to imustbeanonymous)

Post #: 2

RE: Problems trying to execute an update - 6/1/2006 7:16:33 AM

imustbeanonymous

Posts: 4
Score: 0
Joined: 5/31/2006
Status: offline

It doesn't.

I am slowly starting to remember things and that is a good guess though.

(in reply to ebgreen)

Post #: 3

RE: Problems trying to execute an update - 6/1/2006 7:22:31 AM

ebgreen

Posts: 4613
Score: 31
Joined: 7/12/2005
Status: offline

Same error with the code I posted?

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to imustbeanonymous)