I've looked at this and don't see a problem. Can you E-mail me your asp pages and dbf or a zapped ver of it if it has a lot of data. I want to try on my server and see what I can come up with.

jeff@truegeeks.com

Jeff

>I'll ask this again in hopes someone can help me with this, or at least point to a better place to look for an answer.
>
>Hi all. Here is my setup.
>I am using VFP's ODBC Driver thru asp/ado to connect to a VFP dbf sitting on my harddrive. Basically there are 4 fields in the table, one of which is a memo.. I am trying to store raw html in the memo but I get an "Command contains unrecognized phrase/keyword" on the insert statement.. if I don't try to put any html into the memo it works fine.. I'm not sure how to get around this, but I know it's possible. HELP.
>Here is the code from postit.asp
>

>posterme=replace(request.form("poster"),"'","''")
>titleme=replace(request.form("title"),"'","''")
>postme=Server.HTMLEncode(request.form("post"))
>spostme=replace(request.form("post"),"'","''")
>set dbobj = server.createobject("ADODB.Connection")
>dbobj.open "DATABASE=NEWS;FILEDSN=VFPSYS;"
>datet = date() & " " & time() & " ET"
>insstr = "INSERT INTO news (news, poster, title, datetime) VALUES ('"&postme&"','"&posterme&"','"&titleme&"', '"&datet&"')"
>set rsProg = dbobj.execute(insstr)
>dbobj.close
>set dbobj = Nothing
>

>
>Here is the actual INSERT statement
>
>

>INSERT INTO news (news, poster, title, datetime) VALUES ('This is a test.. Test 2 w/ html. Woo Testing','Joe','Test With Dates and HTML', '10/7/1999 11:30:47 AM ET')
>

>If anyone can give me any ideas I would sure appreciate it.
>-Joe Silver