As part of an install routine that populates a db with default values, I need to load
html code/text into a db via manual entry from a CFQUERY.
***The value is not the contents of a form var, but is hardcoded into a CF template.***
Here's a sample:
<P>
<SPAN class=Smaller style="COLOR: #800000">
<STRONG>What's the deal?</STRONG>
</SPAN>
</P>
This includes line breaks, quotes (double and single), pound signs and brackets.
So far I can't come up with a SQL query that works. Have tried plugging everything
into a variable, into a cfqueryparam... no joy. I either eat it on a quote mark or a
colon.
How can this be done? I'm probably missing something stupid.
---------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc., www.mysecretbase.com
---------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
