Thanks. I found another way around it. Just dealing with something that
was already put together strangely, where some embedded functional code into
a CMS WYSIWYG editor.
Robert Harrison
Full Stack Developer
AIMG
rharri...@aimg.com
Main Office: 704-321-1234 ext.118
Direct Line: 516-302-4345
We needed to do something similar and we actually wrote the content to a file
and included that.
It worked perfectly.
~|
Order the Adobe Coldfusion Anthology now!
No, CF wonât evaluate the output of a database query - nor should it. Â That
would pose all sorts of security and stability concerns. Â A better solution is
to incorporate the dynamic content you want in to your CMS as a module. Â Most
CMS systems have a method for including custom modular
when you need to put dynamic content then you should never allow CODE,
instead use macros
e.g.
[include:filename]
you then parse the content before displaying to process the macros.
read this article for more info:
http://www.michaels.me.uk/post.cfm/content-management-processing-dynamic-content
I have a situation where I need to embed a CFINCLUDE in a CMS data field
which is output. How do I get the include to render? Can I even do that?
Example is like cfoutput#mydata#/cfoutput . the include is in the mydata
output. Can I evaluate or something?
Thanks
Robert Harrison
In an update query, to a tinyint field which allows nulls, I have the update
dbfield=#mydatefield#
If mydatefield has no value, sql is throwing an error. The field allows
nulls. I've never had to say if then NULL before. What the heck?
Robert Harrison
Full Stack Developer
AIMG
dbfield = cfqueryparam cfsqltype=cf_sql_tinyint value=#mydatefield#
null=#yesnoformat(mydatefield is '')#
On Fri, Apr 17, 2015 at 3:58 PM, Robert Harrison rharri...@aimg.com wrote:
In an update query, to a tinyint field which allows nulls, I have the
update
dbfield=#mydatefield#
If
Dbfield=cfqueryparam value=#mydatefield# cfsqltype=CF_SQL_TINYINT
null=#not len(mydatefield)# /
Steve
-Original Message-
From: Robert Harrison [mailto:rharri...@aimg.com]
Sent: Friday, April 17, 2015 3:58 PM
To: cf-talk
Subject: SQL Server and Nulls
In an update query, to a tinyint
8 matches
Mail list logo