cfml #cfml-beginners

Channels

cfml-beginners

Risen Joe

01/12/2023, 12:58 PM

Hi all, While using Coldfusion version 21, in my app I have an issue like illegal character in path in paypal_console.jar file whereas in Coldfusion 16 I don't have that issue so can someone say what is the issue?

3 replies · 3 participants

gsr

01/15/2023, 5:34 PM

cflib icalUS seems only taking care of the US daytime savings, is there a global thing i can change so it reflects all countries timezoine or atleast make the time GMT enabled so it always displays in GMT instead of every country timezone, but if timezone can be done, it will be much better

1 reply · 2 participants

Simone

01/18/2023, 5:24 PM

how to get a 3rd row and 2nd column of 3rd row value from query

6 replies · 3 participants

gavinbaumanis

01/25/2023, 11:36 PM

In a conversation elsewhere, I mention @markmandel and ColdSpring which got me to thinking about a podcast I guest appeared on in the early 00's... where I spoke about Test Driven Design and unit tests in general... So... I just wanted to throw out there.... Yell from a cliff-top and if something comes back - great - and if it doesn't - oh well I guess it was a duck's quack... Test driven-design is NOT about "anally" writing tests. It's most definitely NOT about getting a % of coverage, either. For me: It is only about code-confidence. Did the Bug fix... / Did the new feature... / Did the rewrite.... • Actually do what I am expecting it to do? • Break something I never thought would have a touch-point with my change.

👍 1

3 replies · 2 participants

Simone

01/30/2023, 1:14 PM

Hi, I am trying to create an upsert for my table, if records exists, update else insert, for a table, anyone knows how to do all in one i am going in google but its too much information instead of just one small page which shows how it is done in sql server

7 replies · 6 participants

Umair Khan

01/31/2023, 4:21 PM

Can we add HTML content to one of many sheets using cfspreadsheetobj?

<cfset objSpreadsheet = SpreadsheetNew("REGISTRO DE VENTAS") />					
				  <cfset SpreadSheetSetActiveSheet(objSpreadsheet, "REGISTRO DE VENTAS")/>	
				  <cfset SpreadsheetAddRow(objSpreadsheet,encabezadosMatrizVentas)>										  
				  <cfset SpreadsheetAddRows( objSpreadsheet, MatrizVentas) />

Instead of query I want to use html save content to export to excel in one of sheets

1 reply · 2 participants

Simone

02/01/2023, 1:07 PM

i need some help in rereplace, where i am trying to replace required='yes" or required='no' with default='''

16 replies · 3 participants

Anna

02/02/2023, 10:08 PM

Hi I have a password which contains #. ( abcd#456) I need to pass it in the argStruct when calling the createObject function. But I get syntax error. What to do ?

<cfset myObj = createObject('webservice', 'urltowsdl ', {authType = 'basic', username='abc@abc', password='abcd#456'})>

4 replies · 3 participants

Anders Lars

02/03/2023, 5:53 PM

Trying to compare a time string ('hh🇲🇲ss') that I receive - to the current time (any date parts are irrelevant). Looking at the CF date and time functions - didn't see anything that will compare times only. I guess I need to call CreateDateTime() - passing in the date parts from now(), plus my time parts - and then compare that constructed date with now(). Is this is scenario where I'd be better off dropping down to Java? say

<cfscript>
    jTime = createObject( "java", "java.time.LocalTime" )
    jEnum = createObject("java", "java.time.temporal.ChronoUnit");
    variables.time1 = jTime.now();
    variables.time2 = jTime.parse('17:28:51');
    echo(variables.time1.until(variables.time2, jEnum.seconds));
</cfscript>

Method gets called pretty often, otw I would not be sweating it. thanks!

13 replies · 5 participants

Simone

02/09/2023, 3:35 PM

i am looping over session collection, but i want to keep the session kes but make all the values as empty, right now i can loop over session and do a sessionclear which also deletes the sesisonkeys

5 replies · 4 participants

johnbarrett

02/09/2023, 7:37 PM

I just finished a job interview, and 2 questions were asked that I didn't know about: (1) What is a closure?, and (2) when would you use === in ColdFusion? Is === in ColdFusion similar to when you would use === in javaScript. Can anybody help me understand these two items. Thanks so much!

44 replies · 6 participants

gsr

02/10/2023, 6:26 PM

what is wrong i am doing in JSOUp loop

TheTable = HTMLDocument.select("##tableID");
TheTable.addClass("styled-table");
			dateFields = TheTable.select('tr td:nth-child(4)');
			dateFields.forEach( field => {
			  field.innerText.split(/\s/)[0]);
			});

i am trying to remove the second value from the td of each row by looping over it which is seperated by   or space

3 replies · 2 participants

gsr

02/11/2023, 3:37 PM

anyone knows how can i write an email to me if onmisfire executes in cfschedule

7 replies · 3 participants

gsr

02/11/2023, 3:37 PM

looks for docs but not getting any =thingf

johnbarrett

02/13/2023, 9:36 PM

I am feeling stupid, I have the following <cfquery> in my page, but it is showing up blank. I don't think that there is anything wrong here, or at least I am not seeing it. Why would the page be blank, instead of showing the table of users in the database?

<cfquery name = "members" datasource = "cfhawaiiDBmain">         SELECT user_id,first_name,last_name, joining_date
    FROM users
    ORDER BY user_id
</cfquery>

<table>
    <cfoutput query="members">
        <tr>
            <td>#members.first_name#</td>
            <td>#members.last_name#</td>
            <td>#members.date#</td>
        </tr>
    </cfoutput>
</table>

9 replies · 4 participants

Michael Gillespie

02/15/2023, 10:54 PM

This seems appropriate here, how do I implement an if statement in a sql query using queryExecute? Is it possible? Or do I bite the bullet and craft the sql in a var and use that var in the queryExecute call. I ask because I am modernizing and there are a LOT of queries like this - figured I'd "do it right" from the beginning.

<cfquery name="sortedQry" dbtype="query">
		select *
		from tmpQry
		order by 
		<cfif arguments.sortBy eq 0>
			volume
		<cfelse>
			length, width, height
		</cfif>
</cfquery>

9 replies · 5 participants

johnbarrett

02/15/2023, 11:01 PM

CF Mail question, in the output in the mail How do I skip a line, I tried <br />, but it just shows up in the mail:

<cfmail   to="johnbarr@hawaii.edu" 
          from="john@cfhawaii.net"
          subject="Hawaii ColdFusion User Group Message"
          wraptext="75">
          From: #form.demo_name# (#form.demo_email#)<br />
          Comments: #form.demo_message#                                      </cfmail>

7 replies · 4 participants

Simone

02/17/2023, 3:04 PM

i am using Application.cfm and please do not ask to update, because not in my hands 🙂 so how can i have a maintenance page which checks if there is an outrage depending on sql connection,

4 replies · 2 participants

gsr

02/18/2023, 5:14 PM

another approach i am trying is to use

writedump(TheTable.select("tbody").before("#getHeaders#").toString()); abort;

to add thead before tbody but its not adding it

11 replies · 4 participants

Simone

02/21/2023, 3:20 PM

does anyone already worked upon https://learn.microsoft.com/en-us/graph/outlook-calendar-concept-overview

6 replies · 4 participants

Gabriel Rodrigues

02/23/2023, 8:13 PM

Hello guys, I'm trying to run TestBox on my .gitlab-ci.yaml, there are any tips/tutorials that I can follow? Do I have to build the application first before running the tests?

15 replies · 3 participants

gsr

02/26/2023, 1:20 AM

i am trying to call the component

component implements="IStringsFactory" {

the implements is in the same folder as component

interface {
    public ILocalizedStrings function getStrings(required string directory, required string defaultLocale);
}

i am getting an error

Could not find the ColdFusion component or interface com.IStringsFactory.

10 replies · 2 participants

gsr

02/26/2023, 1:20 AM

<cfset Application.factory = new appcfc.com.StringsFactory()>

Nick

03/01/2023, 8:46 PM

We have a legacy page (in CF2018) that calls another to do some processing through a cfhttp and then logs that it's complete:

<cfhttp url="#myURL#/processAction.cfm" timeout="10800" method="get" />

<cfquery name="insertLog" datasource="#myDSN#">
	INSERT INTO ActionLog
	   (ActionName,
	   Complete)
	VALUES
	   ('Process Action',
	   1)
</cfquery>

processAction.cfm

there's whole mess of logic ending with it's own INSERT into a DB log as the very last thing in the file. The issue is that

processAction.cfm

logs its final query around 30 minutes after being called, but the query above (right after the

cfhttp

) is timestamped 3 hours after being called, which corresponds to the

timeout="10800"

. What could cause

processAction.cfm

to reach its last line and finish its work in 30 minutes but not return a response to the

cfhttp

, causing the

cfhttp

to wait and wait till its timeout? (Again, this is legacy and I could rewrite it, but just trying to understand this behavior.)

5 replies · 3 participants

Prashant S

03/03/2023, 11:11 AM

@Prashant S has left the channel

Sean Callahan

03/07/2023, 10:08 PM

Just setup a dedicated VM running Windows Server 2012 with CF11 (up-to-date with hf19) to run a few legacy scripts that are not able to be refactored due to a need for a 32-bit ODBC connection. All of the scripts pull the data from a local ODBC and then push the data to our production server via

cfhttp

over an https protocol. What I can't seem to wrap my head around is that when I run these scripts in the browser using the resolved URL (not

localhost

, but that also works fine), all is right in the world. But when the scheduler runs them:

"Error","DefaultQuartzScheduler_Worker-1","03/07/23","13:55:27",,"Connection Failure: Status code unavailable "
coldfusion.tagext.net.HttpTag$HttpConnectionFailureException: Connection Failure: Status code unavailable
	at coldfusion.tagext.net.HttpTag.connHelper(HttpTag.java:1311)
	at coldfusion.tagext.net.HttpTag.runCall(HttpTag.java:1413)
	at coldfusion.scheduling.CronTask.execute(CronTask.java:121)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:207)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:560)

I already imported the production server's cert into the

castore

. Also the Root CA has been added to the

castore

17 replies · 2 participants

gsr

03/11/2023, 5:57 PM

bit of a strange error i am using forms on my page, and one of forms have enctype defined as multipart/form-data and whenever i am uploading i am getting an error which says

DetailThe files upload action requires forms to use enctype="multipart/form-data".
MessageInvalid content type: ''.

it seems its not picking up the file or something

coldfusion.tagext.io.FileUtils$CFFileNonMultipartException: Invalid content type: ''. at coldfusion.tagext.io.FileTag.uploadAll(FileTag.java:689) at coldfusion.tagext.io.FileTag.doStartTag(FileTag.java:411) at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3851) at

4 replies · 3 participants

epipko

03/11/2023, 7:48 PM

Wonder if someone can help me understand and fix this: I am trying to create .json file. When I dump variable - all looks good, but once I serialize it, for some reasons, "\" are added.

12 replies · 2 participants

epipko

03/11/2023, 7:49 PM

<cfset _PAYLOAD = serializeJSON(fulfillment_json)>

<cfoutput>#_PAYLOAD</cfoutput>

Payload: {"fulfillment":{"message":"Your package was shipped.","location_id":"30406673","tracking_info":{"number":"9405511206207180455478","url":"www.usps.com"},"notify_customer":false,"line_items_by_fulfillment_order":[{"fulfillment_order_id":5784060395699,"fulfillment_order_line_items":["{\"id\":12254030430387,\"quantity\":1},{\"id\":12254030463155,\"quantity\":1}"]}]}}

1 reply · 2 participants

epipko

03/11/2023, 7:51 PM

j.jpg