Skip to main content

Featured Communities
Announcements
Feature Requests
Inspiration Gallery

Create a post
Login

Home
App communities
ColdFusion

ColdFusion

The official community for ColdFusion.

Announcements
Questions
Bug Reports
Feature Requests

All posts
Questions
Bug reports
Feature requests
Announcements

10000+ Posts

College KidInspiring

extracting data from a comma-deliniated list in a Mysql database

I have a database table entitled meetings. In the meetings table it has the columns named "meeid", "meedate" and "meememberIDs". by using ColdFusion 9 I am able to submit a Standard date in the "meedate" and a comma-delineated list in memberID's who was present from a series of checkboxes from a form. It looks like this :meeid = 2meedate= '2014-06-15"meememberIDs= '3,5,67,78,354, 2345'Now that I have a record of the date and a comma-delineate list of membersID's that came to a meeting, is there a way using stand SQL to extract the memberID's and match numbers to the primary key to another table entitled "personnel"  wherein each number of the comma-delineated meememberIDs column would match the full name  and email to the member of personnel table? example:3 = michael jones - mjones@ptree.com5= chris ebinger - cebinger@ptree.com67 = alfred fox - afox@ptree.com

aghanchiInspiring

Date changed to default value when returned from IIF function

Hi,can anyone please explain why the vDate is being displayed as a decimal number in the following code. It seems that the IIF() functions returns  some default value and not what I setThanks.<cfset vNow = DateFormat(Now(), "mm/dd/yyyy")><cfoutput>  vNow = #vNow# <br /></cfoutput><cfset vDate = iif(true,  vNow, "")><cfoutput>  vDate = #vDate# <br />  Formatted vDate = #DateFormat(vDate,"mm/dd/yyyy")# #TimeFormat(vDate, "hh:mm:ss")#</cfoutput>

webmandman8Inspiring

[Coldfusion 10] convert SQL image data type to pdf file

The data is of image type in my database table. How do I save this data as a pdf file. The data in the table is already pdf type 0x151C240002000000080008001400... I tried select boxid, datapdf from records where datapdf is not null FileWrite("data.pdf", records.datapdf[1]); It did save the file as a pdf, but upon opening the file is said "it is either not a supported file type or because the file has been damaged".

Abdul L KoyappayilInspiring

How to prevent clickjacking issue in CF

I created a cfm template with below contents to test clickjacking issue.<html><head><title>Clickjack test page</title></head><body><p>Website is vulnerable to clickjacking!</p><iframe src="https://abcd.rw.xyz.com/mer/nao/app_v4/" width="500" height="500"></iframe> </body></html>And when I executed this template I was able to click on the "iframe" part. Which indicates that there is a clickjacking issue.Right??. Is there any way to prevent clickjacking issue via CF admin/application code.

Coldfusion-Flex_AnilParticipant

coldfusion cfcs point to flex

I am working on a project where coldfusion(backend) and Flex(front end). I need to point Coldfusion CFCs to Flex application.Can anybody please guide me how to do this.Thanks in advance.Best RegardsAnil

alabamaarchivesParticipant

Is there a tag that will bold text within a pdf file.

If you are performing a search on a collection of pdf files is there a tag that will either highlight or bold the search term within the pdf?

Abdul L KoyappayilInspiring

How to secure CFGLOBALS cookie

To secure CFGLOBALS  cookie I tried the following method as I did for CFID and CFTOKEN . But its not working for CFGLOBALS . Note that this method is working fine for CFID and CFTOKEN.<cfset cf_ssn_cookies = {httponly='true', secure='true'}><cfapplication name="ABCD" clientmanagement="Yes" sessionmanagement="Yes" setclientcookies="Yes"sessioncookie=#cf_ssn_cookies#>Any idea why the HTTPOnly and SECURE flags are not setting up for CFGLOBALS cookie.

KarolusKnown Participant

CF had an area where you could look at and buy software in CF--can't find it

CF had an area where you could look at and buy software in CF--can't find it

dharamParticipant

ColdFusion Builder 3 Express - Debug support

Hi,I have coldfusion 10 and wanted to know if I get ColdFusion Builder 3 trial version. After 60 days, it will get converted to express edition, I wanted to know if debugging will work with express edition.Thanks in advance.Regards,Dharmendra

roughdraftParticipant

The query column CANDIDATE ID appears in cfdump but not cfoutput query=queryname

I've done this a thousand times.  I have a stored proc that returns data.  I give the resultset a name.  I output it with cfoutput query =queryname.  Now it's failing for every column in the query.  But if I do a cfdump with the queryname as a var, I get the data -- with the exact column names in my cfoutput.CF9, SQL Server.

SafariTECHInspiring

Why isn't Report Builder embedding the fonts???

I have a report built with all the label and fields all set to use Calibri and to embed the font. Yet when it shows the text in the rendered PDF file, it is not Calibri (or anything close)All Report Builder help tells me is that when we embed the font, the file size will be bigger - no duh! But it's not even doing it.Creating a report that has specific sizes and looks in mind can't be done unless the font embeds, so how do I fix this??It's really starting to piss me off!SafariTECH

baba_droParticipant

CFGRID. Specify query column in href attribute

Extract from docs (about href attribute for cfgrid tag): URL or name of a query column that contains URLs to hyperlink each grid cell with.This way not work. If i try to specify query column in href attribute like this: href="query_column_name", its did not work. I want to specify a query column, which stores the URL's.Where can I get an example of such a code?

johnmooreParticipant

Maintain sessions during restart on CF10

I'm sure I've missed something. Is there a how to on what needs to be changed to maintain sessions during a restart of the server?I've read Charlie Areharts presentation regarding this and he mentions that an  understanding of Tomcat is helpful but I have found nothing that describes  changes needed in Tomcat with a standard CF deployment.  I added a file name to the Manager element in the XML file for CF Appreciate any help with this.

richardELeachInspiring

Control + O to open a file?

Every other application on my computer uses Control + O to open a file, how can I get CFBuilder to do the same?Thanks,Rich

A

Anonymous

How setup enviroment with Coldfusion 11 express on Windows 7 with a svn repository on a server using Apache?

I am trying to have a installation of Coldfusion 11 express on my Windows 7 machine display a site from a svn repository on a Windows server.  I successfully set up a new project from SVN in the wwwroot directory of the express installation. However when accessing the site from a browser on my machine there are console errors indicating that it cannot find directories.  When I access 127.0.0.1:8500/devsite I get some of the site with no styling due to what the console says is an inability to locate other directories at the same level. So in short:So I have an install of the site at C:\Coldfusion\cfusion\wwwroot\devsite.When I try to access 127.0.0.1:8500/devsite/directory I get the following error.HTTP Status 404 - /devsite/directorytype Status reportmessage /devsite/directorydescription The requested resource is not available.Apache Tomcat/7.0.52How do I fix this?

A

jbrock777Participating Frequently

Coldfusion 10 Enterprise with Tomcat + mod_jk and Apache2 experiencing child process hangups

I am experiencing the most bizarre thing that so far I am unable to reproduce with my own visits to the site.After restarting Apache2 my cacti graphs show that the child processes increment consistently over the course of a day without dropping back down during off hours.  This behavior eventually leaves the website inaccessible...Looking at server-status it is filled with Ws (Sending Reply) and GET calls to my cfm applications :Current Time: Tuesday, 22-Jul-2014 16:33:00 PDTRestart Time: Monday, 21-Jul-2014 22:51:12 PDTParent Server Generation: 0Server uptime: 17 hours 41 minutes 48 secondsTotal accesses: 194844 - Total Traffic: 3.8 GBCPU Usage: u201.55 s34.46 cu0 cs0 - .37% CPU load3.06 requests/sec - 63.2 kB/second - 20.6 kB/request73 requests currently being processed, 4 idle workersWWWWWWWWWWWWWWWWWWWWWWWWWKWWWWWWWWWWWWWWWWWCWWWWW_WWWWWWCWWW_WWW _WKW...KWW.W_KWW....W........................................... ................................................................ ..

rockhikerInspiring

cfrgrid will not edit

When I attempt to edit my grid the following error is returned. error invoking CFC /design /Regstration.cfc : The PAGE argument passed to the getData function is not of type numeric.My getData function: code:    <cffunction name="getData" access="remote" returntype="struct">        <cfargument name="page" type="numeric" required="yes">        <cfargument name="pageSize" type="numeric" required="yes">        <cfargument name="gridsortcolumn" type="string" required="yes">        <cfargument name="gridsortdirection" type="string" required="yes">       <cfquery name="rdc14" datasource="cfrdc">  select * FROM rdc2014   <cfif ARGUMENTS.gridsortcolumn NEQ "" and ARGUMENTS.gridsortdirection NEQ "">     &nbs

erose68Participant

Unresponsive ColdFusion 11 install on Macintosh 10.9.4

I have a MacBook Pro running Macintosh OS 10.9.4.  I am using Java version 1.6.0_65I just ran the Developer installer for Coldfusion 11.I started the service using sudo ./coldfusion start and saw the following messages:Starting ColdFusion 11 server ...The ColdFusion 11 server is starting up and will be available shortly.======================================================================ColdFusion 11 server has been started.ColdFusion 11 will write logs to /Applications/CF11/cfusion/bin/../logs/coldfusion-out.logWhen I tried to navigate to 127.0.0.1:8501/CFIDE/administrator/index.cfm the page loads blank.I checked the error log and it gives me a long list of problems starting with a complaint about The APR based Apache Tomcat Native library:Sep 11, 2014 4:04:10 PM org.apache.catalina.core.AprLifecycleListener initINFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /Users/ericrose/Li

iccsiInspiring

Specify Excel sheet name

I have a report and use Excel as its format.The Excel sheet always name ColdFusionReport.I would like to know are there any way to customize the Excel sheet name and it is possible to have the report pages become sheet 1, sheet 2.... instead of all pages on the first sheet.Your help and information is great appreciated,Regards,Iccsi, 

iccsiInspiring

sub report size at design time

I noticed that the size of sub report is limited on the main report at design time.For example, if I have sub report hight at 1" then the maximum height will be 1" on the report at run time.The design area has limit too, so if this is the case, my report design area is limited to my report.Please let me know if I am wrong, or any work around for this,Your help and information is great appreciated,Regards,Iccsi,

A

Anonymous

CF10 is evaluating strings with comma's as complex types (Array), formerly they were just Strings

Coldfusion 10's behaviour appears to have changed in the evaluation of strings with commas.Example:FORM.IDS = 123456, 654321, 789101  (Form Submission)<cfset fieldname="IDS" /><cfset test1 = FORM[fieldname] /><cfset test2 = evalute("FORM.#fieldname#") />In Coldfusion 9 the value of test1 and test2 is reported as "123456, 654321, 789101".In Coldfusion 10 the value of test1 and test2 is reported as an array. "Array (3)".Is this expected behaviour?  This is jacking up an application we are trying to upgrade and did not expect this one.  Any help will be much appreciated.CheersLee 

KomputerMan_com-L7dcfeInspiring

tobase64 HTTP-Redirect binding

Still struggling with encrypting a SAML request to be sent to an ADFS server.  Turns out there are multiple ways to encode strings.  By default the utf-8 encrption option with the toBase64 tag uses HTTP-Post binding.  I need it my script to use HTTP-REDIRECT binding.  The code I'm using is this:<CFSAVECONTENT VARIABLE = "samlAssertionXML"><samlp:AuthnRequest IssueInstant="2014-09-16T19:24:18.343Z" ID="_kdls_testing_application_for_single_sign_on" Version="2.0" xmlns:samlp="urn:oasis:names:tc:SAML:2.0:protocol"><saml:Issuer xmlns:saml="urn:oasis:names:tc:SAML:2.0:assertion">https://localhost/sde</saml:Issuer><samlp:NameIDPolicy AllowCreate="true"/></samlp:AuthnRequest></cfsavecontent><cfscript>  samlAssertionXML = toBase64(toString(TRIM(samlAssertionXML)), "utf-8");</cfscript>When I take the string that gets returned by the toBase64 tag and use the SAML 2.0 Debugger the string gets de-crypted correctly. 

Homestar9Inspiring

How to turn off automatic variable code suggest for a single page?

Does anyone know how to turn off the code assist feature where CFBuilder tries to assist you by listing all the variables on the page?  I have a CFC with over 3000 lines and it causes CFBuilder to hang/freeze like you wouldn't believe.  I'd like to turn off this feature for large files (or at least see if I can tune the feature to be smarter about what variables it suggests).Does anyone know how to disable this feature on a specific template or turn this feature off altogether?  Note: I do want to keep the tag attribute suggestion if possible.

iccsiInspiring

create Report charting data series

I want to add chart to my report and add a chart control on my report.I double click on the chart and edit chart type as line chart and edit chart series.I use Data from a fix of values and choose the field name from the drop down from my data source field name, but I got following error message.An error occurred while trying to create a chart on this report. Ensure that the column(s) selected for the chart series are numerical values. Error: The chart could not be generated due to an error in the graphing engine. I tried to select from data from query. I have to build my query from report.I use a stored procedure for this report, so I need advance to build my query, once I use the stored procedure then Report Builder warn me that it will erase all fields to recreate fileds.I would like to know what is the right procedure to create chart for the report.Your help and information is great appreciated,Regards,Iccsi

WestSideInspiring

Error using CFWebsocket tag in ColdFusion 10

Hi,I'm using CF 10 and IIS.I'm using the cfwebsocket tag in ColdFusion 10 and it works the majority of the time, but in Firefox I'm using Firebug and I get these errors randomly sometimes.  I'm not sure why though.  I setup a basic page where I enter text into an HTML input field.  When you press enter, any subscribed clients should receive the message.  7/10 times or so it works fine, but then sometimes the message won't come through and I will get the below errors in Firebug.SyntaxError: parseJSONThe connection to ws://127.0.0.1:8575/cfusion/cfusion was interrupted while the page was loading.this.wsConnection=new WebSocket(_2); Anyone seen this error message in Firefox?

Show more posts

Firefly Community Gallery

Remix with Firefly Community Gallery

Thousands of free creations to fall in love with and remix in Firefly.

Powered by Gainsight

Terms & Conditions Accessibility statement

Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information

Sign up

Already have an account? Login

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in

Sign in to Adobe Community

No account yet? Create an account

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview