ColdFusion Language Questions

Good morning!! I'm hoping to get some assistance/advice on a ColdFusion/HTML page. Basically what I have is a page with standard tables, the first table is nothing more than field/column names...using CSS to format them. The second table directly under that is an actual data table that I'm populating from an Oracle database using CFLOOP....and its a lot of fields and a lot of data. I would like to "lock" the first table where I call out the field names so it stays in place as the user scrolls down through the data, but I need the table to be able to scroll left/right to coincide with the second data table being scrolled to the left or right. Should this first table be a header type of function, and is there something I can do within the first <table> to lock it vertically but scrollable horizontally? Thanks a lot!!

4 Comments

HTML5 and CSS3 Fundamentals

LVL 19

Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.

I have a directory of about 5000 .cfm and .js files. I would like to be able to determine what files are not called by any other file. For example, if I have a file called hires.cfm, I want to know if, within the content of the directory files, there is any reference to hires.cfm?

I was thinking of using cfdirectory to get a list of files and then looping through and reading each file and searching for the file name one-by-one.

Is there a better way to search the content of files within a directory, or a way to scan a directly and build a dynamic site map based on file names withing the content of each file.

6 Comments

I did not find any Coldfusion sample code for Google Speech-To-Text API. If you have sample code in Coldfusion, then please share it with me. My requirement is while speaking using the microphone, the audio should convert into text instantly.

1 Comment

I have a string like a subject in an email: customer needs tank pumped [12345]

I need to use a regular expression to extract the value withing the right/left brackets. This is the unique ID for the message.

I would like to know the most efficient way to do it.

Thanks

1 Comment

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

…

3 Comments

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.

0 Comments

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

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

PMI ACP® Project Management

LVL 19

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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

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

Starting with Angular 5

LVL 19

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

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

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

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

ColdFusion Language

Related Topics

ColdFusion Language

Related Topics