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