October 29th, 2003, 01:12 PM
|
|
Registered User
|
|
Join Date: Aug 2003
Posts: 9
Time spent in forums: 3 h 10 m 37 sec
Reputation Power: 0
|
|
|
HTMLEncode problem
I am creating an application for work and have run into a problem.
I have a form that has a comments field in it. When I create a new entry in the DB (Oracle BTW), I just use this:
Code:
Server.HTMLEncode("pmcomments")
This works great for any special characters that people may use.
The problem is when I go to edit this entry and try to update the comments field. Using HTMLEncode does not seem to work when I'm doing an "UPDATE" to the DB instead of an "INSERT". I get this error:
Quote:
Microsoft OLE DB Provider for Oracle (0x80040E14)
ORA-00933: SQL command not properly ended
/COMM_CENTER/mmf/mmf_save_1.asp, line 71
|
Which obviously means it's not converting the string that I'm attempting to edit in the DB.
Any ideas?
Thanks in advance!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
