html inserted via SQL directly from template?

2002-10-09 Thread Matt Robertson

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:



What's the deal?



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



Re: html inserted via SQL directly from template?

2002-10-10 Thread Jochem van Dieten




What's the deal?





INSERT INTO table (field)
VALUES (


Jochem

~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm