DON'T use HTMLEditFormat() to insert in the database!!!!!!!!! Just store the quotes as is in the database. Use HTMLEditFormat() for display. This way you will not have the double encoding and you can even use the data in non HTML.
If you insist on using html code in the db, you could use a UDF to decode it first and then encode it again with HTMLEditformat(). I wouldn't recommend this though. http://www.cflib.org/udf.cfm?ID=664 Pascal PS You can also get rid of Evluate() by scoping your variable and using array notation! > -----Original Message----- > From: Les Mizzell [mailto:[EMAIL PROTECTED] > Sent: 27 October 2004 20:53 > To: CF-Talk > Subject: Double Quotes in Database > > I've been handed a SQL Database that has fields with lots of > measurements and are stuff like: "32" (12"-32" adjustable) > > In building admin pages to update these tables. I've got no problem if I > am adding from scratch: > > MOD_DESC = '#HTMLEditFormat(evaluate("MOD_DESC_#myIDX#"))#', > > > It's getting the current data to display correctly in the text input > boxes that's giving me a little bit of trouble. > > <input name="MOD_DESC" type="text" value="#AOS_145OP.MOD_DESC#"> > > So, I need this to display this correctly: "32" (12"-32" adjustable) > whether the information in the database is: > "32" (12"-32" adjustable) > - or - > 32" (12"-32" adjustable) > > Suggestions? > > -- > Les Mizzell > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Sams Teach Yourself Regular Expressions in 10 Minutes by Ben Forta http://www.houseoffusion.com/banners/view.cfm?bannerid=40 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182789 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
