Adobe Community: Message List - Getting Started

Re: Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 22:00:01 GMT

I guess that should work, as val() attempts to convert numeric strings to numbers. You might consider moving away from Access as your database though as it really is not intended to be used as a web application back-end. Microsoft SQL Server Express is free and works fine for small databases.

-Carl V.

Re: Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 21:51:42 GMT

I used val(columnName) it seems to work with Access 2010. Please let me know if I'm wrong otherwise thank you for pointing to the right direction.

Re: Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 21:28:46 GMT

Hi Carl, For this particular app., I'm using access 2010

Re: Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 20:55:04 GMT

You don't specify what database system you are on. Assuming SQL Server, how about:

order by CAST(prices AS decimal(8,2))

That assumes you might have prices that are not whole units of currency (up to six digits to the left of the decimal and two to the right). You might need to adjust the scale and precision to your needs. If the prices are always whole units of currency, then you could replace "decimal(8,2)" with "int".

-Carl V.

Ordering data type varchar

forums_noreply@adobe.com — Wed, 12 Nov 2014 20:25:49 GMT

I keep forgetting on how to order a column with datatype varchar

One of my column for pricing has these values: 5,12,15,18,21,23,31 etc when I cfoutput my query result I got the list showing as: 12,15,18,21,23,31,5

It should be from less price to higher prices: 5,12,15,18,21,23,31 but I can't make this happening because the datatype for this column is varchar.

I know there is a way around but I can't remember, can someone help me?

My query is real simple:

select ranges, prices

from fees

order by prices and this doesn't work

Re: compare values

forums_noreply@adobe.com — Thu, 06 Nov 2014 13:31:37 GMT

Hi,

If your query name is "myquery" and the status column name is "status" then you can check like below:

<br />

#myquery.status#

#myquery.status#

</cfif>

</cfoutput>

If you want same status continuously then you can use order by in your query.

Re: compare values

forums_noreply@adobe.com — Sat, 01 Nov 2014 11:33:57 GMT

</cfif>

</cfoutput>

</cfif>

Re: compare values

forums_noreply@adobe.com — Mon, 27 Oct 2014 19:55:46 GMT

Let's say the query name is "qry" and the column name is "booln".

A query object is really an array.

<cfif>

HTH,

^_^

Re: Using NVL in Query of Query resulting in error

forums_noreply@adobe.com — Tue, 21 Oct 2014 22:18:27 GMT

NVL is an Oracle function, and is not available in ColdFusion Query of Query. If you are trying to check for null values, then use IS NULL or IS NOT NULL. So

WHERE NVL(Rel2_2,' ') <> ' '

AND NVL(p_ln2,' ') = ' '

AND NVL(p_fn2,' ') = ' '

becomes

WHERE Rel2_2 IS NOT NULL

AND p_ln2 IS NULL

AND p_fn2 IS NULL

-Carl V.

Using NVL in Query of Query resulting in error

forums_noreply@adobe.com — Tue, 21 Oct 2014 21:46:43 GMT

I'm still using CF8 and Oracle 11G back-end.

When I use NVL in the query of query I got error....Can't I use NVL to check on null value? Please help

Here is my codes:

SELECT CamID2, rel2_2,p_ln2,p_fn2,ins,l_year

FROM prt_temp

WHERE Ins = 'CC'

AND l_year = '1481'

	AND NVL(Child_LN2,' ') <> ' '
	AND NVL(Child_FN2,' ') <> ' '

</cfquery>

	<cfif GetC2.Recordcount NEQ 0>
	<cfquery name="CheckRel2C2" dbtype="QUERY">
	SELECT CamID2, rel2_2
	FROM GetC2
	WHERE NVL(Rel2_2,' ') <> ' '
	AND NVL(p_ln2,' ') = ' '
	AND NVL(p_fn2,' ') = ' '
	AND Ins = 'CC'
	AND l_year = '1481'
	</cfquery>

</cfif>

The error:

Error Executing Database Query.

Query Of Queries syntax error.

Encountered "NVL ( Rel2_2 ,. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,

compare values

forums_noreply@adobe.com — Tue, 21 Oct 2014 16:35:50 GMT

Hi,

I have the query with out put below for one field as an example

Status

------

yes

i want to be able to do the compare for ALL status in one field but don't know how to do it, Can anyone plz help? Thanks

<cfif all status = "yes" ---> display Yes

<cfelseif all status = No -- display No

<cfelse> Other

</cfif>

Unix Time (mtime)?

forums_noreply@adobe.com — Fri, 03 Oct 2014 12:57:32 GMT

I have a command line that finds files in a folder and deletes the ones that are a over a day old. I can't seem to find a way/the write code to change the 1 (full) day into a half day (12) hours (f -mtime +1 -exec rm -rf {} ) = older than a day. Do you need to convert into milliseconds and then figure out what a half day is in milliseconds?

Re: Please reset activation count for my adobe account vishnu.bovilla@gmail.com

forums_noreply@adobe.com — Tue, 30 Sep 2014 22:38:18 GMT

Hi Vishnu,

Can you please explain the issue and mention the product. If it is an issue with Product activation(ColdFusion Builder) then you can send an email at cf.install@adobe.com. If you have any other product please contact our chat support they will help you.

Thanks,

Priyank

Re: Can't verify MySQL DataSource

forums_noreply@adobe.com — Tue, 23 Sep 2014 14:02:15 GMT

I had the same problem with CF 11 and CF 10 on Mac, running Mysql with MAMP Pro. What I did in the end was a combination of these steps, I don't know if all are necessary but at least it works now

1. In MAMP pro go to -> file > edit template > MYSQL my.cnf (after you shut down the server)

2. Comment out MAMP_skip-networking_MAMP

3. Added: max_connections = 1000 (in section [mysqld])

4. Restart server in MAMP

5. In CF datasource I changed server settings to 127.0.0.1 port 3306

Please reset activation count for my adobe account vishnu.bovilla@gmail.com

forums_noreply@adobe.com — Fri, 19 Sep 2014 09:42:29 GMT

Please reset activation count for my adobe account vishnu.bovilla@gmail.com

Re: dataLabelStyle="value"

forums_noreply@adobe.com — Fri, 12 Sep 2014 08:54:36 GMT

@Dolfan Alex

It will be more fruitful to start your own new thread. The technology, Coldfusion versions and people have moved on.

Re: dataLabelStyle="value"

forums_noreply@adobe.com — Thu, 11 Sep 2014 14:11:56 GMT

I ran webcharts.bat and even in the designer, it seems like a global variable unfortunately (running CF 10 here). So at least as of CF10 I don't think there was a way to do this.

Re: dataLabelStyle="value"

forums_noreply@adobe.com — Thu, 11 Sep 2014 13:30:05 GMT

I am sorry to see there was never a solution here. I have the same issue.

Re: Serial Number

forums_noreply@adobe.com — Thu, 04 Sep 2014 12:21:25 GMT

Hi Derrick,

BKBK is correct. You should post Master Collection queries in the relevant forums. Meanwhile, I have sent you a pm, with the requested information.

Hope this helps.

Regards,

Anit Kumar

Re: Serial Number

forums_noreply@adobe.com — Thu, 04 Sep 2014 12:11:29 GMT

Nano, nano! You landed on the wrong planet, mate. Navigate to the Adobe intergalactic forum and take the correct turn, likely towards Adobe Creative Cloud.

Serial Number

forums_noreply@adobe.com — Wed, 03 Sep 2014 22:34:49 GMT

I had the Master Collection 3 installed on an old laptop. I brought the software through my school's program. A few years after, I bought the MC 4 upgrade through my school. Since, I have had to purchase a new computer and I tried to install the MC4 upgrade. I can only use a trail version for 30 days because I need the MC 3 serial number which I cannot find.

Is there a way to retrieve the serial number associated with my account or Adobe ID? I have the serial number for the MC suite 4 but it will not activate unless I enter the MC suite 3 serial number. Hence, I can only use it on a trail basis for 30 days.

Thank you in advance.

Re: Coldfusion 10 64 bit developers edition

forums_noreply@adobe.com — Fri, 22 Aug 2014 14:50:01 GMT

No we don't have that. Our app is on servers hosted by a third party.

Re: Coldfusion 10 64 bit developers edition

forums_noreply@adobe.com — Fri, 22 Aug 2014 13:32:24 GMT

Yes, this is still possible to download the installer from your Adobe Volume Licensing account, if you own the product.

Carl Von Stetten wrote:

If you had a Standard or Enterprise license, you might be able to get it from the Adobe volume licensing, but I'm not sure if that's true anymore.

-Carl V.

Regards,

Anit Kumar

Re: Coldfusion 10 64 bit developers edition

forums_noreply@adobe.com — Thu, 21 Aug 2014 22:21:40 GMT

Not from the Adobe downloads site. For some undisclosed reason (probably related to a 3rd party license), they installers had to be removed from the downloads site around the time CF 11 was released. If you had a Standard or Enterprise license, you might be able to get it from the Adobe volume licensing, but I'm not sure if that's true anymore.

There is a community-supported repository of ColdFusion installers that Gavin Picken maintains here: http://tinyurl.com/cfdownloads. Unfortunately, it is offline at the moment but hopefully will be back soon.

-Carl V.

Coldfusion 10 64 bit developers edition

forums_noreply@adobe.com — Thu, 21 Aug 2014 21:32:26 GMT

I have a new 64bit laptop that I plan to use for developing. I am working on a project that uses CF 10. I'd really like to get a copy of the 64 bit CF 10 so I can install the developer version on my laptop. Is there any way to get one? I have a copy of the 32 bit installer on my current laptop, but I don't really want to install that version.

Re: Problem installing CF10 on Ubuntu 12.04

forums_noreply@adobe.com — Wed, 13 Aug 2014 21:36:45 GMT

A lot later...

...just to say that I had the same error just now and did a Google, only to find my own complaint!!!

However, the problem was indeed to do with hostnames.

I just edited /etc/hostname to contain "myserver.mydomain.com"

did "hostname myserver.mydomain.com"

/etc/init.d/apache2 restart

/opt/coldfusion10/cfusion/bin/coldfusion restart

and all was good...

Re: Re: Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Tue, 12 Aug 2014 16:29:23 GMT

You need to put some alert statements into your script to ensure that (a) execution is reaching that part of the script and (b) the script is dealing with expected values.

For example:

alert(document.getElementById('listofids'));

var allArray = document.getElementById('listofids').value.split(",");

alert(allArray[0]);

and:

ProdRev = document.getElementById('Mfg_Spec_Prod_Approval_Rev'+allArray[i]);

alert(ProdRev);

Re: Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Tue, 12 Aug 2014 16:12:54 GMT

Eddie,

This doesn't do anything. I can't even get the error to show up on the first row now. Do you want me to post the entire page of code? Any other ideas?

Andy

Re: Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Tue, 12 Aug 2014 15:19:10 GMT

In your original script, remove the two lines:

ProdRevValue = ProdRev[ProdRev.selectedIndex].value;

ProdInitValue = ProdInit[ProdInit.selectedIndex].value;

and change your two conditions to:

if(ProdInit.selectedIndex != 0 && ProdRev.selectedIndex == 0) {

...

}

else if(ProdRev.selectedIndex != 0 && ProdInit.selectedIndex == 0) {

...

}

I'm assuming your "listofids" is providing the expected values.

Re: Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Tue, 12 Aug 2014 14:52:28 GMT

Eddie,

I actually got this javascript below to work so if one drop down is left blank, and the other one is filled out, an error will pop up saying to entering either some initials or a rev. The only problem is that I have a dynamic list of drop downs in rows, so I need this javascript to run for each row. If I do the 1st row with 1 drop down selected and the other not, it gives me the error, which is perfect. But if I want the 2nd row to error out, for instance, doing the same thing, the error will not pop up. How do I make this work so it does this for each row since the list of drop downs is dynamic? My drop down menu names are Mfg_Spec_Prod_Approval_Initials and Mfg_Spec_Prod_Approval_Rev.

function verify() {

var Mfg_Spec_Prod_Approval_Initials = document.getElementById('Mfg_Spec_Prod_Approval_Initials');

var Mfg_Spec_Prod_Approval_Rev = document.getElementById('Mfg_Spec_Prod_Approval_Rev');

if(Mfg_Spec_Prod_Approval_Initials.selectedIndex == '' && Mfg_Spec_Prod_Approval_Rev.selectedIndex != '') {

alert('select Initials!');

return false;

}

else if(Mfg_Spec_Prod_Approval_Rev.selectedIndex == '' && Mfg_Spec_Prod_Approval_Initials.selectedIndex != '') {

alert('select a Rev!');

return false;

}

return true;

}

</script>

Andy

Re: Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Mon, 11 Aug 2014 16:20:54 GMT

This isn't a ColdFusion issue, however the solution is to validate with "ProdRev.selectedIndex == 0". In other words, check the value of selectedIndex.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Sat, 09 Aug 2014 14:21:04 GMT

Hey, no sweat, as you can probably tell, I'm not an advanced programmer and I do appreciate being one of the many that you've assisted on this forum so thanks. Bug submitted Thanks for sticking with this issue to the end!

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Sat, 09 Aug 2014 10:02:43 GMT

Thanks for your explanation. My bad: it is now clear I misunderstood. Sorry.

Apparently, in dateCompare, Coldfusion implicitly converts date2 to local UTC. I agree with you that this kind of interpretation is inadmissible. The developer should be the one to do the interpretation, and Coldfusion should simply compare the 2 values passed to the function. You should indeed report a bug.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Sat, 09 Aug 2014 04:31:19 GMT

The code in your question is not definitive enough for a straight answer. To expose the bug, you need to select a timeDate value for date2 which is in between your Now() and dateConvert('local2Utc', now()) (1 hour in your case). So just copy the code below and make sure to select an appropriate value for date2 taking into account when you're running the test. Note that I'm outputting the values for date1 and date2 to the screen so you can see the "absolute values" they resolved to prior to dateCompare(). What I find on both my remote and local servers (CF10) is that instead of comparing with the date1 (UTC time as displayed on the screen) it compares with the now() time.

<p>dateCompare(date1, date2 ) = #dateCompare(date1, date2 )#</p>

</cfoutput>o

This is what was output to the screen

Time of test = {ts '2014-08-09 14:18:42'}

date1 = {ts '2014-08-09 04:18:42'}

date2 = {ts '2014-08-09 13:20:00'}

dateCompare(date1, date2 ) = 1

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Fri, 08 Aug 2014 17:36:18 GMT

web-eng wrote:

Are you simply asserting that it doesn't interpret? I found that it does which is why it's a bug. I gave you an example, did you run that code to check?

Just to be sure we're talking about the same thing, do you mean this code:

<p><cfoutput>#dateCompare(date1, date2 )#</cfoutput></p>

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Fri, 08 Aug 2014 16:39:22 GMT

Are you simply asserting that it doesn't interpret? I found that it does which is why it's a bug. I gave you an example, did you run that code to check?

Not sure why you're advising me to get the UTC equivalent of each dateTime value when that is exactly what I'm already doing in my "procedure that I’m using that requires copying a string" above.

Using Javascript to require 2 drop down menus to have something selected

forums_noreply@adobe.com — Fri, 08 Aug 2014 14:59:52 GMT

Hi everyone. I'm trying to get 2 drop down menus to each have something selected when the form is submitted. I'm using javascript for this, but I can't get it to work. Basically, if one is blank and the other one isn't, I want an error to pop up saying they have to fill in the one that is blank and vice versa. What am I doing wrong? Here's what I have for the javascript and on the form below. My 2 drop down names are Mfg_Spec_Prod_Approval_Initials and Mfg_Spec_Prod_Approval_Rev. Thanks for anyone's help!

Andy

function verify() {

var partNumber = '';

var ecoNumber = '';

var ProdInit;

var ProdInitValue='';

var ProdRev;

var ProdRevValue='';

var allArray = document.getElementById('listofids').value.split(",");

var error=false;

for(var i=0;i<allArray.length;i++) {

ProdRev = document.getElementById('Mfg_Spec_Prod_Approval_Rev'+allArray[i]);

ProdInit = document.getElementById('Mfg_Spec_Prod_Approval_Initials'+allArray[i]);

ProdRevValue = ProdRev[ProdRev.selectedIndex].value;

ProdInitValue = ProdInit[ProdInit.selectedIndex].value;

if(ProdInitValue != '' && ProdRevValue == '') {

error=true;

ecoNumber = document.getElementById('ECID'+allArray[i]).value;

partNumber = document.getElementById('Part_Number'+allArray[i]).value;

alert("You must enter a Rev for ECO " + ecoNumber + " Part Number: " + partNumber);

}

else if(ProdRevValue != '' && ProdInitValue == '') {

error=true;

ecoNumber = document.getElementById('ECID'+allArray[i]).value;

partNumber = document.getElementById('Part_Number'+allArray[i]).value;

alert("You must enter your initials for ECO " + ecoNumber + " Part Number: " + partNumber);

}

if(error) {

return false;

}

else {

return true;

}

</script>

Start of form

<option value="#Initials#"

<cfif #Initials# EQ MfgSpecProdInitials>selected</cfif>>#Initials#</option>

</cfloop>

</select>

</cfif>

</td>

<option value="#Doc_Rev_Initials#"

<cfif #Doc_Rev_Initials# EQ MfgSpecProdRev>selected</cfif>>#Doc_Rev_Initials#</option>

</cfloop>

</select>

</cfif>

</td>

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Fri, 08 Aug 2014 10:45:44 GMT

Again, dateCompare does not interpret. We developers do or should. To avoid any ambiguity related to time zones, the developer should first obtain the UTC equivalent of each of the two datetime values to be compared.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Fri, 08 Aug 2014 04:00:29 GMT

"CreateDateTime(2014,08,07,15,30,00) is an absolute value of datetime." Yes yes, it is an absolute value! DateCompare compares two absolute date values, well it seems as though it should after all the description is "Performs a full date/time comparison of two dates." Doesn't actually say "comparison of two absolute dates" but surely that's what it means. Let me also say that I've never come across any other coldfusion tag or function reinterpreting a date based on my location unless specifically specified. In fact, when I set my value for date1 using <cfset date1 = DateAdd("s", GetTimeZoneInfo().UTCTotalOffset, now())> dateCompare seems to accept that date as absolute and doesn't need to reinterpret it. The fact that dateCompare gets all 'interpretive" based on how date1 is set still seems like a bug.

The statement in bold is true when taking into account the context of your location being +1hour, which was included in the qualification of the statement.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Thu, 07 Aug 2014 17:32:59 GMT

web-eng wrote:

Now create a dateTime using CreateDateTime(2014,08,07,15,30,00) This time half way between your local dateTime and UTCDateTIme.

<cfset date2 = CreateDateTime(2014,08,07,15,30,00)>

This is where "comparing like with like" is relevant. The statement marked in bold is an assumption. As such, it can be false!

CreateDateTime(2014,08,07,15,30,00) is an absolute value of datetime. It contains no information about your geographical location, and so can be greater than or less than your local datetime, depending on your time zone.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Thu, 07 Aug 2014 16:36:46 GMT

Hmmm, like with like and all other good practices aside, there is a bug. Also, like just about everyone else, I develop locally in one timezone +10 hours and run my sites remotely on a different timezone -5 hours, altogether a significant time difference. So after coming to understand how to deal with the bug I've come up with a way to compare dateTimes on the remote server, but it does require a spot of copying a string in where you've been advising not to.

First, to the dateCompare() bug. To expose the bug we better use a finer increment than days, so instead of specifying, simply leave the “datepart” attribute empty so that it defaults to seconds. You say you’re in a +1hour timezone so try this.

Presuming a local time of 16:00 on August 7^th 2014

<cfdump var="#date1#"> should produce {ts '2014-08-07 15:00:00'}

Now create a dateTime using CreateDateTime(2014,08,07,15,30,00) This time half way between your local dateTime and UTCDateTIme.

Now compare them <cfdump var="# DateCompare(date1, date2 )#> in this example on your local server, you would expect to return a -1 since date1 is earlier, but in fact it will return a +1 because it seems to be somehow only looking at the now() time (later) instead of the UTC converted time. This is a bug, DateCompare should not care where it gets its data from it should simply get it and then compare the two values. Usually there is no problem using dateCompare but when used in conjunction with the DateConvert('local2Utc', now()) it ignores the value generated by the conversion. Anyway, so much for the bug, Now to the procedure that I’m using that requires copying a string.

I’m wishing to compare a dateTime that I want something to stop being displayed on the remote server.

<cfset myDate = CreateDateTime(2014,08,05,17,0,0)>

<cfset myDateInUTC = DateAdd("s", GetTimeZoneInfo().UTCTotalOffset, myDate)>

<cfdump var="#myDateInUTC#">

This produces the string: {ts '2014-08-15 07:00:00'} .

I then generate currentUTCDateTime from:

Both these dates are then compared thus:
DateCompare(currentUTCDateTime, "{ts '2014-08-07 15:00:00'}" )

I have to generate the string on my local server and then upload it which is why I’m unable to simply use a function. It’s a bit convoluted but it does work. Note that in this example I’m setting the currentUTCDateTime using DateAdd instead which doesn’t trip up like DateConvert.

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Thu, 07 Aug 2014 12:02:10 GMT

web-eng wrote:

The smart money according to many is to "always refer to UTC time" so that code can be used on any server and that sounds good to me.

Indeed the gist of the matter, spot on: compare like with like. So, what you apparently want is, either

Re: Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Thu, 07 Aug 2014 11:30:41 GMT

It's been a while, must admit, I was left a bit confused about the whole thing as it just didn't add up when I ran my code. Spent hours today playing with this and have worked a few things out, unexpected things ......

My local time zone is UTC +10 hours and my remote server is UTC -5hours.

The smart money according to many is to "always refer to UTC time" so that code can be used on any server and that sounds good to me. So, what I want to do is a comparison between current UTC time and a dateTime of my choice. First of all I'm getting UTC time like this <cfset Date1 = DateConvert('local2Utc', now())> and when run on my local server indeed brings up a time that is exactly 10 hours earlier, great right. Then I create a date of my choosing using CreateDateTime() according to your own good advice. Then I compare them using DateCompare and voila, instead of date2 being compared against the value I generated for date1 it compares with the value for now() (server time).

For the code below, I only have to wait until date1 = {ts 2014,08,07,11,03,46} before it returns a 1, 10 hours earlier than expected. I tested the exact same code on my remote server and the times were off by 5 hours which represents that servers time zone. If I replace the dateConvert statement for date1 with a createDateTime statement everything works fine without any offset. Looks like a bug to me.

<p>Date 1 = #date1#</p>
<p>Date 2 = #date2#</p>
<p>#DateCompare(date1, date2 )#</p>

Re: Created a Global UDF but don't know how to call it, please assist

forums_noreply@adobe.com — Wed, 06 Aug 2014 19:46:28 GMT

Based on that code, you would refer to it as "URL.UDF.getMessage()".

Where does the line "cfset structAppend(url,createObject( "component", "UDF" ))" actually occur inside Application.cfc (above any function definitions or inside one of the functions)? If it's at the top of the component definition, that UDF gets instantiated on each request and put in that page's URL scope. Does the UDF component maintain state in any way? If not, and you make sure all of its methods are thread-safe, I would just store it in the application scope like this:

Put that in your onApplicationStart() method in Application.cfc so that it is only instantiated once. Then call it's methods from anywhere in your application as "application.UDF.getMessage()".

-Carl V.

Created a Global UDF but don't know how to call it, please assist

forums_noreply@adobe.com — Wed, 06 Aug 2014 19:01:25 GMT

I created a cfcomponent and a bunch functions inside it. One of the function needs to call a process that is also needed by other part of the application. Since this "process" is needed in a different parts of the application, I decided to make this "process" a global function that can be called from any part of the application. I found a blog from Ben Nadel that explained exactly what I need. But the problem is I don't quite understand how to call the globa UDF, his explanation is not clear to me. Ben created UDF.cfc:

cfcomponent output="false" hint="I define the application settings and event handlers.

cffunction name="getMessage" access="public" returntype="string" output="false" hint="I return a test message."

     -- Here is where I wrote the process needed by different parts of the application --

        cfreturn "I am defined in the UDF component"
       cffunction

cfcomponent

On the Application.cfc he created a URL scope: cfcomponent output="false" hint="I define the application settings and event handlers."

Define the application:

cfset this.name = hash( getCurrentTemplatePath() )
cfset this.applicationTimeout = createTimeSpan( 0, 0, 5, 0 )

        Add all of our "global" methods to the URL scope. Since
        ColdFusion will automatically seach the URL scope for
        non-scoped variables, it will find our non-scoped method
        names:

cfset structAppend(url,createObject( "component", "UDF" ))

cfcomponent

The part that I don't understand is, how to call getMessage method? Is it: application.cfc.UDF.getMessage(parameter1,parameter2) ??

Re: Writing to a file

forums_noreply@adobe.com — Thu, 24 Jul 2014 16:26:18 GMT

Circumstances may justify file storage (though, as you later revealed, that doesn't apply to you). Think, for example, of the absence of a database connection or of a database with a lock and excessive traffic. File storage even has pride of place in certain areas. Most applications in fact store configuration information on the file system, which they then update throughout the working life of the application.

Having said that, I should hasten to add that I agree with the other posters: a database is preferable to a file for this kind of storage. However, I would be less negative in my appraisal of file storage in general. At least, not until I know the circumstances.

I would choose MySQL. If for whatever reason you have to use MS Access - I have heard about a System Admin who imposed it on his Developer colleagues - then do so by all means. It will still be a step in the right direction.

Re: Writing to a file

forums_noreply@adobe.com — Thu, 24 Jul 2014 15:03:29 GMT

Your application doesn't use a database at all? I find that a little strange and at the same time Interesting. First, don't use MS Access for well, anything. If you don't have a DB use something like Mysql. It is free and works very well.

Re: Writing to a file

forums_noreply@adobe.com — Thu, 24 Jul 2014 14:51:17 GMT

Thank-you for your concerns.

I am open to other methods to accomplish the same thing, but need a little more help than simply "write it to a database". I would likely need use MSAccess as the database for this counter if I'm going to go this method.

I'm willing to learn!

Graham.

Re: Writing to a file

forums_noreply@adobe.com — Thu, 24 Jul 2014 14:28:49 GMT

This is an incredibly bad way to manage this information - so bad it cannot be measured with existing technology.

Store the number in a DB, not in a file to be read/written to frequently. Too many factors that can cause this to go belly up.

Re: Writing to a file

forums_noreply@adobe.com — Thu, 24 Jul 2014 14:24:20 GMT

While BKBK does give you a way that it will work I am wondering why you would even do this? This has more ways it could fail than I can count. Among them, you could easily have a lock left behind on the file thus making it unreadable. You should really be storing this data in a database not a file.

--Dave