This is perfect, thank you very much!!! ... View more

I suppose I could have been more helpful.  🙂   MariaDB 10.6.21   Coldfusion info #server.coldfusion.appserver# Tomcat #server.coldfusion.productlevel# Enterprise #server.coldfusion.productname# ColdFusion Server #server.coldfusion.productversion# 2023,0,11,330706 #server.os.name # Windows Server 2012 R2 #server.os.version# 6.3   I am imaging two variable, one for the start time and one for "now".  That way each time the widget loads it shows the count of the posts.  It does not need to be perfect or exact, it's a cycling forum, this is just something we've had for years and a recent update did away with the old widget and author of that widget.   cfset - start_time = one second after midnight cfest - end_time Now   For the query cfselect pid (int(10)) from forums_posts where post_date (int(10)) between #start_time# and #end_time#   post_date is a unix timestamp - that's the part I really need help with, along with how to get the one second after midnight variable. Then I'll just output a record count of the query. I don't think it matters, but the forums_posts table has a couple million rows.   Thank you ... View more

Is it correct now?  I unmarked my selection, I guess you solved so many issues I got a little silly.  🙂 Again, thank you ... View more

I added  localUrl="true" to both reports and the image displays correctly on the first report and the red x's in the checkboxes wente away.   Thank you! ... View more

OK, I seem to be having other issues.  Could it be related to the security certificate too? The image below is from a PDF I generate, the red x's are checkboxes.  They all load red in https, but function correctly (checked if indicated) using http. On another report an image on the server that is embedded also shows up as a red x unless I pull the report through http.   ... View more

I was not logging if it ran, simply relying on the output in the CF Administrator Scheduled Tasks list. This is an old site, most of the tasks were set up years ago.  It's an intranet in a very locked-down environment, so I don't worry much about security. Many of the tasks are very old and had http URLs, I just updated all of the others. This one was very noticeable because the task was logging people out of a page they abandoned and others were not able to get in, it's a one user at a time page.   Thanks again. ... View more

So let me see if I follow this.  The original "question" was #, and world-class CF experts gave astounding responses?  🙂 ... View more

Thank you Dave, that won't work then.    The form page has set fields for each row, but the numbers of rows are dynamic.  The update loops through the form when submitted. ... View more

Thank you all. Charlie, sorry for the use of the work LOCK, you are correct, I am blocking other users. This is an intranet for our department.  There might be 3 or 4 users at the most on this page at the same time. What I have done is, when a user first visits that page, a query is made to a table I created that stores the user ID.  If another user is currently using the page, the forms Submit button will not display, instead they will see a message that another user is currently using the page.  I have a scheduled task that will reset that user to 0 just over every 3 minutes, that way if a user simply closes the page, it is not left assigned to them. What I planned to do was redirect the person on the page after three minutes of inactivity to the home page.  If I redirect them first to the action page, will it submit their data?  That would be perfect. I understand this is not an elegant solution, but as a non-programmer, many of my solutions are not elegant. Thank you ... View more

I'm sure it's something I did.  I tried the option below.  After I enter one character in the form (if typed manually) it submits. I need to be able to type or scan the unit number into the form, then when the TAB character is received, submit the form. WolfShade  wrote You can even do it like so: <form id="testSubmit"><input type="text" id="testing"  /></form> <script type="text/javascript">     var testSubmit = document.getElementById('testSubmit'),           testing = document.getElementById('testing');     function submitIt(){testSubmit.submit();}     function blurIt(){testing.blur();}     testing.addEventListener('blur',submitIt);     testing.addEventListener('input',blurIt); </script> V/r, ^ _ ^ ... View more

WolfShade, you are awesome, thank you, I will test it next week when I am back to work. Thank you! ... View more

I am by no means an expert, and you've certainly received expert help, but can I ask why you'd use cftextarea over something like ckeditor? ... View more

Thanks Steve, I'm not worried about keeping the application safe or secure.  Yes, I really said that.  This is for our departments intranet, it's behind our firewall and only a few select people have access. I'd be curious to see what a regular expression would look like for this, I am always happy to learn, Thanks again. ... View more

Thank you, this is perfect! I did get an error that want me to change "unit" to "Unit", other than that this is exactly what I needed!!! ... View more

Sorry for the delayed reply, I've been off until now. Wow, I greatly appreciate this.  I have not tested it yet, but presume (based on your reputation) it will work.  ------- Update OK, so not being a JavaScript whiz, I am having trouble reading code / code... There are instructions that say code = ... and code.variable and you also named the field code. My field is named Unit.  I tried updating everything that said code to unit, but that failed.  I tried changing the field to code, but it's not working.  I am using a cfform with a cfinput.  I tried changing it to a regular input, still no luck. I'm sure the issues are all mine. ... View more

Thank you, I submitted a bug.  I may be able to migrate to CF10 in the next 6 months to a year, but this is disappointing for now.  Maybe they'll fix my bug today?  I appreciate your help! ... View more

Version: 9,0,0,251028 ... View more

Thank you, I tried your code to see if I could reduce one file directly on the server as compared to while I am uploading it.  The pdf is not protected and does have many images embedded. I get this error: An error occurred during OPTIMIZE operation in the cfpdf tag. Error: com.adobe.internal.pdftoolkit.core.exceptions.PDFCosParseException: Undefined filter - JPXDecode ... View more

Bump  ... View more

BKBK wrote: Oh, and I hope you have saved the application file as Application.cfc, with capital A. Why is that, I'm on a Windows server, I thought they weren't case specific.  I changed it anyhow. ... View more

I changed it to this:   <cffunction name="onApplicationStart" output="false" returntype="boolean"> and got this error: The value returned from the onApplicationStart function is not of type boolean. ... View more