Hi all,

I'm having a bit of a problem on my ASP Page. When I go to update my VFP 7 through my ASP page, If I don't use any

tags I don't recieve a error but If I do, I receive the below error.

Microsoft OLE DB Provider for Visual FoxPro (0x80040E14)
Command contains unrecognized phrase/keyword.

Here Is A Print Out Of My SQL String

SQL = "UPDATE Pages SET PageTitle = 'Company Profile', PageContent = '<P>This Is A <STRONG>Test</STRONG>.</P><P>This Is A Test</P>', PageName = 'profile.asp' WHERE PageID = 3"

Here Is my SQL String before it is executed.

SQL = "UPDATE Pages SET PageTitle = '" & Request.form("pagetitle") & "', PageContent = '" & Replace(Request.Form("myMSV"), "'", "'") & "', PageName = '" & Request.Form("pagename") & "' WHERE PageID = " & Request.Form("pageid") & ""

I don't know what is wrong with this.

Any help is greatly appreciated.
Kind Regards,
Tarran Walker
tarran.walker@reliez.com