ColdFusion Language Questions

creating a file manager in coldfusion and having some troubling viewing the directory contents

Here is the code I am using

<div class="col-sm-3 sidenav">
<div class="panel panel-default">
    <div class="panel-heading">Folders</div>
    <div class="panel-body">
    	<div id="drivestree"></div>
    </div>
</div>

Open in new window

jqueryFile.cfm

<cfset drives = {}>
<cfset alphabet = "abcdefghijklmnopqrstuvwxyz">

<cfloop from="1" to="#len(alphabet)#" index="i">
	<cftry>
		<cfset thisdrive = mid(alphabet,i,1)>
		<cfset checkDrive = Application.fileManager.manager.getDirectories(path=thisdrive & ":\",addHasDirs=true,hidehidden=true)>
        <cfif checkDrive.directories.recordcount>
            <cfset drives[thisdrive] = checkDrive>
        </cfif>
		<cfcatch><!--- failed Silently ---></cfcatch>
	</cftry>
</cfloop>

<ul class="jqueryFileTree"<!---  style="display: none;" --->>
    <cfif not structisempty(drives)>
        <cfset drivelist = listsort(structkeylist(drives),"text","asc")>
        <cfoutput>
        <cfloop list="#drivelist#" item="d">
            <cftry> 
                <cfif drives[d].directories.recordcount> 
                    <li class="directory collapsed"><a href="##" rel="#URLDecode(d)#">#d#:\</a>
                    <ul>
                    <cfloop query="drives[d].directories">
                        <cfif type eq "dir">
                            <li class="directory collapsed"><a href="##" rel="#URLDecode(name)#/">#name#</a></li>

Open in new window

…

2 Comments

Python 3 Fundamentals

LVL 13

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

We are trying to integrate ABBYY SDK in our application.

ABBYY SDK support given javascript test code to convert image or non-searchable pdfs to Searchable PDFs. In the test code the file name and path were hardcoded. And the test code works good.

We modified the test code and give option to upload files. So now the upload file names are not hardcoded. When uploading the non-searchable pdfs in the modified code, it is NOT converting to seachable pdfs. But when uploading images, it is converting into searchable pdfs.

If anybody integrated ABBYY SDK in ColdFusion, please do reply.

Thanks for your assistance.

1 Comment

Here is our ColdFusion code for executing run.cmd programmatically:
<cfexecute timeout=1000
name = "C:\Windows\System32\cmd.exe"
arguments = "C:\ProgramData\ABBYY\SDK\12\""FineReader Engine""\Samples\Java\Hello\run.cmd"
outputFile = "C:\Temp\output.txt" >
</cfexecute>

Error Message:
The requested action did not complete in a timely manner. Timeout period expired without completion of C:\Windows\System32\cmd.exe.

When trying directly from command line, I still get the errors.

So in the command line, I entered up to the last folder cd C:\ProgramData\ABBYY\SDK\12\'FineReader Engine'\Samples\Java\Hello and run 'run.cmd' separately . So it runs correctly without any error.

So, how do I do the same in Coldfusion program ?

4 Comments

LVL 19

Question by

erikTsomik

2019-07-08

Placing charts on the tooltip

I am trying to place charts in tooltips using google charts. And got stock . Placing charts in the tooltip from this page

https://developers.google.com/chart/interactive/docs/customizing_tooltip_content#placing-charts-in-tooltips

I am using this example but but instead of showing linear graph I need to to show a bar graph. The original graph is the linear graph

Thank you

	google.charts.load('current', {'packages':['corechart']});
    google.charts.setOnLoadCallback(drawTooltipCharts);
      
      
	
	var primaryData = [
		
		<cfoutput query="qGetClassesPerMonth">
			["#sYearFull#", '#sessionKey#']	,
		</cfoutput>	
       
      ];
      
      var tooltipData = [
     
        
        <cfoutput query="qGetClassesPerMonthPerToolTip">
        	['#sessionkey#','#zipcode#','#zCnt#']	,
        </cfoutput>	
      
      ];
      
        var tooltipOptions = {
        title: 'U.S. Viewership Over The Last 10 Years (in millions)',
        legend: 'none'
      };
      
      
      
      function drawTooltipCharts() {

        var data = new google.visualization.arrayToDataTable(tooltipData);
        var view = new google.visualization.DataView(data);

        // For each row of primary data, draw a chart of its tooltip data.
        for (var i = 0; i < primaryData.length; i++) {

          // Set the view for each event's data
          view.setColumns([0, i+1]);

          var hiddenDiv =

Open in new window

…

8 Comments

What is required so that a Youtube video will play on a website page? I have a website and on one page the Youtube video plays fine but on another page the same video does not play.

On the page that works when I hover over the play button it turns from black to red.

On the page the doesn't work the play button doesn't change its appearance when I hover over it.

When I press play on the page that doesn't work nothing happens.

My website is built using Coldfusion

12 Comments

Does any one have some sample code for a BIND in coldfusion?
I'm trying to have my DB update with pulling down an option in a form without a submit button

3 Comments

Coldfusion 2016

Why do binds not work?

I have 2 Select boxes, and I'm trying bind the contents of 1 input to the value to another input and it will not work in CF 2016.

It used to do this asynchronously in CF 2010.

Can anyone assist

1 Comment

In ColdFusion 2016, when trying to index a large file contains more than 100000 characters, I getting the below error.

"org.apache.tika.sax.WriteOutContentHandler$WriteLimitReachedException: Your document contained more than 100000 characters, and so your requested limit has been reached. To receive the full text of the document, increase your limit. (Text up to the limit is however available)."

I tried increasing the maxFieldLength <maxFieldLength>10000000</maxFieldLength> in the file solrConfig.xml. But the issue is not resolved.

Where do I increase the limit from 100000 to 10000000 ?

Code:

<cfindex 
        action="update" 
        type="file" 
        collection="#collection_name#" 
        recurse="yes" 
        key="#key#" 
        urlpath="#urlpath#" 
        status = "insert"></cfindex>
 <cfdump var="#insert#">

Open in new window

ColdFusion Language

2 Comments

the following code works when tested independently,

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <script src="https://cdn.jsdelivr.net/npm/chart.js@2.8.0/dist/Chart.min.js"></script>
    <title>Document</title>
</head>
<body>
    <canvas id="myChart" width="300" height="300"></canvas>
    <script>
    var ctx = document.getElementById('myChart').getContext('2d');
// Chart declaration:
var myChart = new Chart(ctx, {
  type: 'line',
  title:{
			fontFamily: "'-apple-system','BlinkMacSystemFont','Segoe UI','Roboto','Helvetica Neue','Arial','Noto Sans','sans-serif','Apple Color Emoji','Segoe UI Emoji','Segoe UI Symbol','Noto Color Emoji'",
			text: "Last 10 Scores"              
		},
  data: {
  labels: [	"04/13/2019",
  			"04/14/2019",
  			"04/15/2019",
  			"04/16/2019",
  			"04/17/2019",
  			"04/18/2019",
  			"04/19/2019",
  			"04/20/2019",
  			"04/21/2019",
  			"04/22/2019",],
  datasets: [{
      label: "Test Line Chart",
      fill: false,
      lineTension: 0.1,
      backgroundColor: "rgba(225,0,0,0.4)",
      borderColor: "red",   
      data: [10,11,14,15,09,12,13,18,21,16]    
    }
  ]
},
  options: {
			scales: {
				yAxes: [{
	                ticks: {
	                	min:0,
	                	max:21,
	                	stepSize:1,
	                }
            	}]
			}	
		}
});
    </script>

Open in new window

…

6 Comments

Upgraded from ColdFuison 10 to ColdFusion 2016; all my UI components do not work.
They render as a grayed out area.

1 Comment

Learn SQL Server Core 2016

LVL 13

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

I used to have Ray Camden's Google Calendar API which has since being created been not functional. I don't know enough about CFC creation to modify his code to make the current oAuth 3.0 work with it. I'm simply needing a functional ColdFusion script to ADD, EDIT, DELETE events on a Google Calendar. I have scoured the internet and found nothing regarding an existing script. I've also put such a script out for bid on many developer sites. I'm having no luck from anyone on where to locate a currently functioning script which correctly uses Google's API for the calendar.

Anyone know how I can get this script so I can try to integrate it into a booking website I'm setting up? I have a small budget to even have it created for me. I'd need to have instructions on how to get approved to use their API and then the ADD, EDIT, and DELETE ability from my site. I'm using my own MySQL table to store the events with more detail than the Google calendar supports, but still need to be able to proliferate the events to a lot of Google Calendar users who can subscribe to the public calendar I'll post this to.

Help!!

6 Comments

In Oracle fusion, using HCM is it possible to mass assign a role/roles to existing user accounts? I know you can update elements in the Person Record, but was looking at the roles. which is previous versions of oracle might be referred to as 'responsibilities'.

I can do this manually, locate user record and then add the role, but it is time consuming to recall each user and assign the role manually. Would like to find a way I can do this en mass for non auto provisioned roles.

I've scoured google for examples/literature but there is not much there for a novice like me. Any information be gratefully received.

2 Comments

I have JSON type data stored in a column in a SQL Table (Microsoft SQL). I would like to be able to extract each element.
DATA:
{"amount":"0.52","invoiceNumber":"212265","result":"APPROVAL","txnId":"160119E3C-39EC4068-0571-41CC-9146-4FFCE637C30B","approvalCode":"060507","txnTime":"01/16/2019 01:14:00 PM"}

Is there a way to write a query that would extract the invoiceNumber, amount, and approvalCode Values easily?

Thanks

1 Comment

LVL 7

Question by

bcrosby007

2019-02-27

Coldfusion - cfgridupdate not working

CFGridUpdate will allow me to delete a row in my database but wont allow me to insert a new row or update and existing row. What am I missing?

<cfquery datasource="projects" name="entirelist">
	Select TOP 20 * from tbl_project  
	order by id desc
</cfquery>
	<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Project Data Input</title>
</head>
<cfinclude template="header.html"/>
<body bgcolor="ffffff" topmargin="2">
&nbsp:
	
<table width="1000" align="center">
    <td>
		<cfform action="forms/action_projectlistupdate.cfm">

				<cfgrid name="projectlist" insert="Yes" delete="Yes" format="html" query="entirelist" selectmode="edit" autowidth="yes" insertbutton="Insert Row" deletebutton="Delete Selected Row" colheaderbold="Yes">
					<cfgridcolumn name="id" header="ID" display="No">
					<cfgridcolumn name="proj_num" header="Project Number">
					<cfgridcolumn name="orig_proj_num" header="Orig. Project Number">
					<cfgridcolumn name="proj_name" header="Project Name">
					<cfgridcolumn name="client_name" header="Client Name">
					<cfgridcolumn name="partner_charge" header="Partner in Charge">
                    <cfgridcolumn name="notes" header="Notes">
				</cfgrid>
			<cfinput type="submit" value="Update" name="gridEntered">	
		</cfform>	
	</td>
</table>
</body>
</html>

Open in new window

<cfif IsDefined("form.gridEntered") is True>
	<cfgridupdate grid="projectlist" dataSource ="projects" keyonly="No" tableName ="TBL_PROJECT"> 
</cfif>
 <cflocation url="../ProjectInput1.cfm"/>

Open in new window

1 Comment

I'm trying to use jQuery UI's "sortable" with Ajax. I have a test table With the columns ID (the auto-incrementing ID), sampleText (like "test item 1", "test item 2" etc.) and displayOrder which, theoretically, is an integer for the order the item should be displayed in. My code gets the information from the database and loops over it. When I drag and drop or use the up/down arrows, DevTools shows that the appropriate URL is being pinged but the table isn't updating and I'm not getting an alert (that the attempt was successful/there was an error.) This is the code for the page:

<cfquery name="qGetStuffToOrder" datasource="#APPLICATION.ds#">
	SELECT * FROM test_reordering 
	ORDER BY  displayOrder
</cfquery>
<table class="table table-striped">
	<tbody id="tabledivbody">
		<cfoutput query="qGetStuffToOrder">
		<tr class="sectionsid" id="sectionsid_#ID#">
			<td>#sampleText#</td>
			<cfif CurrentRow NEQ recordCount>
				<td><a href="javascript:void(0)" class="movedownlink"> <span class="glyphicon glyphicon-arrow-down">down</span></a></td>
			</cfif>
			<cfif CurrentRow NEQ 1>
				<td><a href="javascript:void(0)" class="moveuplink" > <span class="glyphicon glyphicon-arrow-up">up</span></a></td>
			</cfif>
		</tr>
		</cfoutput>
	</tbody>
</table>
<script src="//ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script> 
<script>
		 $("#tabledivbody").sortable({
        items:

Open in new window

…

2 Comments

When using ExpandPath, I will occasionally get something unexpected. For instance, I'm trying to move a file from one directory to another.

<cffile action="MOVE" source="#ExpandPath('/tmp/bloop.jpg')#" destination="#ExpandPath('/final-images/bloop.jpg')#">

Open in new window

This is the error I'm receiving:
An exception occurred when performing a file operation moving a file to another filesystem on files /var/www/vhosts/[sitename].com/tmp/bloop.jpg and /opt/coldfusion10/cfusion/bin/redirect:/final-images/bloop.jpg.The cause of this exception was: java.io.FileNotFoundException: /opt/coldfusion10/cfusion/bin/redirect:/final-images/bloop.jpg (No such file or directory).

You'll notice that the expanded base of the source is /var/www/vhosts/[sitename].com (which is what you'd expect it to be) while that of the destination is /opt/coldfusion10/cfusion/bin/redirect:

What's going on here? This isn't the first time I've run across this issue, but I can't seem to Google anything up about it. We're running CF10 on a Linux server. Thanks!

1 Comment

I have the below code sample and need to confirm the correct usage of CFTRANSACTION and that a variable newID is being called to correctly:

<CFTRANSACTION>
<CFQUERY name="newID" datasource="#dsn#">
SELECT MAX(ID) + 1 AS newid FROM TLAApprovers
</CFQUERY>
 
<CFIF newID.recordcount is 0>
<CFSET newid2 = 0>
<CFELSE>
<CFSET newid2 = newID.newid >
</CFIF>

<cfquery name="updateMain" datasource="#dsn#">
Insert INTO TLAApprovers (ID, Name, Unit, ApproverEmail, Status)
Values ('#newid2#', '#form.Name#', '#form.unit#', '#form.ApproverEmail#', '#form.status#')
</cfquery>
</CFTRANSACTION>

Open in new window

7 Comments

After upgrade from CF2016 to CF2018 getting "connection refused" error on open CSV file. SQL Server 2012. Windows Server 2012
It is working with CF2016 but not CF2018

     HTML Code Format  <PRE>Error Executing Database Query. [Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. &lt;br&gt;The error occurred on line 40.</PRE>

Open in new window

<cfset FilePath = "C:\home\mywebsite\wwwroot\test\countrycodeToDialcode.csv">
             <cfquery name="GetInternationalDialcode" datasource="dialCodes"
             cachedWithin = "#CreateTimeSpan(1, 0, 0, 0)#">
                           SELECT *
                           FROM #filePath#
             </cfquery>

Open in new window

1 Comment

I manage a bunch of websites that mostly use Coldfusion. Each website is located in its own directory on the server and they all use the same version of the code and they each have their own database. I am trying to figure out what is the best way to update all of the sites when I make a change to the code. Right now I have created a directory on the server that contains the changed files and then I use directoryCopy to copy over the new files. My code looks something like the following:

<cfset temp = directoryCopy("_UpgradeCode","website_to_update_directory/",true,"*.*")>

Open in new window

One issue that I have is that I don't know if there were any problems copying over the code.

Can anyone suggest a better way to update websites? I am hoping that this can be done in an automated way so that I can just call a function or something and then it automatically updates all of the sites. I have created a list of sites to update that can be passed to the function.

Thank you for any help that you can provide about this.

3 Comments

Exploring SharePoint 2016

LVL 13

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

MacOS Sierra plug-in configuration a qualified success. However, I have no CFB perspective.
Install log says:
Installation: Successful with errors.

6454 Successes
0 Warnings
2 NonFatalErrors
0 FatalErrors

Non fatal errors being two occurrences of
Modify Text File - Single File: /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Eclipse/Eclipse.app/Conten ts/Info.plist
Status: ERROR
Additional Notes: ERROR - Unable to locate ASCII text file to be manipulated. Deferring...

Indeed there is no such file, whereas there is a file /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Info.plist. At the install log errors referenced path /Users/barrygbrunning/eclipse/java-oxygen/Eclipse.app/Contents/Eclipse/ are located folders: configuration, droppins, features, jre, plugins, readme and the eclipse.ini file, but no info.plist.

The implied "Deferring..." action seems to have not happened. Any suggestions as to what I might do to recover the situation? What should have happened to an info.plist somewhere? How might I get the CFB perspective to manifest in Eclipse?

Adobe_ColdFusion_Builder_2016_Instal.log

Any help will be greatly appreciated. Thank you.

2 Comments

I am trying to convert some coldfusion code to jsp and there are some tags like cfargument,cf:loop,cf:return,cf:location.. can anybody tell me what to use in place of these tags in jsp?

2 Comments

I have a search (with drop downs and input boxes) and results page using ColdFusion and Access. Displayed on the results is a link to a new search page with some criteria automatically filled for the user, and will click on the submit button to view the results.

Note: the search and results are on one page of code

How can I alter my link to automatically submit to view the results in lieu of having the user click submit?
Link code:

<a href="Search.cfm?RE=#RE#&JU=#JU#&SE=#SE#" target="_blank" ><font size=3>#RE#-#JU#-#SE#</font></a>

Open in new window

6 Comments

I am trying to create a simple HTML table and for some reason the columns in the header are not the same width has in the body. My code looks like:

	<table class="table AdTableStyle1 ManageSched" id="UserSchedule" border="1" cellpadding="4" cellspacing="0">
		<thead>
			<tr>
				<th >Day</th>
				<th >Date <span style="font-size:10px">(mm/dd/yyyy)</span></th>
				<th >Start Time</th>
				<th >End Time</th>
			</tr>
		</thead>
		<tbody>
			<cfloop index="thisRow" from="1" to="#arrayLen(sched.data)#">
				<cfoutput><tr>
					<td>#sched.data[thisRow].day#</td>
					<td>#sched.data[thisRow].date#</td>
					<td>#sched.data[thisRow].starttime#</td>
					<td>#sched.data[thisRow].endtime#</td>
				</tr></cfoutput>
			</cfloop>
		</tbody>

	</table>

Open in new window

Capture.PNG

4 Comments

Hi

We have a computer with Coldfusion on running website on a localhost. I tried to add a new website but by doing this I now cant connect to any local website.

I've clearly done something wrong but I dont know how to fix it.

Can anyone guide me into a repair

Thanks
Mark

19 Comments

CFGRID runs into JSON Parse error while fetching data. However, sometimes 20K records come back in the grid while at other times, the error would display for 700 records.

1 Comment

ColdFusion Language

Related Topics

ColdFusion Language

Related Topics