Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO, ASP, VFP ODBC
Message
From
08/10/1999 11:14:33
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ADO, ASP, VFP ODBC
Miscellaneous
Thread ID:
00274247
Message ID:
00274247
Views:
69
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.<br> <font size=7>Woo</font><br> 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
Next
Reply
Map
View

Click here to load this message in the networking platform