Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ADO, ASP, VFP ODBC
Message
De
08/10/1999 11:14:33
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
ADO, ASP, VFP ODBC
Divers
Thread ID:
00274247
Message ID:
00274247
Vues:
68
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform