SQL error any help really appreciated!

abrewitt · #1 (**permalink**) Jun 16th, 2006, 11:35

I have a SQL error I cannot see and was wondering if u can see it?;

' build the SQL UPDATE "command string"
strCmdTxtMem="UPDATE link SET link_text='" & request("linkText") & "',"
strCmdTxtMem=strCmdTxtMem & " link_url='" & request("linkUrl") & "',"
strCmdTxtMem=strCmdTxtMem & " link_title='" & request("linkTitle") & "',"
strCmdTxtMem=strCmdTxtMem & " WHERE link_id=" & request("linkId")

I outptted the sql and get this error message;

UPDATE link SET link_text='Blue Anvil', link_url='http://www.blue-anvil.com/', link_title='go to blue anvil design', WHERE link_id=4
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/editmember_process_basic.asp, line 31

i really appreciate any help, Anthony

Rob · #2 (**permalink**) Jun 16th, 2006, 11:50

remove the comma before the WHERE Clause

abrewitt · #3 (**permalink**) Jun 16th, 2006, 11:57

Thats great Rob! thanks!

you can never see ur own!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
friendly criticism would be much appreciated :D	bonnit	Free Web Site Critique	2	Apr 10th, 2008 10:46
SEO tips appreciated !	alexgeek	Search Engine Optimization (SEO)	6	Sep 6th, 2007 17:31
Hi All - Advice Appreciated!	xzfzn	Introduce Yourself	4	Feb 19th, 2007 16:59
Any help or guidence appreciated	tiedtothewind	Starting Out	4	Feb 7th, 2007 17:59
another sql error any help appreciated	abrewitt	Databases	2	Jun 21st, 2006 09:29

		Webforumz.com > Main Forums > Program Your Website > Databases
SQL error any help really appreciated!