Or use htmleditformat() which would do the same thing.... At 12:33 PM 4/1/2005, you wrote: >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:201217 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=11502.10531.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}