Nick Kwiatkowski is presenting on API’s and ColdFusion at tonight’s Mid-Michigan CFUG meeting at 7 pm eastern time. Nick is going to show how he builds REST endpoints using the native Adobe ColdFusion and Lucee REST endpoint connector. He’s also planning on doing a deep dive into Postman showing all its features. Meeting URL: https://tinyurl.com/2s3mdcrr A recording will be available on our group’s YouTube channel in a few days at https://youtube.com/@cfml

i am trying to convert a php code to cf, here is my try please guide and correct me if i done anything wrong, i am not getting the right results here https://cffiddle.org/app/file?filepath=e9d5300f-28ec-4087-add8-61bbc2bf4f39/58495be[…]067-bf35-2fea2659f5e5/e5154b42-b117-42c7-9699-75b1a90722fc.cfm

@abram there might be a cert problem on the Lucee5 instance on trycf.com: https://trycf.com/gist/eb56e447dee8af59a8fe0df0a89f312e/lucee5?theme=monokai 4.5 & CF work fine.

what are people using for integrating with Google calendar these days? is the old GoogleCalv3 from Billy Eatman still working? I recall seeing a deprecation notice from Google not too long ago

we’ve recently had a site falling over when the MySQL db bugged out with “too many connections” errors - looking at the load balancer logs the origin IPs seem to be chinese but the URLs they’re requesting are all spoof domains ending in london.cloudapps.digital, does anyone know what the issue is there? why would they be spamming our load balancer for GET requests for a random domain?

or is that just a typical DDOS vector…

Hello All, I'm looking to implement SSO kind of feature with my APIs So basically i have a requirement where we have few APIs, and those APIs should be accessible from our authenticated clients. Like on single singin they can also access our APIs but with full authentication & security. Can anyone please suggest/guide me the best way to achieve this implementation. Thanks in advance

Hey does anyone use IntelliJ IDEA with the CFML plugin for CFML dev? I've been using VSCode, but we have IntelliJ for our other stuff and one of our devs noticed the plugin for it. Viable alternative to VSCode?

I’m trying to do some basic encryption for a password table in my database. I’m just testing the code right now before I commit. Here it is:`Çquery datasource="XXXXXX" name="q" sql="` select username, pw from user "; loop query="q"{ key = generateSecretKey('AES'); echo("Encrypted with ::>[ #key# ] - ") enc = encrypt(pw, key, 'AES') echo(enc & "<br><br>") dec = decrypt(enc, key, 'AES') echo("Decrypted with ::>[ #key# ] - #dec#<hr>") } </cfscript>

The decrypt function works on the first pass through of the looped query, without fail. Everything after that is a flop. I generate a new key on every pass thru and encrypt and decrypt with the same key. This is driving me bonkers. Am I doing something incorrectly here, or is this an issue with Lucee?

I'm using the Lucee engine version 5.3.9.166

Anyone know this guy named Ben Garrett?

I am trying to do some basic CF 2018 installation and I am getting Timed out trying to establish connection. I have everything setup on IIS and can get to my site. is this error related to SQL or is on the CF side? Has anyone had a similar issue when setting CF with an IIS site?

Has anyone successfully implemented push messages to s specific user from a CF/Lucee server to a PWA? I tried Google Firebase Messaging and the msg is sent and Google reports

success: 1

. But the message never arrives at the app (at least the event handler never fires). I also tried Mozilla messaging but it seems it needs an encryption algorithm that isn't available in CF Standard. So I'm kinda stuck and looking for advice on what I could try.

throwing this out for wider discussion, ACF and Lucee currently don't throw an error for an empty file when strict=true, I'm proposing making it throw? It's what makes sense, you can still do strict=false for the non sensical old behavior https://dev.lucee.org/t/filegetmimetype-throw-an-error-on-missing-empty-files-when-strict-true/11500

Reading the Adobe doc on onMissingTemplate(), it says to use an include, something like

include application.urls.404

instead of relocating to another page ala

location(url=application.urls.404, addToken=false)

Why is the include the "right" way and the relocate the "wrong" way?

I have a really strange one today. I use 8 char alpha-numeric strings for customerid in one of my apps. Been doing this for YEARS. today, cf2016 on windows, the strangest error happened, and it only (so far) has happened to this one customerid. The customerid is 304143e8, but when it comes back from the function below, it converts to 30414300000000. Its a pretty simple function for a pretty simple search and it was probably written 7+ years ago. (sorry, hit enter too soon) - Any ideas why it would only be replacing the last 2 chars with 8 0's?

<cffunction name="hotsearch" access="remote" returntype="array">
		<cfargument name="crit" type="string" required="yes">
		<cfset var rs=structnew()>
		<cfset var ra = arraynew(1)>
		<cfset ra[1]="NOT FOUND">
		  <cfquery name="getinfo" datasource="#variables.dsn#" maxrows="50">
			select cust_id,fname,lname,mycompany,company,webmail
			from vwSearchCustomer
			where 
				(webmail like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#arguments.crit#%">
				or lname like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#arguments.crit#%">
				or mycompany like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#arguments.crit#%">
				or company like <cfqueryparam cfsqltype="cf_sql_varchar" value="%#arguments.crit#%">
				)
			group by 1
			order by lname,fname,mycompany
			</cfquery>
			<cfif getinfo.recordcount gt 0><cfset ra[1]="OK"></cfif>
			<cfoutput query="getInfo">
				<cfset rs=structnew()>
				<cfset rs.PERSON=getInfo.cust_id>
				<cfset rs.PERSONNAME=getinfo.fname&" "&getinfo.lname>
				<cfif len(trim(getinfo.mycompany)) eq 0>
					<cfset rs.COMPANY=getinfo.company>
				<cfelse>
					<cfset rs.COMPANY=getinfo.mycompany>
				</cfif>
				
				<cfset rs.E=lcase(getinfo.webmail)>
				<cfset arrayappend(ra,rs)>
			</cfoutput>
		<cfreturn ra>
	</cffunction>

Does anyone have experience with doing chunked file posts to an endpoint? (I'm trying to post to microsoft graph's API )...

MAC M1 USERS - i need help. anyone running a mac m1 chip and commandbox with lucee able to connect to a mysql server? I'm getting a connection error which appears to be about the SSL.

Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
    at java.base/sun.security.ssl.HandshakeContext.<init>(Unknown Source)
    at java.base/sun.security.ssl.ClientHandshakeContext.<init>(Unknown Source)
    at java.base/sun.security.ssl.TransportContext.kickstart(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at java.base/sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
    at com.mysql.jdbc.ExportControlled.transformSocketToSSLSocket(ExportControlled.java:149)
    ... 212 more

I have googled it and tried passing

ssl=false

in the connection string, as well as

enabledTLSProtocols=TLSv1.2

with

ssl=true

but I'm still unable to get it to connect. my java version when running

box java list

shows

Java 11.0.15 (Eclipse Adoptium)
  /usr/local/bin/jre/
  This is the Java installation in use by the CLI, it cannot be removed.

openjdk11_jre_x64_mac_hotspot_jdk-11.0.17+8
  AdoptOpenJDK
  <https://adoptium.net/>

I have tried to connect to my remote mysql server which is version 5.7 and a localhost version which is 8.0.31 and neither will connect. yes, i do have valid credentials, firewall, etc. I'm able to connect to each server via navicat. any help is greatly appreciated.

Has anyone seen an isPOBox() function for CF (or anything else that I can use for inspiration) that does not need an external API call somewhere. It doesn't have to be perfect, its ok if a few slip through

API’s and ColdFusion with Nick Kwiatkowski video is now live It includes an in depth look at all the features of Postman. Subscribe to our channel at youtube.com/@CFML and click the bell to receive notifications every time we post something new.

i have one website with cflayout and i am going to convert it to jquery ui tabs, my concern is somewhat related/unrelated, there are files called on cflayoutarea and in one such file, the session.something is called, and it throws error if does not exists instead of just navigating to home page for login. i am thinking of two choices. 1. i should display a message in cflayout area itself that session expired, please relogin. 2. use jquery ui and if the session is expired to which it is calling, it will navigate to the login screen. i find the 2nd option valid but i have already implemented jquery idletimeout for session, so why that is not happening, if the session expired

considering using an ordered struct for something in lucee for the first time and i'm wondering if the ordered nature of the struct will be inherited by any nested structs inside of that main ordered struct, or whether any nested structs themselves must be declared as ordered prior to adding them?

Some generative art with ACF https://trycf.com/gist/91bbc6e1666891eac735e0b24f5171c7/acf2021?theme=monokai

Hey all, so my coworker did a clean of CF 2021 on an EC2 instance, and when he went into CfAdmin to add a datasource things worked just fine. then he went into datasources and tried to edit that datasource and it threw a CF error....so now we can't edit any datasources....anyone see this in their installs and if so, what might you have done to figure this out? CF error is Element urlmap.servicename is undefinded in STDSN....any thoughts?

Anyone got any thoughts as to what's going on here? https://trycf.com/gist/cde0e8800f7c962b9c232a35e2749def/acf2021?theme=monokai

Hi Everyone, I'm implementing a AJAX call and in URL trying to access the method of CFC from here, it's working fine but I'm curious to know about the request lifecycle in this case, actually i found that directly calling cfcs method it doesn't trigger OnRequest. I checked with dump and it's arriving into the OnRequestStart but not in OnRequest. Can someone help me to understand it?