ColdFusion Language

10K

Solutions

3K

Contributors

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello everyone. I need some help with this Colfusion component.. I need to pass the values extracted form the cfqueries into the values in the cscript...

<cfcomponent>
<!--- I have the following queries --->
<cffunction name="GetNumbers">
<cfquery name="Fall2006" datasource="#db#" > 
      select sum(transfer_y1_2y_public) as y12y, sum(transfer_y2_2y_public) as y22y, sum(transfer_y3_2y_public) as y32y, sum(transfer_y4_2y_public) as y42y, sum(transfer_y5_2y_public) as y52y, sum(transfer_y6_2y_public) as y62y from transfer where transfer_entry_sector = <cfqueryparam cfsqltype="cf_sql_varchar" value="TWO_YEAR_PUBLIC">
      and transfer_year = <cfqueryparam cfsqltype="cf_sql_integer" value="2006">
</cfquery>

<cfquery name="Fall2008" datasource="#db#" > 
      select sum(transfer_y1_2y_public) as y12y, sum(transfer_y2_2y_public) as y22y, sum(transfer_y3_2y_public) as y32y, sum(transfer_y4_2y_public) as y42y, sum(transfer_y5_2y_public) as y52y, sum(transfer_y6_2y_public) as y62y from transfer where transfer_entry_sector = <cfqueryparam cfsqltype="cf_sql_varchar" value="TWO_YEAR_PUBLIC">
      and transfer_year = <cfqueryparam cfsqltype="cf_sql_integer" value="2008">
</cfquery>

<cfquery name="Fall2010" datasource="#db#" > 
      select sum(transfer_y1_2y_public) as y12y, sum(transfer_y2_2y_public) as y22y, sum(transfer_y3_2y_public) as y32y, sum(transfer_y4_2y_public) as y42y, sum(transfer_y5_2y_public) as y52y, sum(transfer_y6_2y_public) as y62y from transfer where …
0
Exploring SQL Server 2016: Fundamentals
LVL 12
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

I have the below program. Can somebody point out why the content of parmArray in function "doCalc"  changes whle
no operation is being performed on it.

I have been pulling my hair on this issue for about 2 days now.

Any help is greatly appreciated.



<cfset aAr1 = arrayNew(1)>
<cfset s = structNew()>
<cfset s.date = 'xx'>
<cfset s.interest = '250'>
<cfset aAr1[1] = s>
<cfset s = structNew()>
<cfset s.date = 'yy'>
<cfset s.interest = '300'>
<cfset aAr1[2] = s>
<cfset s = structNew()>
<cfset s.date = 'zz'>
<cfset s.interest = '350'>
<cfset aAr1[3] = s>


<cfinvoke   method="doCalc" returnvariable="aResult1">
    <cfinvokeargument name="parmArray"  value="#aAr1#">
</cfinvoke>


<cffunction name="doCalc" returntype ="array">
    <cfargument name="parmArray" required="true" type="array">

      <cfdump var = "#parmArray#" label="before">
      <cfset LOCAL.aAr2 = parmArray>
      
      <cfloop index="LOCAL.nIDX" from="1" to="#arrayLen(LOCAL.aAr2)#" >
            <cfset LOCAL.aAr2[LOCAL.nidx].date = LOCAL.nIdx>
      </cfloop>

      <cfdump var = "#parmArray#" label="after">      
      
    <cfreturn LOCAL.aAr2>
 </cffunction>
0
ColdFusion 9

Create 2 excel files at once

I use this to create a single excel file:

<cfquery database="somedb" name="somequery">
       ... my query ...
</cfquery>

<cfspreadsheet action="write" query="somequery" filename="/C-Items_#custno#_#contractid#.xls" sheetname="temp" overwrite="true">
<cfheader name="Content-Disposition" value="attachment; filename=C-Items_#custno#_#contractid#.xls">
<cfcontent type="application/vnd.ms-excel" file="/C-Items_#custno#_#contractid#.xls" deletefile="yes">

I have found myself in a situation where I need a second excel file created (under certain circumstances).

EG.  
<cfif filedneeded eq "yes">
      ... my code above ...
</cfif>
<cfif secondfileneeded eq "yes">
     ...different query than above, but <cfspreadsheet/cfheader/cfcontent> code similar ...
</cfif>

When I try this I only get the first excel file and not the second ... as if the <cfheader> or <cfcontent> aborts the code and the second <cfif> never runs.  I can easily create either spreadsheet from 2 separate links on my page that directs the user to the correct chunk of code, but I'd like to automate this because the need for a second excel file is only sometimes, and my users seems to often forget to click the second link.

Hope that makes sense.

Regards,
Max
0
FormEntry ErrorServer Settings Page 1Server Settings Page 2Hi,
I am running Coldfusion v9 (migrated from Coldfusion v7) and running on error on the same cfm page that used to run just fine in CF7 environment.
I found an article where they talk about this type of error and apparently one person in that discussion pointed out that we can turn this feature off.
Here is the link:
https://www.bennadel.com/blog/767-new-coldfusion-error-form-entries-incomplete-or-invalid.htm

However it does not say exactly what feature/function to turn off in CF admin.

Can you help?
0
I have create a .jsx file from photoshop and using cfexecute to run it. If I use cfexecute from the web it does not execute the script . If I take the script and execute it locally using ExtendScript Toolkit then it works like a charm. I do not know what do to make it work through  the web .

<cfexecute name="C:\Program Files (x86)\Adobe\Adobe Photoshop CS2\photoshop.exe" 
arguments="C:\inetpub\wwwroot\websites\myscript.jsx" timeout="6000" variable="returnedResults" 
      errorVariable="returnedError"  ></cfexecute>

Open in new window


the script is here

#target photoshop

$.localize = true;

var inputFolder = new Folder("/c/work_space/2018/pdfs")
var saveFolder  = new Folder("/c/work_space/2018/JPEG")

function createFolder(fptr) {
  if (!fptr) {
    Error.runtimeError(19, "fptr");  // Bad Argument
  }

  if (fptr.constructor == String) {
    fptr = Folder(fptr);
  }

  if (fptr instanceof File) {
    return createFolder(fptr.parent);
  }
  if (fptr.exists) {
    return true;
  }
  if (fptr.parent && !fptr.parent.exists) {
    if (!createFolder(fptr.parent)) {
      return false;
    }
  }
  return fptr.create();
}; 


createFolder(saveFolder)



if (inputFolder != null)
{
var inputFiles = inputFolder.getFiles("*.pdf")

for(var i=0;i<inputFiles.length;i++)
{

var fileRef = File(inputFolder + "/" + inputFiles[i].name)
var pdfOpenOptions = new PDFOpenOptions
pdfOpenOptions.antiAlias = true
pdfOpenOptions.mode = OpenDocumentMode.RGB
pdfOpenOptions.cropPage = 

Open in new window

0
I can't seem to find why these two pages are showing the header areas differently. I don't see a difference w/in the code that would cause this. Both reports use the same styles and configuration for the tables and images. Only difference is one is an html file and one is a cfm. See below for screenshots and code comparison.

Showing correctly - index.html:

<cfset #date# = #DateFormat("#Now()#","mmmm dd, yyyy")#> 
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML LANG="EN-US">

<head>
<title>XXXXXXXX Report Query</title>

<script language="JavaScript" type="text/JavaScript">
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
</script>

<link href="../css/home.css" rel="stylesheet" type="text/css" />
<LINK rel="Home" title="Index page of FINCEN Intranet site"
      type="text/html"
      href="https://<cfoutput>#CGI.SERVER_NAME#</cfoutput>">  
</head>

<BODY >
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0" background="../images/grad2b.gif">
   <tr>
      <td width="10%">&nbsp;</td>
      <td width="80%" valign="top">
	     <table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" >
            <tr>
   

Open in new window

0
I have created the system DSN and as well User DSN on my system control panel successfully by ODBC Connector  against MySQL 8 server DB. now i want to use this this database on my ColdFusion server and for this i am creating the Data-source on my ColdFusion server. But there showing errors . Please guide me that how can i use this database or DSN on my ColdFusion server and what type of driver i have to select in ColdFusion administration for creating Data-source .

Thanks In advance!
0
I am getting an error when trying to run a SQL query/report from within a cfm file. The error is being throw due to the fact that there's no data to pull from for one of the options in the drop down menu for the last couple of years. No information to pull from. Any ideas on how to fix the query or CF to prevent the error when there's  no data to pull from in the db?

Error and queries below:

The error occurred in D:/inetpub/wwwroot/CASAPay/casapay_out.cfm: line 116
 
114 :                   
115 : <!--Summing columns with CFSET declaration... -->                  
116 : <cfset countttl = #invcounts.15Count# + #invcounts.1530C# + #invcounts.30plusC#>
117 : <cfset dollarttl = #invcounts.less15days# + #invcounts.15to30Days# + #invcounts.30plusDays#>
 

<cfcomponent>
	<cffunction name="casapay1" access="public" returntype="query">
 
<!--Set global datasource variable -->
<cfset #dsn# = "mirrepuser">

<cfparam name="form.agency" default="">
<cfparam name="form.period" default="">

<cfquery name="invCounts" datasource="#dsn#">
SELECT
   /*+ INDEX (f FV_INV_SELECTED_DUEDATE_IDX) */
   --Within 15 days
   SUM(
   CASE
      WHEN
         P.ACCOUNTING_DATE BETWEEN i.terms_date AND i.terms_date + 15 
      THEN
         i.invoice_amount 
      ELSE
         0 
   END
) "less15days", SUM(
   CASE
      WHEN
         P.ACCOUNTING_DATE BETWEEN i.terms_date AND i.terms_date + 15 
      THEN
         1 
      ELSE
         0 
   END
) "15COUNT", 	--Between 15-30 Days
   SUM(
   CASE
      WHEN
      

Open in new window

0
How to Detect Traffic From China language hu-hu (reported in google analytics) and divert to a not available in your region page

I notice traffic with language hu-hu in my google analytics with a high bounce rate.

What is the best way of detecting traffic from China -   with language hu-hu?

I have a cold fusion 2016 site.  Thank you
0
Create multiple PDF using coldfusion and cfcontent. I have the CF query and I need for each person generate the PDF file. The way I do is cfoutput through the query into the variable and then put that variable into cfdocument and then use <cfcontent to produce PDF through the browser. But the broser only producing the PDF for 1 person . I think this is because cfcontent but how can i produce as many PDFs  as people produced by the query  

<cfoutput query="rc.getResultByCompetency" group="rateeID">
    	<cfsavecontent variable="output">
               output here
       </cfsavecontent>
<cfdocument
						name="certificate_#rateeID#"
						orientation ="portrait"
						mimetype="application/pdf" overwrite="true" 
						format="PDF">
					#output#
				</cfdocument>		
	<cfset test = evaluate("certificate_#rateeID#")>
				<cfheader name="content-disposition" value="attachment;filename=#rc.getResultByCompetency.rateeName#.pdf">
				<cfcontent type="application/pdf" variable="#toBinary(test)#" >	
 </cfoutput>

Open in new window

0
Exploring ASP.NET Core: Fundamentals
LVL 12
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

I'm attempting to use the following code to upload files in Redactor. The directory path exists. The permissions for the directory are currently overly permissive just for testing. But the file upload box keeps turning red and no file is uploaded. Any ideas where I might be going wrong? Thanks!

Code from the index page:
<script>
  	$R('.redactor', {
		fileUpload: 'js/redactor/file-upload.cfm'
	});
</script>

Open in new window



Content of file-upload.cfm:
<cfsetting enablecfoutputonly="true">

<cfset relativePath = "/modules/downloads/">
<cfset dir = ExpandPath(relativePath)>
	
<cfset files = {}>
<cfif StructKeyExists(FORM, "file")>
	<cfset fileNumber = 1>
	<cfloop list="#FORM.file#" index="i">
		<cffile action="upload" destination="#dir#" nameconflict="makeunique" filefield="file">

		<cfset files["file-"&fileNumber]["name"] = cffile.serverFile>
		<cfset files["file-"&fileNumber]["url"] = relativePath & cffile.serverFile>
		<cfset files["file-"&fileNumber]["id"] = CreateUUID()>
		<cfset fileNumber = fileNumber + 1>
	</cfloop>
<cfelse>
    <cfset files["error"] = "no file uploaded">
    <cfset files["path"] = dir>
</cfif>
<cfheader name="Content-Type" value="application/json">
<cfoutput>#serializejson(files)#</cfoutput>
<cfsetting enablecfoutputonly="false">

Open in new window

0
ColdFusion 9
Windows Server 2008
JQuery

I have captured a signature (Json value - TicketSignature) that I save to database.  I am using JQuery UI Signature to capture the signature (http://keith-wood.name/signature.html).  I can re-generate the signature on a web page without problem by using:

<cfoutput>
          <textarea style="display:none;" name="TicketSignature" id="sig">#TicketSignature#</textarea>
</cfoutput>

<script>
       $(function() {
		$('#redrawSignature').signature('enable').
		signature('draw', $('#sig').val());
		signature('disable'); 
	});
	$('#redrawSignature').signature({disabled: true});
</script>
<div style="margin-top:10px;font-size:12px;margin-bottom:7px;">
          <div id="redrawSignature"></div>
</div>

Open in new window


But when I try to embed the code above in a CFMAIL tag, it will not redraw the signature ... the "redrawSignature" box remains blank ... is this possible within CFMAIL tags?  Works fine on a regular .cfm page to display on the screen, but I need a copy emailed to my customers with their signature.

I have tried moving the TEXTAREA and SCRIPT outside (above) the CFAMIL tags, and also with them inside the tags, with no success.  Any ideas?

Max
0
I am setting up an integration with a third party.   They already have an existing POST to a former affiliate, so I ask them to just put my URL in there and hit our site.  I figured I would just deserialize the JSON and see what comes in, then code to that.  

So I created a   index.cfm file (Coldfusion 11)  on    www.mysite.com/api/order/    

The index.cfm file does nothing but email me a CFDUMP of the URL and FORM variables.
I gave the URL to the company and they hit it.   I receive the email and both CFDUMPs are empty structures.   No URL variables, no FORM variables.

They say they are doing a POST call to the site.   And are using this path:     www.mysite.com/api/order/   

They have hit it multiple times, they get a 200 OK response.   But each time, my mailed dump show empty values even though they are sending JSON over.

What am I missing?    What do I have to do differently to see the data they are sending?

Thanks!
0
My scheduled tasks in ColdFusion 9 are no longer executing.

They attempt to run (I can see that in the log files) but we get a no connection error.

While in the cfadmin, if we try to run a task manually we get this:

There was an error running your scheduled task. Reasons for which scheduled tasks might fail include:

    The scheduled task is paused
    The URL is a redirection URL.
    The URL is protected by IIS NT Challenge/Response or Apache .htaccess password. The Username and Password text fields for editing a scheduled task are intended to support Basic Authentication only.
    The Domain Name lookup failed. Try using the IP address of the domain whenever possible.
    The URL is an SSL site, but the SSL port was specified incorrectly.
    The Web site is not responding.
    The directory specified for published results does not exist.

The scripts will run fine if I paste their URLs into a browser.

I read that its because tasks use CFHTTP and that needs a SSL connection.  So I created a page with CFHTTP calling one of the scripts used in the tasks.
and here is the dump from that.

       struct
Charset      [empty string]
ErrorDetail      I/O Exception: peer not authenticated
Filecontent      Connection Failure
Header      [empty string]
Mimetype      Unable to determine MIME type of file.
Responseheader      
struct [empty]
Statuscode      Connection Failure. Status code unavailable.
Text      YES


These scheduled tasks ran great for years.  But this week the tech support …
0
How do I add to my original SQL statement, a sum of values in a particular field?
I want the same output from my original SQL statement with the receivedQty field totals.
Software: ColdFusion with MS Access

Original SQL Statement:
SELECT OMaterials.KeyID, OMaterials.*, Ship.*, Materialm.*, DO.*, Materialm.projectQty,'' AS RCVDBY
FROM ((Ship INNER JOIN DO ON Ship.KeyID = DO.ShipID) INNER JOIN OMaterials ON DO.KeyID = OMaterials.DOID) INNER JOIN Materialm ON (Ship.KeyID = Materialm.ShipID) AND (OMaterials.MaterialmID = Materialm.KeyID)
WHERE (((Materialm.projectQty)<>0))

Open in new window


How do I add this statement to the above statement? (this statement produces all the related records an adds up the receivedQty totals)
SELECT DISTINCTROW Materialm.KeyID, Sum(OMaterials.receivedQty) AS SumOfreceivedQty
FROM Materialm INNER JOIN OMaterials ON Materialm.KeyID = OMaterials.MaterialmID
GROUP BY Materialm.KeyID;

Open in new window

0
I'm trying to process a form submission where there are 3 fields with different names, but 10 instances of the fields. I know it sends the duplicate fields as a delimited list.

My issue is that I'm using the CFLOOP to create 3 variables each iteration, each with a concatenated index value. So my output from the cfloop gives me these variables.
CFLOOP 1
<cfset var1=1>
<cfset var2=6>
<cfset var3=15>

CFLOOP 2
<cfset newvar1=16>
<cfset newvar2=89>
<cfset newvar3=82>

CFLOOP 3
<cfset anothervar1=7>
<cfset anothervar2=9>
<cfset anothervar3=11>

So I have 3 different cfloops doing the same thing. Now, I am ready to insert these variables into a database using the same CFLOOP idea

<cfloop index="x" from="1" to="10">
<cfquery name="addreco" datasource="#mydsn#">
INSERT INTO myDatabase
VALUES (foo,foobar,foofoo)
('#Var("#x#")#','#newvar("#x#")#','#anothervar("#x#")')
</cfquery>

</cfloop>

Is the data inserting formatted right since I'm technically combining two variable names to create a single variable name?  I've read multiple examples online for ways to do this and have only been confused by the proper syntax. I have not yet tested this theoretical format to make the data work.

Help
0
I have researched the web for examples and can't find one in Coldfusion.

I have an HTML form with dynamically generated fields with checkbox values. I want to be able to click any combination of checkboxes and have a visual tally showing the sum value of the checked boxes. This will allow the user to know the calculated total of the check boxes as they click on them. The TOTAL value field does not need to be submitted necessarily as a form field, but can be.

Example:

[ ] Checkbox 1 (value=1)
[ ] Checkbox 2 (value=2)
[ ] Checkbox 3 (value=1)

If the user clicks boxes 1 and 3, I want a visual real-time display of the total of those two fields as "2".

Please provide working HTML code and Javascript as I suppose would be needed.
0
I have a sql query w/in Cold Fusion I'm confused about. The colorization of the commented out code isn't showing correctly within dreamweaver:

[code][/<cfquery name="vp" datasource="casprod">
select c.org_id orgid, c.vendor_name vendor, c.address_line1 addr1, c.address_line2 addr2, c.address_line3 addr3,c.city city,c.state state, substr(c.zip,1,5) zip, c.country country, substr(d.attribute1,1,2) doctype, sum(d.amount) tot_amount, count(distinct c.check_id) count
from ap.ap_checks_all c, ap.ap_invoice_payments_all p, ap.ap_invoice_distributions_all d, ap.ap_invoices_all i
where  c.payment_method_lookup_code='CHECK'
and c.amount <> 0
and c.check_id = p.check_id
and p.invoice_id= d.invoice_id
and d.invoice_id = i.invoice_id
and c.status_lookup_code = 'NEGOTIABLE'
and c.org_id =101
and i.source <> 'MILITARY PAY'
and c.check_date >= TRUNC(ADD_MONTHS(SYSDATE, -1),'MM')
and c.check_date <= LAST_DAY(ADD_MONTHS(SYSDATE, -1))
group by c.org_id,c.attribute8,c.vendor_name,c.address_line1,c.address_line2, c.address_line3,c.city,c.state,c.zip,c.country,substr(d.attribute1,1,2)
order by 3

<!---select c.org_id orgid, c.attribute8 attrib8, c.vendor_name vendor, c.address_line1 addr1, c.address_line2 addr2, c.address_line3 addr3,c.city city,c.state state, substr(c.zip,1,5) zip, c.country country, substr(d.attribute1,1,2) doctype, sum(d.amount) tot_amount, count(distinct c.check_id) count
from ap.ap_checks_all c, ap.ap_invoice_payments_all p, ap.ap_invoice_distributions_all…
0
I need to pass params to the coldfusion cfc using Bootstrap table toolbar.

When I click the apply button I am serializing the form into array and now I need to split the variable. I have the code bu I get the  error message Uncaught SyntaxError: missing ) after argument list

$("#btnApply").click(function(){
		
			//alert($("#frm2").serialize());
			var vals  = $("#frm2").serializeArray();
			var str  = "";
			
			
			for (i=0; i<vals.length;i++){
   				str += '&' + $('#' + i.name) + '_title=' + $('#' + i.name').attr('title') + '&' + $('##' + i.name) + '_alt=' + $('##' + i.name').attr('alt');
			}
			 
			 alert(str);
			  
			$('#classes').bootstrapTable('refresh',{query: {str}});
			
			return false;
		})

Open in new window

0
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

online credit application formHi,

 i have cold fusion web page (.cfm) where potential customers fills out credit application information and submit to us.At this point, anyone can poke around and can stumble upon this .cfm page and fill out the information and submit to us.

 However, due to no protection or verification process in place, we are getting one too many prank/fake applications and I like to do something about it.

 I  have seen examples of protection like requiring the result of multiplication of two numbers:   2 x 3 = 6 or the picture where I am supposed to select blocks in the picture where cars are seen ... etc.

What is the simplest and easiest way of protecting this page from abuse?

Thanks.
0
I have the page that show a table and in one of the table cell I show a progress bar implemented in bootstrap. When the page is shown in HTML it works fine . When I convert the page into PDF the progress bars disappears
0
Working with Client-Side CFCharts and passing JSON controls

I'm using the Zoom-In Preview and want to start the graph zoomed-in.

Zoom-In feature of CfChart, with an initial zoom set
The problem is that the setting for initial zoom-in does not seem to be a valid parameter in Coldfusion CFChart.
Looking at the ZingChart documentation (which is what CfChart uses)  I see the value I need in the scale-x attribute,   But CFChart says that is not a valid parameter and of course there is zero documentation on it.   Does anyone know how to include the scale-x attribute?


<cfset variables.xAxis = {"label"={"text"="Drag the handles to zoom in to the chart","color"="red"},"zooming"="true"}>
<cfset variables.yAxis = {"label"={"text"="Drag the handles to zoom in to the chart","color"="red"},"zooming"="true"}>

<cfset variables.zoom = {"alpha"="0.3","zooming"="true","zoomTo"="[10,30]","adjust-layout"="true","border-color"="black","border-width"=4,"background-color"="gray","label"={"border-color"="red","border-width"=2,"font-size"=10}}>

<cfset variables.preview = {"alpha"="0.3","visible"="true","live"="true","preserve-zoom"="true","border-width"="2","vertical-align"="top","adjust-layout"="true"}>

<cfset variables.plotArea = {"margin"="dynamic dynamic 130px dynamic"}>

<cfset variables.scaleX = {"zooming"="true","zoomTo"="[2,5]","adjust-layout"="true"}>   <!==========  I need to set  ZoomTo Value which is part of Scale-X in ZingCharts

  <cfchart alpha=".7"
	   backgroundColor = "##eeeeee"
         

Open in new window

0
I have an mssql table which has data stored as csv.

I am trying to output the data into individual rows / checkboxes from the field in the database.

EG SQL Query:
<cfquery datasource="#Application.DSN#" dbtype="odbc" name="getgames">
SELECT games
FROM users
WHERE games LIKE '%arma%'
</cfquery>

The query works ands the output is then like:
eso,swtor,wow,rocket league,arma 3

I am using Cold Fusion and trying to output the data as
eso
swtor
wow
rocket league
arma 3

Or potentially as
<cfinput type=checkbox name="games" value="#games#">
where value="#games#", being listed as the individual games

I can't seem to get it to work using a cfloop with delimiters="," OR delimiters="#chr(10)##chr(13)#"

I am looking at something along the lines of
<cfloop query="getgames" index="index" list="#games#" delimiters="#chr(10)##chr(13)#">
#games#
</cfloop>

Or

<cfloop query="getgames" index="index" list="#games#" delimiters=",">
#games#
</cfloop>

Where am I going wrong with this?
0
Using Cold Fusion - How to parse this JSON feed that has structure - array - structures.

I've attached a jpg of the cfdump

I just don't work with structures and arrays much anymore
Structure.jpg
0
Hi,
I have used the above sample codeset to use ckeditor4 integration without ckfinder.
But I am able to browse image file from specified path.
On When we upload the image I am recieving and error message"Incorrect server response."

Same "upload.cfm" code  is used for uploading the image . Please help me.
0

ColdFusion Language

10K

Solutions

3K

Contributors

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.

Top Experts In
ColdFusion Language
<
Monthly
>