You don't need to use any of this really.. I insert HTML code all the time in Access database just like that.. The only trick is when you want to edit that content in the form field you will have to replace the < > so it won't cause errors un the form.. Just use something like this :
#replace(replace(variable_to_edit,"<","<","ALL"),">",">","ALL")# Pat -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: April 1, 2005 11:07 To: CF-Talk Subject: HTML Tags entered into Form Fields I've got a client that's insisting on putting things like the below into a form field that should be text only. "Here some text and an image to go with it <IMG src="http://www.mysite.com/images/myPIC.jpg"; alt="My Fat Pic"> and here's the rest of the sentence." I do, despite my objections, need to be able to allow him to do this. MS Access is being used on the site. It's a "memo" field. So what I get confused about is exactly what to use on the add/update queries to get this into the database properly as perhaps I don't have a 100% grasp of HTMLEditFormat and HTMLCodeFormat and cfqueryparam, and then what I need to use again on the output statements so his image shows up properly. Stupid question, yup.. -- ----------- Les Mizzell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201197 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
![http://www.mysite.com/images/myPIC.jpg"](http://www.mysite.com/images/myPIC.jpg"){kind=link}