Adobe Community : All Content - Getting Started

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

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>

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,

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?

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

Can't verify MySQL DataSource

forums_noreply@adobe.com — Sun, 08 Nov 2009 19:30:12 GMT

Hi There,

I've got problem with setting up a new DataSource on MySQL 4/5 driver. From the beginning:

1. I've installed ColdFusion 9 (Developer Edition), with JRun 4 option. I've done configuration of Apache (conf file, and execution file)

2. When i want to set up new DataSource with MySQL 4/5 driver, i'm getting error.

For Example:

CF Data Source Name: MyDataSource

Database: MyBase

Server: localhost

Port: 3306

Username: user

Password: password

After that. I have information:

Connection verification failed for data source: MyDataSource

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3
times. Giving up.

The root cause was that:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:
Could not create connection to database server. Attempted reconnect 3
times. Giving up.

The, in DataSource menu in Administration i see that base, but with this error under entry with name of DataSource.

What i'm doing wrong?

I have tried to install MangoBlog, but i can't do this with that issue. When i try, i get:

Could not find the ColdFusion component or interface CFIDE.scripts.MangoBlog_1.4.1.components.utilities.PreferencesFile.

I think it's about that error which i've described.

Anyone got some ideas to this ?

Greets,

Rafal

dataLabelStyle="value"

forums_noreply@adobe.com — Fri, 13 Feb 2009 05:10:37 GMT

Repost, really need help.

I have 3 cfchartseries within my cfchart. I want to display the values for one of the cfchartseries only, so I use
dataLabelStyle="value", which works.However,the other two cfchartseries also have their values displayed even though I do not have dataLabelStyle in them. I only want one of the cfchartseries to display the values.

What am I doing wrong, or what is going on here, can somebody please explain this to me ? Does dataLabelStyle even work ?

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.

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.

Problem installing CF10 on Ubuntu 12.04

forums_noreply@adobe.com — Thu, 14 Feb 2013 12:13:13 GMT

Just been trying to install CF10 with Apache2 and it was all looking reasonably good, but when I try to use the CFIDE adminstrator, I get a Tomcat error:

HTTP Status 500 -

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: java.lang.NullPointerException coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:129) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:662)

root cause

java.lang.NullPointerException coldfusion.CfmServlet.init(CfmServlet.java:82) coldfusion.bootstrap.ClassloaderHelper.initServletClass(ClassloaderHelper.java:121) coldfusion.bootstrap.BootstrapServlet.init(BootstrapServlet.java:59) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:203) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:662)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.23 logs.

Apache Tomcat/7.0.23

The coldfusion-error.log seems pretty harmless:

Feb 14, 2013 1:06:16 PM org.apache.catalina.core.AprLifecycleListener init

INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /opt/coldfusion10/jre/lib/amd64/server:/opt/coldfusion10/jre/lib/amd64:/opt/coldfusion10/ jre/../lib/amd64:/opt/coldfusion10/cfusion/lib:/opt/coldfusion10/cfusion/lib/_ilnx21/bin:/ opt/coldfusion10/cfusion/lib/international::/usr/java/packages/lib/amd64:/usr/lib64:/lib64 :/lib:/usr/lib

Feb 14, 2013 1:06:16 PM org.apache.coyote.AbstractProtocol init

INFO: Initializing ProtocolHandler ["ajp-bio-8012"]

Feb 14, 2013 1:06:16 PM org.apache.catalina.core.StandardService startInternal

INFO: Starting service Catalina

Feb 14, 2013 1:06:16 PM org.apache.catalina.core.StandardEngine startInternal

INFO: Starting Servlet Engine: Apache Tomcat/7.0.23

Feb 14, 2013 1:06:21 PM org.apache.catalina.util.SessionIdGenerator createSecureRandom

INFO: Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [5,003] milliseconds.

Feb 14, 2013 1:06:24 PM org.apache.catalina.core.ApplicationContext log

INFO: ColdFusionStartUpServlet: ColdFusion: Starting application services

Feb 14, 2013 1:06:24 PM org.apache.catalina.core.ApplicationContext log

INFO: ColdFusionStartUpServlet: ColdFusion: VM version = 20.4-b02

Could not determine local hostname.

Any other diagnostics I should include?

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>

Why is there an offset when using DateConvert with DateCompare?

forums_noreply@adobe.com — Wed, 05 Mar 2014 07:40:27 GMT

I'm developing on my local server and my current timezone is GMT +11 hours.

So, I was expecting that when I ran this code:

#DateCompare(date1,date2,'d' )#

that it would return a "-1" but it returned a "0" implying that the "day" was the same.

So, to double check I output:

DateConvert("Local2UTC", now())

grabbed its displayed value : {ts '2014-03-05 07:08:58'} and inserted that for comparison thus:
DateCompare("{ts '2014-03-05 07:08:58'}",date2,'d' ) and sure enough, it did return a "-1" reflecting that the day of date1 is indeed earlier than date 2.

Further investigation showed that I had to add my timezone difference to date2 in hours thus:

<cfset date2 = '2014-03-06 11:00:00> to get

#DateCompare(date1,date2,'d' )#

to return a "-1".

Is this a bug or am I misinterpreting??

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) ??

Do cold fusion pages get search engine placement?

forums_noreply@adobe.com — Thu, 02 Jul 2009 13:11:36 GMT

I'm new to cold fusion. I've been reading a couple of books. Following the layout ideas in one of those books I have developed a small cold fusion site. Nothing much to speak of and very basic. My homepage is a straight .html file (good for search engines). However, following the layout of the book, all of the rest of my pages are .cfm.

I use a "sitewrapper" which creates my header, left side, right side and footer automatically for each .cfm page. The content (which goes between the left and right) is .cfm files. All of the copy for each page is in the included files.

So my question is this: will search engines index the .cfm pages when they are "included" from another page? I don't really know how SEs work in that do they read the file in each page (.cfm or .html) or is it the "combined" output that the browser sees/outputs?

I would have to have to hardcode all of the individual pages in order to return a higher SE placement if that can be avoided. Each "section" has a separate header/footer based on what section the user is in.

Thank you in advance for any and all help/advice you can give. It is very much appreciated.

CF noob trying to learn ...

Writing to a file

forums_noreply@adobe.com — Tue, 22 Jul 2014 16:06:32 GMT

hi everyone,

I have a file that only contains a number in it (invoice number). Every time someone submits a form, it should increase the value of the number in the file by one.

It's my understanding that the file should be "locked" while it is being written to, so it does not give a duplicate amount if two people submit at the same time. Upon updating the file, it would then unlock the file, so it could then be written to by the next transaction.

The file would exist in the same folder as the form.

That's just my speculation as to how I think it should work. Basically, Open file, Lock file, write to file, unlock file.

Does anyone know of any tutorials that would show how to do this?

Thanks!

Adobe Coldfusion Enterprise and Developer

forums_noreply@adobe.com — Sat, 19 Jul 2014 21:52:25 GMT

Where do I actually develop a web app? Enterprise or Developer? Do I need Developer?

Installing ColdFusion 11 in Windows 8.1

forums_noreply@adobe.com — Sat, 12 Jul 2014 22:45:10 GMT

I can't no longer download the 30 days trial for CF 10, all I can see is CF 11 when I go to http://www.adobe.com/go/trycoldfusion/ It is OK for me to try CF 11, it is not a problem because I have not submitted a purchase request to my department. I have no difficulties installing CF 11 on my Windows 8, the problem is on how to configure CF to work with IIS or vice versa. I found some suggestion to modify IIS8 into IIS7, I did it but I still can't get it to work with CF11. Now I already have IIS 7 instead of 8 and I still can't open my website nor CF administrator. I got internal server error message 500. Is this because I have to install some CF hot fixes or something else? there are not too many tutorials out there with CF 10 or 111 and Windows 8 IIS. Is there any easy step by step instruction either from Adobe or someone who has successfully install CF10 or 11 and don't mind sharing it with me?

Updating shopping cart merchant gateway info

forums_noreply@adobe.com — Wed, 09 Jul 2014 14:58:18 GMT

I have been recently approached by a client that has an older site that was originally created on the ColdFusion platform, where the shopping cart merchant gateway has changed to a new provider and their merchant account credentials must be changed to continue taking orders. The original site developer is no longer available and I have been approached to make the update. I work with other Adobe Applications but am not too familiar with CF. Can anyone suggest where in the system I could change the merchant payment gateway credentials?

Thanks

How to convert minutes to decimal

forums_noreply@adobe.com — Mon, 30 Jun 2014 16:16:50 GMT

I need to convert my minutes in my HH:MM record to decimal.

For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours

and if i have 10 hours and 30 minutes I need to return 10.50 hours.

How do I do this?

Incorrect string value

forums_noreply@adobe.com — Mon, 12 May 2014 13:25:46 GMT

Hi - we've just upgraded from cf8 to cf9 and are getting a fair few of these errors - "Error Executing Database Query. Incorrect string value: '\xE2\x80\x8BWe ...' for column" as we try to insert a row in the db.

The query is inserting the following string "We are seeking a" - nothing innocuous in the text and certainly no instance of this string '\xE2\x80\x8B' (despite what the error message says).

Has anyone else run into this, any ideas what's going on?

Thanks very much for any help you can offer as I'm completely stuck.

Thank you.

Kind regards,

Nick

Purchased ColdFusion 10: Having problem with session variables

forums_noreply@adobe.com — Mon, 23 Jun 2014 17:43:40 GMT

My Dept. has just bought CF10 and I'm finally updating my existing web app to CF10 from CF8. My First Problem with CF10 is using session variables.

When using the lower version of CF (since CF 4 to 8) I have never had any problem setting up session variables and getting or using these variables in other pages after a successful login but with CF 10 it seems setting session variables and using them in other pages are a major problems. I'm not sure where have I done wrong in the codes.

First I'm setting the session in my Application.cfc This way:

	<cfset THIS.Name ="MyNewApp"/>
	<cfset THIS.ApplicationTimeout = CreateTimeSpan(0,0,20,0) />
	<cfset THIS.SessionManagement ="YES"/>
	<cfset THIS.SessionTimeout = CreateTimeSpan( 0, 0, 20, 0 ) />
	<cfset THIS.SetClientCookies = false />

</cffunction>

</cffunction>

		<cfset session.loggedin = "NO">
		<cfset session.username = "">
		<cfset session.userrights = "">
		<cfset session.usergroup = "">

</cffunction>

</cfcomponent>

After login, user is validated and set values to those session.variables:

........user validation codes here......................

<cfabort

	<CFSET qUserGroup = LoginObj.getUserGroup('#Trim(Form.username)#')>
	<cfloop query="qUserGroup">
	<cfset session.usergroup = user_group>
	<cfbreak>
	</cfloop>

<!--- ****************** ???????????????????????????????????????????????????????????????????????????

When I do cfdump in at this level, I can see that all of these session variables have been assigned to their values.

But these session variables are not accessible from other pages. Other pages still show these session variable without its value.

So, when I use these cfdumps in the index.cfm it is shown as they're not yet assigned with any values ****************** --->

</cfif>

In index.cfm, Before Login I got:

session.loggedin = NO

session.username = ["empty string"]

session.userrights = ["empty string"]

session.usergroup = ["empty string"]

After a successful Login:

session.loggedin = NO

session.username = ["empty string"]

session.userrights = ["empty string"]

session.usergroup = ["empty string"]

Have I done something wrong? These codes work on CF8. Please help.

I need to mentioned:

CF10 is in Linux and my web app is under https not http. But these session variables should be shared bentween http and https because some older application are still in http.

How to turn this Java into something I can use in CF?

forums_noreply@adobe.com — Mon, 09 Jun 2014 14:17:55 GMT

Hi - Following on from a recent post about how to strip our special characters from a string before insertion to the db I have found this Java code - my question is, how can I turn this into something I can use with CF? I think I need to use the cfscipt tag but that's right on the boundaries of my knowledge base.. If anyone could please help I'd be ever so grateful - thank you!

package net.htmlescape;

/**

* HtmlEscape in Java, which is compatible with utf-8

* @author Ulrich Jensen, http://www.htmlescape.net

* Feel free to get inspired, use or steal this code and use it in your

* own projects.

* License:

* You have the right to use this code in your own project or publish it

* on your own website.

* If you are going to use this code, please include the author lines.

* Use this code at your own risk. The author does not warrent or assume any

* legal liability or responsibility for the accuracy, completeness or usefullness of

* this program code.

public class HtmlEscape {

private static char[] hex={'0','1','2','3','4','5','6','7','8','9','a','b','c','d','e','f'};

/**

* Method for html escaping a String, for use in a textarea

* @param original The String to escape

* @return The escaped String

public static String escapeTextArea(String original)

{

return escapeSpecial(escapeTags(original));

}

/**

* Normal escape function, for Html escaping Strings

* @param original The original String

* @return The escape String

public static String escape(String original)

{

return escapeSpecial(escapeBr(escapeTags(original)));

}

public static String escapeTags(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i])

{

case 60:out.append("<"); break; //<

case 62:out.append(">"); break; //>

case 34:out.append("""); break; //"

default:found=false;break;

}

if(!found) out.append(chars[i]);

}

return out.toString();

}

public static String escapeBr(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i])

{

case '\n': out.append("<br/>"); break; //newline

case '\r': break;

default:found=false;break;

}

if(!found) out.append(chars[i]);

}

return out.toString();

}

public static String escapeSpecial(String original)

{

if(original==null) return "";

StringBuffer out=new StringBuffer("");

char[] chars=original.toCharArray();

for(int i=0;i<chars.length;i++)

{

boolean found=true;

switch(chars[i]) {

case 38:out.append("&"); break; //&

case 198:out.append("Æ"); break; //Æ

case 193:out.append("Á"); break; //Á

case 194:out.append("Â"); break; //Â

case 192:out.append("À"); break; //À

case 197:out.append("Å"); break; //Å

case 195:out.append("Ã"); break; //Ã

case 196:out.append("Ä"); break; //Ä

case 199:out.append("Ç"); break; //Ç

case 208:out.append("Ð"); break; //Ð

case 201:out.append("É"); break; //É

case 202:out.append("Ê"); break; //Ê

case 200:out.append("È"); break; //È

case 203:out.append("Ë"); break; //Ë

case 205:out.append("Í"); break; //Í

case 206:out.append("Î"); break; //Î

case 204:out.append("Ì"); break; //Ì

case 207:out.append("Ï"); break; //Ï

case 209:out.append("Ñ"); break; //Ñ

case 211:out.append("Ó"); break; //Ó

case 212:out.append("Ô"); break; //Ô

case 210:out.append("Ò"); break; //Ò

case 216:out.append("Ø"); break; //Ø

case 213:out.append("Õ"); break; //Õ

case 214:out.append("Ö"); break; //Ö

case 222:out.append("Þ"); break; //Þ

case 218:out.append("Ú"); break; //Ú

case 219:out.append("Û"); break; //Û

case 217:out.append("Ù"); break; //Ù

case 220:out.append("Ü"); break; //Ü

case 221:out.append("Ý"); break; //Ý

case 225:out.append("á"); break; //á

case 226:out.append("â"); break; //â

case 230:out.append("æ"); break; //æ

case 224:out.append("à"); break; //à

case 229:out.append("å"); break; //å

case 227:out.append("ã"); break; //ã

case 228:out.append("ä"); break; //ä

case 231:out.append("ç"); break; //ç

case 233:out.append("é"); break; //é

case 234:out.append("ê"); break; //ê

case 232:out.append("è"); break; //è

case 240:out.append("ð"); break; //ð

case 235:out.append("ë"); break; //ë

case 237:out.append("í"); break; //í

case 238:out.append("î"); break; //î

case 236:out.append("ì"); break; //ì

case 239:out.append("ï"); break; //ï

case 241:out.append("ñ"); break; //ñ

case 243:out.append("ó"); break; //ó

case 244:out.append("ô"); break; //ô

case 242:out.append("ò"); break; //ò

case 248:out.append("ø"); break; //ø

case 245:out.append("õ"); break; //õ

case 246:out.append("ö"); break; //ö

case 223:out.append("ß"); break; //ß

case 254:out.append("þ"); break; //þ

case 250:out.append("ú"); break; //ú

case 251:out.append("û"); break; //û

case 249:out.append("ù"); break; //ù

case 252:out.append("ü"); break; //ü

case 253:out.append("ý"); break; //ý

case 255:out.append("ÿ"); break; //ÿ

case 162:out.append("¢"); break; //¢

default:

found=false;

break;

}

if(!found)

{

if(chars[i]>127) {

char c=chars[i];

int a4=c%16;

c=(char) (c/16);

int a3=c%16;

c=(char) (c/16);

int a2=c%16;

c=(char) (c/16);

int a1=c%16;

out.append("&#x"+hex[a1]+hex[a2]+hex[a3]+hex[a4]+";");

}

else

{

out.append(chars[i]);

}

return out.toString();

}

coldfusion 11 I've installed it - how do I get to cfadmin?

forums_noreply@adobe.com — Tue, 17 Jun 2014 20:14:44 GMT

Hi, I've installed CF11 on Mac Mavericks.

What's the url to cfadmin?

http://127.0.0.1:8500/CFIDE/administrator/index.cfm doesnt work

and neither does http://127.0.0.1:8600/CFIDE/administrator/index.cfm

Any ideas?

Thanks

Windows firewall configuration

forums_noreply@adobe.com — Sun, 11 May 2014 21:40:57 GMT

What steps need to be taken with the firewall to permit access in the LAN to the development server running Cold Fusion's built-in web server? Simply opening port 80 doesn't seem to be sufficient; by default, Windows 2008 Server R2 is still blocking the programs themselves. Pasted below is one example, from a block notification, but I need a complete list so that I can be sure I've permitted access to everything that's needed. Even though the access is just from within the LAN, for testing purposes (at this time), I still like to keep the firewall running as a best practice.

Cheers,

Shane

Windows Firewall was unable to notify the user that it blocked an application from accepting incoming connections on the network.

Reason: The application is a system service

Application Path: C:\coldfusion11\cfusion\db\slserver54\bin\swagent.exe

IP Version: IPv4

Protocol: TCP

Port: 20003

Process Id: 1444

User: SYSTEM

Moving to CF10, Need help with Application.cfc

forums_noreply@adobe.com — Wed, 23 Apr 2014 20:44:58 GMT

I've been googling about how to work with Application.cfc since last week but I still have some questions and I can't find the answers.

My application is under the root (in unix) and there are many subfolders underneath it. Each sub-folder is hosting a different web application.

From what I read, I can create 1 root Application.cfc and then on subsequent sub-folder, when I need to have another Application.cfc on that level, I can create ProxyApplication (see below) and then create a sub-folder level Applicatin.cfc

So, when I set an application.DSN on my root Application.cfc, using proxyApplication I don't have to reset this dsn again in my sub folder level Application.cfc

Since my loginform.cfm and loginaction.cfm is right under root directory too, I also set OnsessionStart in the root Application.cfc to handle user login. Then this means, I don't have to reset session variable again anywhere because session.username, etc has been set on the highest level.

Is this correct?

In addition, Am I correct when I do the following:

1. Since I have root level and sub-folder level Application.cfc, I should set this.name with a different name, am I right?

On the root Application.cfc I set this.name = "StudentServices" because this represent the global application

On the sub-folder level's Application.cfc, I set this.name to "StudentServices_stdLoad" becaus this sub-folder only handle student load application.

2. On the root Application.cfc, I set the DSN to the application scope. So on the sub-folder level Application.cfc I can check if a particular db is working or not

because as awhole, in the global sense, this web application uses more than one Databases. Each sub-folder may use a database that is dfferent than the other sub folder.

Am I doing the right thing? Please advice

Below is example of what I have, Thank you!

I created a root Application.cfc under the root directory:

</cffunction>

</cffunction>

</CFCOMPONENT>

Then, in this root directory I also created a ProxyApplication:

</cfcomponent>

Then in the Sub-Directory, I can create a sub-folder level Application.cfc extending the root Application.cfc:

<cftry>

SELECT Count(*)

FROM MyTable

cfquery>

</cfcatch>

</cftry>

</cffunction>

</CFCOMPONENT>

</cffunction>

</cffunction>

Can CF5 be installed on Windows 7 Prof. Platform in a Windows XP Prof. Virtual Machine?

forums_noreply@adobe.com — Wed, 08 Dec 2010 17:25:03 GMT

I am trying to install Cold Fusion 5 on a Windows 7 platform in a XP Professional Virtual Machine. The software installed with no issues. However, I have run into a problem with configuring the software.

It has been 8 years since I last installed the software (on a Winows 2000 Professional platform) as the part of a certificate program, which I completed successfully and with many kudos at the time.

When I try to "browse a .cfm from my old class project ", in ColdFusion Studio, it says I need to do Server Development Mapping.

I log into the CF Admiistrator and enter the logical name. But when I try to browse to retreive the physical location, I dont see the directory list, but instead the icon for "Not Found".

Can this software be loaded in a Virtual Machine environment, and if so, what do I need to do to remedy my problem?

How to add a character at the end of an array element that meets certain criteria.

forums_noreply@adobe.com — Wed, 02 Apr 2014 17:15:15 GMT

Hi. I am using CF 9.2.1. I started learning CF yesterday, and I am trying to figure out a way to add a special character (like "?", "!"," & ") to an array row if the first row element (say, element [1][1]) has a specific letter like " t" in the word it is holding. In this case the special character will be added at the end of the last row element (element [1][3]).

Example: The take columns are: "Firstname", "Lastname", "Age". If Firstname contains an "s" or "S" (in any order) then add "!" at the end of the row so that :

Sam, Rubins, 26 !

Nick, Palo, 32

Robert, Williams, 28

Oscar, Ramirez, 23 !

I tried using the ReReplace, Refind and the #findoneof functions. I could probably loop through the array and return a value and store, while storing the value in a separate variable and using an if/Boolean function to compare that value and so on.... But I am sure there's an easier and more efficient way. Thanks in advance.

<h4> Number1. City info TABLE contents:</h4>

#City# #State# #LCode#<br>

</cfoutput>

</cfloop>

<h4>Number2. City info ARRAY contents before appending:</h4>

City: #cityarray[Counter][1]#,

Estate: #cityarray[Counter][2]#,

Code: #cityarray[Counter][3]#<br>

</cfoutput>

</cfloop>

<h4>Number3. City info Array contents after adding Irving, TX and updating L.A.:</h4>

City: #cityarray[Counter][1]#,

Estate: #cityarray[Counter][2]#,

Code: #cityarray[Counter][3]#<br>

</cfoutput>

</cfloop>

<br>

<h4>Number4. City info after searching for "s"</h4>

City: #cityarray[Counter][1]#,

Estate: #cityarray[Counter][2]#,

Code: #cityarray[Counter][3]#,

#findoneof("sS",cityarray[Counter][1])#

<br>

</cfoutput>

</cfloop>

Installation fails on Windows 2012

forums_noreply@adobe.com — Wed, 15 Jan 2014 00:27:42 GMT

Hiya,

I installed CF 10 yesterday and all went OK. Ran the updates, added a few datasources and then found out that CF files only got parsed when called as ./ (rather than ./index.cfm or ./anything-else.cfm). Googled the issue, tried to run the Web Server Configuratin Tool, but that failed to work, soin the end I decided to reinstall CF10. That appeared to have been a very stupid decision.

The installation fails now. I tried several times, rebooted the server, etc. but every time, at the end of the installation process (when it tries to install the Web Server Connectors) an error pops up 'ExecutiveAppCmd.exe has stopped working'. I have no other option than to kill that process. The installation finishes, but calling any .cfm file results into a HTTP Error 404.3 - Not found.

I ran out of options. Anybody around here have any idea how I can tackle this?

TIA!

pete

CF10 Install freeze on Add Web Server Configuration

forums_noreply@adobe.com — Wed, 05 Mar 2014 18:25:48 GMT

Installing CF10 64-bit Dev edition on Win 7-64 and Apache 64 bit. When I get to the Add Web Server Configuration and click on the Configuration Directory button to open the directory tree, the install freezes. I have to stop the install using the task manager. Any ideas what is causing the problem. It's like the java app for the directory tree is not initializing and just freezing up everything. Java 7 update 25 is installed.

I was running CF9 with no problem on this machine. It was uninstalled before doing the CF10 install. I had no problems installing CF10 on my other machine

thanks,

Doug

ColdFusion 8 System Requirement

forums_noreply@adobe.com — Tue, 04 Mar 2014 07:01:34 GMT

Dear All,

May I know the min system requirement installation of ColdFusion 8 Application Server? Can it install & run in Windows Server 2008 with IIS 7.5?

Which supporting library / software is required if any (such as Java?)?

Also, is it possible to export all settings in ColdFusion 8 Server and import to the new one?

Don't quite get it,how to use init() properly

forums_noreply@adobe.com — Fri, 21 Feb 2014 17:19:02 GMT

Hi, I'm still confuse with the use of init() with cfc.

If I only have the init function on my cfc but I don't set anything within the init(), for example:

</CFFUNCTION>

</CFFUNCTION>

</CFFUNCTION>

</CFFUNCTION>

</cfcomponent>

Need Help with CFINVOKE

forums_noreply@adobe.com — Tue, 11 Feb 2014 16:58:52 GMT

I don't usually get this type of error message when using cfinvoke this way (see below) but this time I keep getting this error no matter how I modify my logic or my codes.

I've spent a week trying to find what's going on and could not find the answer. Can anyone help please?

This is the last modification I made with my codes and I still can't get pass this section due to the error message.

This expression must have a constant value.

RowIteration.cfc: line 107

105 : ThisRowNo="#Trim(arguments.ThisRowNo)#"

106 : Camp="#arguments.Campus#"

107 : LYear="#arguments.LYear#">

Here is how my codes, it used to work when I do it this way:

<cfinvoke component="MyComp.PComp.CheckRow" method="ValidateRow"

                                                                 arr="#arr_ThisRow#"
                                                                   Camp="#Trim(Institution)#"
                                                                   LYear="#Trim(load_year)#"
                                                                   ThisRowNo="#Trim(var_Count)#">

</cfloop>

</CFIF>

<!--- I can't get pass this cfinvoke! I used to be able to invoke other method within cfc and my other apps are still working when I'm doing

it this way. I have never gotten this type of error --->

<CFINVOKE component="MyComp.PComp.ValFields" method="CheckReqFields"

st_ReqFields="#st_ReqFields#"

ThisParent="1"

ThisRowNo="#Trim(arguments.ThisRowNo)#"

Camp="#arguments.Camp#"

LYear="#arguments.LYear#">

</'CFCOMPONENT>

etc...

</CFFUNCTION>

</CFCOMPONENT>

changing all page

forums_noreply@adobe.com — Sun, 02 Feb 2014 13:04:23 GMT

hi my website to all pages changing.

how specific part of the page is changed on all pages

help me please

kasko hesaplama

Question?

forums_noreply@adobe.com — Tue, 04 Feb 2014 18:35:26 GMT

TO... to who? Who do we send these files to?

Please reset my activation count for my adobe id

forums_noreply@adobe.com — Mon, 03 Feb 2014 21:44:57 GMT

Please reset my activation count for my adobe id roman.salamonov@hotmail.com

Flipping between main keyframes.

forums_noreply@adobe.com — Fri, 31 Jan 2014 10:29:00 GMT

Hi, I was wondering if anyone knew how to flip between the main keyframes you make? (Flash pro)

I would need to be able to flip from frame 1 - 9 and not have to go through 123456789 each time. this is very important for me for my workflow.

I only know that it is possible to flip each frame so far, with , and .

it doesnt look like this feature exists yet, but is it possible to script this into the program or something like this? It would be really helpfull for my job. It's the way old classic disney animators animate, and so should the rest of the world be able to do

The measuring tool and scale ratios

forums_noreply@adobe.com — Sat, 07 Dec 2013 17:17:37 GMT

For mac users-

I use Adobe to open and work with Architectural plans. The measure tool has been a valuable partner in working up bids and scaling things when no measurements exist. However, no one has addressed how to use the scale tool for these type of drawings. Here is what I have come up with. Hold the option key and click the drawing and the change scale ratio menu appears. If your drawing says 1/4=1' use .25 in the scale ratio / select inch = use 1 in the next window / and ft in the last.

Any of these digits should get you an accurate scaling of your document providing it was scanned properly. I have been looking for a list like this for years. I hope it helps you.

.50 for 1/2" = 1'

.1250=1/8"=1'

.25 for 1/4=1'

.37 FOR 3/8=1'

.75 FOR 3/4=1'

0.09375 FOR 3/32 =1'

.189 FOR 3/16 =1'

0.0625=1/16 = 1'

0.0425 =1/20 =1'

Accessing Login page from CF

forums_noreply@adobe.com — Fri, 24 Jan 2014 16:23:47 GMT

My dept is using one asp web app and one cf web app.

Both apps. kind of related, many people use both, sometimes at the same time.

To access these two apps, admin and users are using the same username and password.

I'm trying to build a login interface on the CF app. for users to login into the asp application, eliminating the need for users to open

another when they are already in the CF app.

So I use CF Hot Link technique (using cfhttp url="url for the asp login UI"> and I got the asp login screen show up on my CF web app.

How can I get this login "talk" to the action page on the asp side? is it even possible?

Thanks,

Alec

how to create a app from existing webpage

forums_noreply@adobe.com — Mon, 27 Jan 2014 21:04:50 GMT

I have a webpage already want to make a app also can u help

Please select another location to extract the installer to

forums_noreply@adobe.com — Thu, 06 Sep 2007 02:37:28 GMT

At first I though this to be a Vista issue, but it happens on XP as well. I have downloaded both the Trial and the Dev editions, (appear to be the same), and after initial extraction I get "Please select another location to extract the installer to:". Thoughts. I am running as Administrator on both systems. I'd really like to check 8 out.

How to submit form by clicking on hyperlinks

forums_noreply@adobe.com — Wed, 22 Jan 2014 14:43:18 GMT

Hi there,

I've an <a href="a">A</a> and <a href="b">B</a>. I want to know which letter user cliked on so that I can run a database query.

How can I do this. Any ideas?

Thanks

Joe Green

PS CS6 locks up

forums_noreply@adobe.com — Sun, 26 Jan 2014 21:16:15 GMT

I work with PS CS6 and sometimes when I use the dodge tool (o) the program locks up and I have to force the program of and then begin alla over again. It has never happened to me before. (before CS6) Whats the problem?

how to generate a csv report to determine paper size in a pdf or pdf/a file ?

forums_noreply@adobe.com — Mon, 20 Jan 2014 03:59:09 GMT

how to generate a csv report to determine paper size in a pdf or pdf/a file ?

Which Company is Best on Ruby on Rails Developement in India?

forums_noreply@adobe.com — Tue, 07 Jan 2014 16:12:22 GMT

Hi, I looking on Best ColdFusion Development Company in India, Hyderabad. Could you please give me suggestion which company is best on it.

Hacker adding links to CF files

forums_noreply@adobe.com — Mon, 13 Jan 2014 03:48:25 GMT

Hi,

Someone is adding links to my CFM files. I am informed of this almost immediately and remove the offending code. The code is usually to knockoff brand stuff such as Michael Kors and Loius Vuitton.

I am on CF 8.1 and Redhat 5.8 versions with latest security patches applied to both. This has been going on for over 3 years now and it is becoming very annoying. I would like a hint or 2 as to how they are accessing my files?

boo1949

Setting different Deadline date for different reviewer

forums_noreply@adobe.com — Sun, 05 Jan 2014 13:06:49 GMT

In Adobe-9, can i set different deadline date for different reviewer?

problemme convertir pdf a word

forums_noreply@adobe.com — Thu, 16 Jan 2014 16:53:50 GMT

le doc est de 48 Mb et il me marque a la fin Erreur de conversion trop long.

Comme faire pour obtenir la conversion de l'archive?

Unable to install adobe Flaah player

forums_noreply@adobe.com — Thu, 16 Jan 2014 05:46:41 GMT

Hello,

I am new to this so bear with me, I am on my laptop with Internet 7, and windows 64 bit I was uable to install adobe flash player. I was getting all flags from you tube and my on line school that I needed to update my flash player. So I went to adobe and down loaded the free upgrade. I could not get past step 2 of the 3 part process.

1.) First time it was because it already existed, so I went in and uninstalled the flash player I did hve (i had already tried the update your version, through adobe, they unistall and reinstall for you) this was a bad idea now I have no flash pllayer and it will not get past part 2.

2.) Second flag I was getting was the internet was open and I could not install a new program. Frustrating because I had to have the internet open to install the flash player. So I tried to save and run, and nope 60% and could not install. I have tried saving it to a disk and a flash drive, nothing. It should not be this hard???

So I save it onto my computer when itt prompted to run. I saved as HEELLLPPPP I saved under adobe updat. CLosed out everything and found the app, I ran the app I save and OMG! I now have adobe Flash player 12 I about had a heart attack! I had to immediately back track what I had did, I had tried so many things I wasn't sure which idea actually worked.

To the people that knew this be happy for me I am spreading my wings! to the people this helps I am so happy that you can finally get answers! If this doesnt help, I am so sorry I do not know what to do for you? I could possibly go over other things I had tried, but I have a good feeling that this will work

Thake care and good luck!!!

How do I transfer CF9 file system to new server?

forums_noreply@adobe.com — Thu, 12 Dec 2013 23:20:24 GMT

We have a setup a new server running ColdFusion 9. We have installed ColdFusion and now I'm wondering how I would transfer the file system to the new server and use it as our Intranet server so we can demise the old server. After the ColdFusion install the CFIDE folder is in a different location on the new server. If I copy the old files to this directory (this is where our current files are stored) how do I point ColdFusion to this directory so we can use the new server for our Intranet? New to this so any information would be appreciated greatly.

accordion problems

forums_noreply@adobe.com — Mon, 06 Jan 2014 21:29:08 GMT

Hi,

I have a fresh install ColdFusion 10 (latest updates)

On a RedHat 6.1,6.2,6.3,6.4 Servers.

Using Apache as a webserver.

I can't get the following test code (Test 1 and Test 2)

working. Both are provided by Adobe.

I have tried https://cf.supportobjective.com/, no help.

Does anyone know how to get ColdFusion working?

The tests work with ColdFusion 8.01.

Brian Erickson

</cfif>

<br>

<cfinput type="text" required="Yes" name="firstName" label="First"

value="" width="100"/>

<cfinput type="text" required="Yes" name="lastName" label="Last"

value="" width="100"/>

</cfformgroup>

Flash fills this field in automatically.

You can replace the text.

</font></textformat>

</cfformitem>

<!--- The bind attribute gets the field contents from the firstName

and lastName fields as they get filled in. --->

<cfinput type="text" name="email" label="email"

bind="{firstName.text}.{lastName.text}@mm.com">

<cfinput type="text" name="phone" validate="telephone" required="no"

label="Phone Number">

</cfformgroup>

<b>Tell us your preferences</b>

</cfformitem>

Pets:

</cfformitem>

<cfinput type="Radio" name="pets" label="Dogs" value="Dogs"

checked>

</cfformgroup>

Fruits:

</cfformitem>

<--- Flash requires unique names for all controls. --->

<cfinput type = "Checkbox" name="chk1" Label="Apples"

value="Apples">

<cfinput type="Checkbox" name="chk2" Label="Bananas"

value="Bananas">

<cfinput type="Checkbox" name="chk3" Label="Pears"

value="Pears">

<cfinput type="Checkbox" name="chk4" Label="Oranges"

value="Oranges">

<cfinput type="Checkbox" name="chk5" Label="Grapes"

value="Grapes">

<cfinput type="Checkbox" name="chk6" Label="Kumquats"

value="Cumquats">

</cfformgroup>

</cfformgroup>

</cfform>

<!---

http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea7785 9461172e0811cbec10372-7ff4.html#WSc3ff6d0ea77859461172e0811cbec22c24-7 30c

--->

<html>

<head>

</head>

<body>

Flash form with formatted text and rules

</cfformitem>

This form has formatted text, including:</font></b><br>

<li>colored text</li>

<li><i>italic and bold text</i></li>

<li>a bulleted list in an indented block</li>

</textformat>

<p><b>The text is preceded and followed by horizontal rules</b></p>

It also has a link to a web page.</b><br>

This link displays the Adobe home page in a new browser window

</u></font></a>

</cfformitem>

</cfform>

</body>

</html>