Hi there

I've got this error in my code and am not sure how to correct it:

Microsoft VBScript compilation error '800a03f2'

Expected identifier

/st-sec_dev/secure/Footer/process_edit.asp, line 5


Here is my code:

    SQLUpdate = "UPDATE Footer SET Title = '" & replace(request.form("T"),"'","''") & "' , Detail = '" & replace(request.Form("D"), "'","''") & "' , Copyright = '" & replace(request.Form("C"), "'", "''") & "' WHERE FooterID = '" & request.Form("FooterID") & "'"

thanks in advance

Adam

Could be that SQLUpdate a reserved word is.

Try changing it to strSql:

Dim strSql

strSql = "UPDATE ....."

Set rs<your recordset> = db<your db>.execute(strSql)


if that is not the problem try removing the replace and see if it works. If that is the problem you can do the replacements before you create you statement thus leaving is out.

Hope this could help

Greetz

Tom.

I don't see anything wrong with that statement. Are you sure that's line 5? And is that all on one line? Obviously it wrapped in the post, but I ask only because there are several spaces after the & after "Detail=". Not sure if that's from the wrap or if your code is split to a second line.

Peter

One other thing, the line numbers on these syntax related errors aren't always reliable. It could be something wrong with the preceding line(s).

It's funny because the code I've given is the code I've used elsewhere and it works fine.

Do you know what it means when the error message reads 'Expected Identifier' - I'm not sure what identifier it's looking for. I'm using SQL as my database - do you think it might be SQL related?

thanks Adam

Hi Adam,

Are you sure the code generates a valid SQL Statement? To check this out, use Response.Write(SQLUpdate) to send it to the browser.

Maybe Request.Form("FooterID") does not have a value, so your WHERE clause ends up as WHERE = ''

Are you sure that FooterID is text in the database? The ID makes it sound like a number, in which case you should drop the surrounding apostrophes for the FooterID in the WHERE clause.

HtH,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Fantastic - thanks Imar - worked a treat - it was the FooterID being an int rather than text - Stupid me.

Thanks

Adam