Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Exit
EddieLotter
Advocate
EddieLotter
Advocate
Activity
‎Dec 21, 2018
06:00 AM
As long as you stick to ANSI SQL you will have no problem. It's only when you use features specific to Oracle that you will run into problems. I'm guessing the vast majority of the SQL statements you use in your apps are generic enough to work for both engines. That said, I would recommend posting this question in an Oracle forum where there are probably others who are already doing this and might have some vital information that will affect your decision.
... View more
‎Dec 14, 2018
11:30 AM
I won't have time to test this in my environment this week, but as a quick test, comment out the cfspreadsheet line and give GetData an arbitrary value so that the script completes without error. If the same sequence of events happens, then cfspreadhseet is unlikely to be the cause. If the behavior is different, then there is a possibility that there is a problem. As another test, you could replace cfspreadsheet with a binary read of the file and see if it affects the order of processing.
... View more
‎Dec 14, 2018
05:55 AM
Can you post a simplified but complete test case that demonstrates the problem? Also provide your versions of ColdFusion and JAVA.
... View more
‎Nov 15, 2018
01:23 PM
Then you need to encapsulate the logic so that there is no duplication and it can be called from a link or from a scheduled task.
... View more
‎Nov 15, 2018
12:37 PM
Why bother "opening" the links? You have the logic that created the links. Use the same logic to send the e-mails in your scheduled task.
... View more
‎Oct 23, 2018
06:36 AM
1 Upvote
Your lock is being applied too late, and worse, you are locking and unlocking in a loop. Your first block of code should protect all application variables that are being changed: <cflock scope="application" timeout="40" type="exclusive"> <cfset application.init_datetime = now() /> <cfset application.NEWSlist = new components.root().NEWSlist() /> <cfset application.newsArray = ArrayNew(2) /> <cfset variables.count = 1> <cfloop query="application.NEWSlist"> <cffile action="write" file="#this.webrootmapping#images\z#variables.count#.jpg" output="#application.NEWSlist.media_file#" nameconflict="overwrite" /> <cfset application.newsArray[variables.count][1] = application.NEWSlist.uuid> <cfset application.newsArray[variables.count][2] = application.NEWSlist.TITLE> <cfset application.newsArray[variables.count][3] = application.NEWSlist.media_file> <cfset variables.count++> </cfloop> </cflock> Your second lock should use the same scope (application) but can use the ReadOnly type.
... View more
‎Oct 16, 2018
06:11 AM
As a test, make the database query return only about ten records. Does the ColdFusion script complete with such a small result set?
... View more
‎Oct 12, 2018
05:57 AM
Use the evaluate() function. #evaluate(Text)#
... View more
‎Oct 10, 2018
07:54 AM
For this test, the credentials don't matter. Did you test using "localhost" instead of the domain in the URL?
... View more
‎Oct 10, 2018
07:42 AM
kt03 wrote I then try to manually copy the url and run it in the browser and it worked. Are you doing that on you workstation or on the server? You need to log into the server and use a browser on the server to test accessing the URL. It is possible that the address is working from a workstation, but not on the server itself. You can try to use "localhost" for the ColdFusion task, since the task is running on the server.
... View more
‎Oct 10, 2018
07:11 AM
kt03 wrote I save the file into log to find out if permission related it. The log show No authentication........ What specifically is not authenticated?
... View more
‎Oct 10, 2018
06:50 AM
kt03 wrote I didn't get anything. What are you expecting to get?
... View more
‎Sep 26, 2018
10:13 AM
1 Upvote
I bumped into this issue myself today. I remembered this thread and found it with a search. Thank goodness for BKBK​'s response, the following works without error in CF11: <cfscript> cities = queryNew('cityID,cityName','varchar,varchar'); queryAddRow(cities,2); querySetCell(cities,'cityID','1',1); querySetCell(cities,'cityName','New York',1); querySetCell(cities,'cityID','10',2); querySetCell(cities,'cityName','St. Louis',2); queryService = new query(); queryService.setAttributes(someQueryArg=cities); queryService.setDbType('query'); queryService.setName('ScriptQuery'); result = queryService.execute(sql='SELECT * FROM someQueryArg'); writeDump(var=result, label='result', showudfs='false'); </cfscript> Cheers Eddie
... View more
‎Sep 20, 2018
06:22 AM
ColdFusion is automatically converting all single quotes in stype to double quotes. To prevent it, do this: and serie in (#preserveSingleQuotes(stype)#) Note that this is only safe if you are hard-coding values for stype. If stype ever gets values from the user then it is more secure to use cfQueryParam.
... View more
‎Sep 06, 2018
07:46 AM
1 Upvote
I have never used CFPOP, but (as far as I'm aware) POP3, as a protocol, has no concept of read/unread mail. Asking for a list of messages will provide all messages that have not been marked as deleted.
... View more
‎Jul 27, 2018
06:00 AM
Add the type="html" attribute to the cfmail tag and remove the leading slash in the br tag. Cheers Eddie
... View more
‎Jul 05, 2018
07:55 AM
@Charlie%20Arehart, it only happens to people who have ColdFusion installed on the same computer with which they're using Dreamweaver. I admit, it is annoying. Cheers Eddie
... View more
‎Jul 05, 2018
07:42 AM
WolfShade​, you will find this article informative: final, finally and finalize() in JAVA - When to use What https://www.go4expert.com/articles/final-finally-finalize-java-t28061/ Cheers Eddie
... View more
‎Jun 21, 2018
09:11 AM
Go to Tracker and click on "Add Bug" at the top of the page. You can include a link to this conversation in your description. Thanks. Cheers Eddie
... View more
‎Jun 21, 2018
08:56 AM
Holy smokes! I was setting thisDate to various dates to test the logic and they all worked out. When I set thisDate using your example the logic fails! I have narrowed the problem down to the DateConvert() function. Although the value displayed looks correct, internally the date object seems to be corrupt which is causing problems during comparisons. This is a reproducible bug and I urge you to log it with Adobe. As a work-around, change the line <cfset thisDate = DateAdd('h',(application.GMTOffset*-1),DateConvert("local2utc", Now()))> to <cfset thisDate = dateTimeFormat(DateConvert("local2utc", Now()))> <cfset thisDate = DateAdd('h',(application.GMTOffset*-1),thisDate)> Basically, I'm using dateTimeFormat() to convert DateConvert() to a string and then DateAdd() converts it to a valid date object which compares correctly in your logic statements. Cheers Eddie
... View more
‎Jun 21, 2018
07:38 AM
The reason I am persisting in the investigation is because I don't think the problem is where you think it is. Your getDate() function is returning a date object, not a date string, so the ParseDateTime() function should not be necessary. Please add (temporarily) the line that I suggested in my original reply and post the results for thisDate, d1 and d2. That way we can see visually whether or not d1 and d2 have the correct values based on what is actually in thisDate. Cheers Eddie
... View more
‎Jun 21, 2018
07:05 AM
I'm glad you got it sorted out, but I'm not clear which function you say is working differently. If you have the time, would you mind elaborating? Cheers Eddie
... View more
‎Jun 20, 2018
12:48 PM
It's probably a transcription error, but there is no GetDate() function in CF, you probably mean Now() right? Also, your comments talk about 10PM, but 21:00 is 9PM. It's also worth pointing out that the values you assign to d1 and d2 are strings until you do some date arithmetic on one or the other. This might be causing you problems later. Try to stick with date types throughout. Other than that, the code works as expected for me on CF 11. Add the following line at the end of your example code to see all your variables: <cfdump var="#variables#" showudfs="false" > Cheers Eddie
... View more
‎May 18, 2018
11:27 AM
Please post an example of the cf tag and parameters that is failing. Cheers Eddie
... View more
‎Apr 25, 2018
06:21 AM
cfqueryparam is definitely the more robust option. Glad you got it sorted out. Cheers Eddie
... View more
‎Apr 24, 2018
06:40 AM
I'm not familiar with Oracle, but see if you can do something similar to the following: where LCase(columnA) like '%searchword%' Cheers Eddie
... View more
‎Apr 24, 2018
06:29 AM
Sorry I'm late to the party, but surely line 9 should be: values(#colA#, #colB#, #colC#) If any of them are not numeric, remember to include quotes. Cheers Eddie
... View more
‎Apr 13, 2018
06:50 AM
Thanks for reporting back. This will certainly help others. Cheers Eddie
... View more
‎Mar 23, 2018
02:43 PM
See Manipulate PDF forms in ColdFusion https://helpx.adobe.com/content/help/en/coldfusion/developing-applications/working-with-documents-charts-and-reports/manipulating-pdf-forms-in-coldfusion.html Cheers Eddie
... View more
‎Feb 27, 2018
07:48 AM
You need to join your tables. Read the documentation for your database engine on how to join tables. Cheers Eddie
... View more
Copyright © 2025 Adobe. All rights reserved.
AdChoices