Skip to main content

ColdFusion

The official community for ColdFusion.

10000+ Posts
r shawnc27927443
r shawnc27927443Participating Frequently
 Questions
T
TransoniqHackerInspiring
 Questions
A
aoitechParticipant
 Questions
S
sorrin_scouseParticipant
 Questions
R
ressifeltParticipating Frequently
 Questions
Vertical Table with dynamic data

I have data structure like this in my MSSQL+----+-------+--------+ | Id | Name | Gender | +----+-------+--------+ | 1 | Fahad | Male | +----+-------+--------+ | 2 | Saad | Male | +----+-------+--------+ | 3 | Asif | Male | +----+-------+--------+But I want to show it like this in my HTML table +--------+-------+------+------+ | | Id | 1 | 2 | 3 | +--------+-------+------+------+ | | Name | Fahad | Saad | Asif | +--------+-------+------+------+ | Gender | Male | Male | Male | +--------+-------+------+------+ |I tried this code but it didn't work probably my data structure is not an array.I m new at coding.Thank you for your helpThis is my code<html> <head> <title>Vertical Sorting</title> </head> <cfquery name = "qMyQuery" datasource = "dsn"> SELECT fields FROM table ORDER BY myField</cfquery&g

3341
C
A
aliciam29605858Inspiring
 Questions
CF2018 Handler Mappings missing in IIS 10

We are in the process of upgrading to ColdFusion 2018 from ColdFusion 2016 on Windows Server 2016, using IIS 10.  CF2018 update 7. Initially, we created a new IIS site and everything worked fine.  Then using the wsconfig tool, we pointed back to our existing IIS two sites that were previously configured with ColdFusion 2016.  *.cfm files wouldn't display.  Further investigation shows the 'Handler Mappings' for *.cfc and *.cfm are missing for the existing two sites.  The mappings do exist for the new IIS site and at the server level.  Not sure why the existing sites didn't 'inherit' those mappings, but they did inherit *.cfml, *.cfr, *.cfswf.  We've tried 'unconfiguring' and reconfiguring using the wsconfig tool several times.  Currently we're using the Universal site connection and there's only one wsconfig/{number} directory. We're going to attempt to add the handlers manually to each existing site, but is there a better way?  This is

27721
A
S
Slange33Participant
 Questions
C
ctreevesInspiring
 Questions
J
JinglesthulaParticipant
 Questions
S
sumedhap9Participant
 Questions
Page number in range format in TOC using DDX

I want to give page number in range format in TOC using DDX. Eg.Expected Output                                                                                                                                   PAGEReport1 Name                     &nb

3241
WolfShade
S
sumedhap9Participant
 Questions
DDX styling issue in header(alignment)

I want to add some header to TOC using DDX. I’m giving sample code format, and running code on CF10.Sample Code<StyleProfile name="headerForTOCPage1Style"><Header><Center>      <StyledText>            <p text-align="right">1st row right aligned</p>            <p text-align="right">2nd row right aligned</p>            <p text-align="left">1st row left aligned</p>            <p text-align="left">2nd row left aligned</p>            <p text-align="left">3rd row left aligned</p>            <p text-align="left">4th row left aligned</p>  &n

2711
S
R
rameshbobbuParticipant
 Questions
E
elizabeth1474Participant
 Questions
switching from cookie storage to client storage

Recently my app was scanned for vulnerabilities and I was flagged for a few - mostly pertaining to the client variables and the assoicated cookies.  Specifically with a cookie being utilized called CFClient_SMITH (let's just say that my application is called SMITH). My hosting site does not allow session variables, so I must use client variables.  Evidently because there is not client storage set, all of the client varaibles are now being stored in the CFClient_SMITH and are available for the picking.  I am getting nailed for Privilege Escalation, User Impersonation, Forced browsing - just to name a few. I was told that by naming a clientstorage value this would eliminate this issue.  The hosting group told me to use a specific clientstorage value (let's say APPLE) and to set the client cookies to no as shown below:<cfapplication name="SMITH"        applicationtimeout="#createTimeSpan(0,4,0,0)#"    

8422
BKBK
Community Expert
E
easterna10239080Participant
 Questions
A
Abdul L KoyappayilInspiring
 Questions
Could not disable HttpOnly flag in browser via CF

In our application, we use J2EE session variables for session management. We recently migrated from ColdFusion 9 to ColdFusion 2018. After migration, the logout functionality is not working. What we found is that, in ColdFusion 2018, the cookie JSESSIONID is not getting cleared from the browser because the HttpOnly flag has been set to true in the browser. We tried to disable this HttpOnly flag in the browser in following ways,By disabling HttpOnly flag and Global Script Protection in CF admin.By modifying the jvm.config via CF admin by adding "-Dcoldfusion.sessioncookie.httponly=false". But this way the HttpOnly flag is still showing as enabled in the browser. Because of this, the client-side script is not able to clear the cookie JSESSIONID and hence logout functionality is not working. Is there any way, in CF2018, to disable the HttpOnly flag in the browser for the cookie JSESSIONID?. Note:In CF9, the HttpOnly flag is disabled in the browser for the coo

9192
EddieLotter
BeRadB
BeRadBInspiring
 Questions
J
jdmryeParticipant
 Questions
J
Jeevan PuluguParticipant
 Questions
G
Grant7127140Inspiring
 Questions
CFEXECUTE to run a Perl script not returning anything

I'm trying something like: <CFEXECUTE NAME="/var/www/cgi-bin/something.pl" TIMEOUT="60"/> but there is no output. This works from the command line and from the browser (running CFHTTP is not a great substitute here). I've read on the forums that this could be a permission issue, but I'm not getting an error. The documentation for CFEXECUTE says "If the effective user of the ColdFusion executing thread does not have permissions to execute the process: a security exception." So why no exception? FYI, I'm running ColdFusion 7 on Linux. I know that CFEXECUTE by itself works because this tag works and returns the date/time: <CFEXECUTE NAME="date" TIMEOUT="60"/> If ColdFusion does need to have different permissions and/or run as a different user in order to run a Perl script, how do you set this up? And is this a big security issue if it's on a public web server? Thanks for any input.

38373
P
B
bbagParticipant
 Questions
C
carl type3Legend
 Questions
A
Anonymous
 Questions
theRealGoofus
theRealGoofusParticipant
 Questions
CFB Debugger with Tomcat And IIS

Trying to get the debugger in CF Builder 2018 to work with my sites that run under IIS. My environment is CF 2018 server configuration, CFB 2018, IIS 10, Win 10 Pro - all running on the same machine. I know I am close because I added the CF web root as a project in Builder, created ...\cfusion\wwwroot\debuggerTest.cfm with a breakpoint and it does work. I tried adding a new local server configuration in builder for port 80 and setting it as the server for the IIS project I want to debug but the breakpoints never fire, I think probably because it's not finding RDS?  Not sure how all that ties together. What is the trick to getting this to work? Also, I am not opposed to moving the cf web root to run under IIS ..  I did try that but couldn't access the administrator. TIA

7041
theRealGoofus
Z
zpm007Participant
 Questions
CF10 vs CF2018 unintentional query cache

I've been working on migrating code from CF10 to CF2018.  I just noticed that in CF2018, my queries are unintentionally using a CF-like query cache.  This is noticable everytime I alter the table structure, my CF2018 session is still referencing a cached version of the query.  This happens even when I try to clear the query cache in CFADMIN, it doesnt affect the results.  Different behavior is produced with CF10 (see below).  If I add a comment to the query, it returns the correct results.  Is there a default query cache option enabled with CF2018? My Code:<cfquery name=”qTest”>select * from users</cfquery><cfdump var=”#qTest#”> CF2018 Results:Displays table columns names correctlyCache is false CF10 Results:Displays table columns names correctlyCache is false Then I rename a column in oracle, and run the same page<cfquery name=”qTest”>select * from users</cfquery><cfdump var=”#qTest”> CF2018&nbs

3811
Charlie Arehart
Community Expert
S
ssailerInspiring
 Questions
Grouping in Report Builder

I have a report with a group header, detail band, and a group footer. How can I keep them from splitting up if they fall between pages? I want to keep all together on one page, even if it means that the page breaks before the group header. I don't want to specify starting a new page break at each group, because that would be a total waste of paper (some groups are only a few lines long). I've looked at the "split allowed" property in the group header band and have set it to false, but that doesn't seem to make any difference. Right now, if I remove all of the grouping, I will have a group header at the bottom of the page with the detail and footer on the next page and it looks dumb and is hard to read. Does anyone have a workaround or an answer to this question?

13901
O

Resources

Community Guidelines Help Center Learn tutorials
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices