Oh, I must have messed up on the generator. I was trying to create one that ran on the 28th of each month, at 1 minute past midnight, this must be it 🙂 0 1 0 28 * ? *   ... View more

Ahhh, glad you pointed the time out, I was not using the tool correctly, I didn;'t realize I could set the seconds, minutes, hours etc on each tab to build the string up, Now it's right, this should be 1 minute passed midnight on the 28th, so basically as soon as the 27th ends, 1 minute later the task runs 0,28 1 0 28 * ? * ... View more

Thanks Charlie, that's a massive help, I did notice it but was not familiar with Quartz so ran in the other direction Using the Quartz generator I was able to create what I wanted, so if I want to run on the 28th of each month, I just add in  0 0 0 28 * ? *   Just need to give it a month now to see if it works 😉 ... View more

PERFECT. Thanks for very much for your help with this one. Sorry I didn't explain myself clearly enough at the start.   ... View more

It's not the numbers to the left that I need to get, it's everything left of the numbers on the right.   Examples: 123test456 Left side: 123test Right side: 456   test456 Left side: test Right side: 456   ... View more

Sorry I was not as clear as I could have been.   What I am trying to do is get the numbers on the right of the string (that works in the cfscript), but the second part is to get absolutely everything else to the left of those numbers, which is what this was doing Left side = #left(myString,(len(mystring)-(len(digits))))#   ... View more

Thanks again.   Unfortunately it did not work for the left side. It's giving an empty string, (tested using sdfsdfsdf3423) ... View more

I could slice it up with the following, but I'm wondering if you have anything that can go in the CFSCRIPT that would be a little more elequent   <CFSET Digits = #getEndDigitsFromString(myString)#> <b>Digit(s) from end of string: #digits#</b> <br><br> Left side = #left(myString,(len(mystring)-(len(digits))))# ... View more

Actually @BKBK Could you possibly help with taking this a little futher, so that I can retrieve not just the numbers at the end, but the other part to the left as separate values, so I've basically split it into two variables. THANKS! ... View more

Thanks @bkbkbk that's exactly what I needed.   I ran a few tests to see if I could trip it up and it works flawlessly   <CFLOOP list="somestring4567,some123string4567,123some123string4567,123somestring4567,123somestring,1234567,123_4567,123@4567" index="myString"> <cfoutput> String:#myString# <br> <b>Digit(s) from end of string: #getEndDigitsFromString(myString)#</b> </cfoutput> <br><br> </CFLOOP> ... View more

Thanks Charlie.    I'm just going to have to avoid/block webp for now. I was really hoping the latest version of CF would have been brought up to do with image handling   ... View more

Thanks Charlie. I've added a vote for what it's worth, if it's not in since 2021 I'm not holding out much hope. Webp is common now and I've tested it and found that it does bring very significant improvements of file size over other file types such as jpg and even PNG.   For now it looks like we'll have to just not allow wepb in, as it's too much of a pain to manually manage it   Btw I'm using CFIMAGE to initially find out what type of file was uploaded (it crashes with webp's), video,  audio or image. I then record several attributes from the file into the database, extension, height, width and filesize. I need the dimensions to manage the front end display as I only force reduction if it's over a certain width. I could manually type it in to each webp but what a pain that is, when it's automatic on all other formats. I could use CFFILE for some of this, find the extension and then avoid using CFIMAGE and ask for the dimensions. So there's a work around but it's for me. ... View more

Thanks for the input. The challange I have is that I'd want to retain the webp file as-is. I need to upload it through the dashboard, read and store it's attributes and then make it available for download. So I can't convert it. ... View more

I did not know that, I did a quick Google and it did look messy to install and possibly a little too out of date, I might avoid that 🙂 ... View more

Yes, I've had Notepad++ installed since this time but never used it, it's worth using just for the dark night mode and the lines numbers for the code so I can debug big pages, but I thought if I'm going to move to something else, I may as well look at something with more of a CF focus  ... View more

Thanks Charlie, that's a big help. I found VS Code https://code.visualstudio.com/ I'll check it now.   It's got to be an improvement over Notepad, although I've managed fine since CF 3.1 😉 , but I do think it's time to start using something that helps me out a little . ... View more

Thanks everybody for your input. I had a feeling there was either a simple answer to this, or it was going to be a pain.   Its a small project that I cant invest too much time into, and it does not have to scale either. The cookie approach by Ben looks very interesting. I will try to find a little time at the weekend to play around with it and see where it takes me. I'll report back 🙂 ... View more

I could seem to find the right link, I opened the console with F12, did an F5 refresh but could not find a GENERAL option.   Either way, I understand what you are saying. It is my domain, but I just put that there to post as a test in this thread. I guess the defaul now is Referrer-Policy:no-referrer. I'm not seeing complete refers from anywhere including Google which just gives https://www.google.com    ... View more

Try here http://aspirenet.com/testclick.html   THere's a link that will go to a cgi dump   The refer that I see is just aspirenet.com/   I am wondering if this is a browser issue, I've tried on a couple but maybe there have been changes to default to pass a minimum amount of data. ... View more

Thanks Charlie,   Btw In my administator is also says I have version 17.   Rather odd that it's working locally but not in production. I'll have to do a big search of all code on all sites and fix it all so I don't have to worry about it int he future. The kicker is that my development version won't through the error, so it's challenging to test until it's in prod 😞 ... View more

Thanks to both of you for the reply. Ouch, I'll have used a LOT of these. I'm going to have to do a mass search and replace. Hopefully it's just INT that is the problem, I may have used others such as VARCHAR. Any idea where I can find a list of valid ones? I'm going to have to fix this as I would like to upgrade in the future, so now I know for sure the code is not going to work above my current version and build.   I took a look at the development box log and it does show success 2793 Successes 0 Warnings 0 NonFatalErrors 0 FatalErrors   ... View more

I also had a problem with my sites throwing 500 errors, so I was pleased to see a fix above, but unfortunately the fix does not work for me   I performed the same update on my developer edition and it works fine. I've checked all of the settings including the version of JVM and everything appears to be identical.   The problem appears to be in CFQUERYPARAM, but not all of them. This WHERE for example will cause the 500 error WHERE enduser_uid = <cfqueryparam value="#GetEnduser.enduser_uid#" cfsqltype="CF_SQL_INT">   I tried to replace the #GetEnduser.enduser_uid# with a hardcoded value, it still crashed, but when I removed the cfqueryparam and used WHERE enduser_uid = 123456 the query works.   These all worked fine before the update, plus with having two systems the dev and prod and only one doing this, I'm at a bit of a loss.   Any ideas anybody? ... View more