SQL UPDATE with ColdFusion - inserting HTML???

[rockyroad]

Hi,

I need to run a query that will update a DB record with a long, rather complex string of HTML. Here is what I am after ---

<cfset String ="
<div id="tabs"> 
<ul id="tablist"> 
<li><a href="#tabs" onclick="expandcontent('sc1', this)">one</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc2', this)">two</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc3', this)">three</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc4', this)">four</a></li> 
</ul> 
</div>
">

<cfquery name="Update" datasource="#Application.Datasource#">
UPDATE Table
SET Content = #HTMLEditFormat(String)#
		  WHERE ID = 2
</cfquery>

This produces and error in the CFSET.

There must be a relatively easy way to handle this problem?

Any help will be much appreciated!

Thanks

RR

 

[r937]

haven't actually done this myself, but i believe CFSAVECONTENT will do what you want

r937.com | rudy.ca

 

[TamedTech]

Yep i'll second with r on this one.

When dealing with large lumps of datalike that do somthing like this.

<cfsavecontent variable="theHtmlCode">
<div id="tabs"> 
<ul id="tablist"> 
<li><a href="#tabs" onclick="expandcontent('sc1', this)">one</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc2', this)">two</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc3', this)">three</a></li> 
<li><a href="#tabs" onclick="expandcontent('sc4', this)">four</a></li> 
</ul> 
</div>
</cfsavecontent>

<cfquery name="Update" datasource="#Application.Datasource#">
UPDATE Table
SET Content = #HTMLEditFormat(theHtmlCode)#
          WHERE ID = 2
</cfquery>

I've not used savecontent in this way before, but I do use it a hell of a lot for other applications and its very simple.

Rob

 

[TamedTech]

Just out of interest,

Is there really a requirement to save the HTML into the database?

Rob

 

[r937]

Is there really a requirement to save the HTML into the database?

where else would you save it? you would try to assemble it around the salient nuggets of information on the fly? in the above example, these bits are tabs, tablist, expandcontent, sc1/one, sc2/two, sc3/three, sc4/four -- how would you save those pieces of information and still make it easy to deliver html to the browser?


r937.com | rudy.ca

 

[TamedTech]

Well thats a difficult question to ask rudy without knowing the proper application for the HTML,

My personal preferance would be to avoid saving HTMl into the database unless it was an absolute nececity, i've always seen the database as a place for storeing my raw data, any HTMl formatting should be parsed before delivery to the browser.

There are a hole host of possibilities, includes, custom tags and suchlike.

I just struggle to understand the need to save that content into a database when it could sit quite nicely inside a CFM file, and then be wrapped around any content that it needs to be wrapped around.

Rob

 

[r937]

one word: cms

r937.com | rudy.ca

 

[TamedTech]

:-D ... understood!