Get the most recent entry for each group in sql server
To get the most recent entry for each named group within a sql server table table use partition and number rows by group as follows...
To get the most recent entry for each named group within a sql server table table use partition and number rows by group as follows...
In the last post in this series, we looked at how to add tags to an object uploaded to S3 via the AWS Java SDK. What if you need to change those tags? Are tags the only way to add metadata to objects in S3? Let’s file out.
From: Brian Klaas
As anyone who has worked in any of the major cloud service providers will tell you, there will be ever-increasing sprawl the more you use a cloud provider: more files, more servers, more databases, more accounts, more services, more everything.
From: Brian Klaas
When editing files of any kind, users of modern applications expect to have access to previous versions of the file, and undo work that they don’t like or made in error.
From: Brian Klaas
Sometimes it is necessary to disable remote validation calls when using jquery validate, fortunately its fairly straight forward.
In the last post in this series, we looked at Lifecycle Rules in S3, how they worked, and how you can use them to save money by automatically moving less-frequently used files to different (and cheaper) storage classes.
From: Brian Klaas
In my last post in this series, we looked at using different storage classes in S3 via CFML to save money on long-term storage costs.
From: Brian Klaas
With the state of the world right now I don't feel motivated to post about technology today. So instead some observations of the world.
Creating objects in ColdFusion has a performance impact that you need to consider when working with large datasets
Using a node version manager can cause gitkraken pre-commit hooks to fail with an error that npx or npm does not exist in the path.
Have you ever accidentally deleted the entire contents of a table and had to go spend an afternoon restoring everything from backups? Transactions are here to help you test your sql without all that pain.
This error when trying to change your AWS console password, 'Either user is not authorized to perform iam:ChangePassword or entered password does not comply with account password policy set by administrator' is a result of poor UX design.
Thanks to Brad Wood for refreshing my brain about how to configure the default cfengine on commandbox.
This is a utility function I've had around for formatting numbers into comma separated strings
Hey folks, we continue to grow and expand here at CFWT.
From: ColdFusion Muse
There's a fair amount of disingenuity, or perhaps just willful ignorance to the statistics here and I talk to a lot of people who are astonished that CFML is still in use due to the alleged massive numbers of vulnerabilities.
From: Coders Revolution
We provide W2 employment with benefits for remote workers (i.
From: ColdFusion Muse
I wasadding a feature to CommandBox CLIthis week when I typed up some code that iterated over the keys in a struct, filtering out the ones it needed and then performed an action on the matching ones.
From: Coders Revolution
DataBank has issued a Security Bulletin to all of their ColdFusion clients about the recent Adobe ColdFusion Vulnerability.
From: ColdFusion Muse
I know I know - it's only been a week since we picked up our 7th new 2019 team member, but we are at it again.
From: ColdFusion Muse
Here's a quick trick on working with a SQLite DB from CFML quicky and easily.
From: Coders Revolution
This post falls in the category of something that took me several hours to figure out and other people are not likely to figure it out on their own and I'm likely to forget it if I don't write it down! The problem is if you have a jar file with some 3rd party library that you want to use in Lucee.
From: Coders Revolution
This post falls in the category of something I hammered out for a client today and I thought to myself, "Wow, that's just obscure enough that no one would probably figure it out on their own.
From: Coders Revolution