Is the database value getting cut off? Or does it appear to be cut off on the outputted page. Try view the source and makesure the values just aren't part of the source.
....................... Ben Nadel www.bennadel.com -----Original Message----- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Friday, April 28, 2006 2:45 PM To: CF-Talk Subject: Re: Double Quotes and other crap insert problem - cfqueryparam? Ben Nadel wrote: > Yes, CFQueryParam is the best method (in my opinion). Hmm - that's still not doing it. It's getting cut off right after the "href=" > Client enters all of the following into a text area (mytext): > > To go somewhere click the image: <a href="somewhere.cfm"><img > src="images/something.gif" /></a>. Bob says, "This is the best deal > you'll every see!". > > This mess needs to get inserted into the database and then output > correctly on whatever dynamic page it goes to. > > The double quotes and other html stuff gives me fits. > > So, what's BEST PRACTICE to do this? > > <CFQUERYPARAM > CFSQLTYPE="CF_SQL_VARCHAR" > VALUE="#form.mytext#"> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239076 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
