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 = NothingHere 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.