RE: Embedding CF in CMS Content

2015-04-17 Thread Robert Harrison
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

Re: Embedding CF in CMS Content

2015-04-17 Thread Akos Fortagh
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!

Re: Embedding CF in CMS Content

2015-04-17 Thread Jon Clausen
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

Re: Embedding CF in CMS Content

2015-04-17 Thread Russ Michaels
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

Embedding CF in CMS Content

2015-04-17 Thread Robert Harrison
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

SQL Server and Nulls

2015-04-17 Thread 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

Re: SQL Server and Nulls

2015-04-17 Thread John M Bliss
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

RE: SQL Server and Nulls

2015-04-17 Thread DURETTE, STEVEN J
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