Adobe Community : All Content - All Communities

How can you determine from within CF if cookies are enabled in the browser you are using?

forums_noreply@adobe.com — Sat, 13 Sep 2014 22:06:09 GMT

I need to know if the user has cookies enabled when he logs into my website so I can tell him/her to enable them. If they are not enabled, the SessionID will be lost and session vars will not work.

after installing CF10, I get this error msg,"This page can't be displayed"

forums_noreply@adobe.com — Mon, 11 Nov 2013 22:28:13 GMT

After installing CF10, I get this error msg when I try to access the Administrator page,"This page can't be displayed"

I'm running Window Server 2003, 64 bit version with IIS 6.0.

Before I installed CF10, I uninstalled CF8.

Adding browser setting instructions to cflocation

forums_noreply@adobe.com — Fri, 27 May 2011 17:14:41 GMT

I need to be able to hide the StatusBar in the browser when I open a new window using a <cflocation...>.

If I am opening a PopUP window using JavaScript, it is very straight forward; e.g,

<a class="showHand" onclick="JavaScript: newWindow=openWin('Reports/RptInterface.cfm?PID=#nProbID# &Top', 'Reports', 'left=0,top=0,width=250,height=250,toolbar=0, location=0,directories=0,status=0,menuBar=0, scrollBars=1, resizable=1'); newWindow.focus();">,

the status bar is shown, status=1, or hidden, status=0.

The only parameters that I know of that you can pass with a <cflocation> are the url parameters, which are only read by the new page while building the new window.

Does anyone know of a way to hide the StatusBar in the IE browser when opening a new window with <cflocation>???

Thanks in advance for your help.

:-}

Len

Using cookies and JavaScript to create a page to page timer.

forums_noreply@adobe.com — Tue, 23 Nov 2010 04:45:19 GMT

I have long wanted to be able to measure the time it takes to get from one page to another. While reading in my JavaScript reference the other day, I came across cookies. I've long known about cookies but have never used them. The thing that looked attractive was that you can access cookies from both JavaScript and CF.

So I put together the procedures to store the "start time" (startTimeP8D) for the transition and activated it on the onUnload event of a 1^stpage. After a few rewrites I got it working. Here is the JavaScript to do that: it consists of two functions: doTimer which is the input section and setCookie, which writes to the cookie. Not the two numbered alert statements.

doTimer - results for "start" from the doTimer function called from page 1 when it unloads. (See doTimer below)

Please note that the two startTime8D values are the same immediately after they are stored.

On the 2nd page in the sequence, I run the corresponding code to determine the "end time", compute the delta and write it out to the page. It didn't all run on the first try, but it now seems to be running without a crash, which can be misleading.

second set of outputs from page 2:

Please not that while the endTimeP8D match, the startTimeP8D value no longer matches the previously stored value.

There is one major hitch in the get along which has me stymied: As you can see, when you compare the startTimeP8 in the setCookie – results above and the "startTimeP8" in the doTimer results below the startTimeP8 is not the value that I wrote to the cookie @ unload of page 1. I have checked and checked and do now see anywhere that the startTimeP8D value is being overwritten. Based upon my limited experience with JavaScript cookies, it seems to me that you get an entry for each time you set the cookie. So I would expect to see to startTimeP8D entry for each setCookie event, not a different value.

The result of the failed computation is shown on the bottom of the page. As you can see, the Total Elapsed Time is negative, which is never a good sign. The other time shown, Page build time, is the run time from the server. The whole purpose is to be able to show folks that the reason the code might be show is because of their overloaded network and not our code. We had one client whose had users running on 56k modems. It was so slow their VPN software was timing out!!! Still the had the never to blame us!!!

I am using SQLServer 2005, CF8, IE8 on W7.

I'm not married to this way of doing this so if anyone has a better/easier way of doing a "page to page timer", I'm up for it. I'd prefer to fix this one since I've been working on it for the past 3 days.

Thanks in advcance for your help.

:-}

Len, PHRED SE
.

ajax cfc issue -- indeterminent error msg

forums_noreply@adobe.com — Fri, 13 Aug 2010 18:55:10 GMT

I have one ajax cfc app that works fine. This app uses the file name from the browse button on the file input object that is passed to my proxy.cfc, which in turn, queries the attachments table in my db to see if this file has already been uploaded for this project. If the file is not there, then I upload it to the server. If it is there, I pop-up an error message to the user giving him/her the date/time it was uploaded and by whom. These values are returned by testing code in the cfc. It works great.

I am now working on another app that will populate a lower-order select box in a hierarchy of select boxes based upon the new value in the current select box that has just been selected. It seems doable, but there is an immediate error that I cannot seem to get past an error thrown by the IE error handler as an unhandled error. This error is a “throw msg” error within the core Adobe code, which I’ve pasted in below:

I have modeled the new app after the one that I have working. In a effort to figure out this cause of this problem, I have even housed it in the original proxy.cfc to eliminate any question about having it in the correct location on the server.

At the current point, I am only trying to return an input value from the app, getAreasRmt. Here are the calling and called code. The line in the calling code that generates the error is the one where I call the cfc function: “alert (‘Rtnd BuGrpID: ‘ + areaProxy.getAreasRmt(….)));”

Calling JS:

getAreasRmt:

This code will eventually pass back a structure containing all of the areas whose Business Group ID is sBuGrpID.

I am running CF8 on a W2003 x64 server with IIS 6.0.

Thanks in advance for any help/suggestioins.

:-}

Len

What are the required settings to enable HTTP Compression?

forums_noreply@adobe.com — Fri, 06 Aug 2010 19:43:21 GMT

I am running into download speed issues with some of my clients. I am looking for ways to improve download response without having to rewrite my system(s).

On the server side, I am using CF 8.01 on a W2003 system. I have enable HTTP Compression for the web site in IIS 6.0 for both static and dynamic files.

On the client side where I am doing my testing, I am using IE 8.0 on a W7 professional system. In I.E., I have enabled HTTP 1.1 under advanced options and am using Automatic mode as the download methodology for Temporary Files.

It is my understanding that there is nothing that I have to do to CF to enable HTTP Compression.

It does not appear to work because the downloaded cfm files (5717 and 694389) are the same size regardless of these setting. In addition, I am using HttpWatch to determine all of the time and size parameters for each request. HttpWatch tells me in the summary that there are no HTTP Compression savings; i.e., HTTP Compression saving: 0 bytes. Based upon some of the info I've read on the web, I would have expected 50% to 75% savings since the two files being downloaded are both dynamic text files. All of the graphics, javascript, css files are cached so they do not figure into the equation.

Is there something else beyond the IIS and IE settings that needs to be done to implement HTTP Compresssion???

Thanks in advance for your suggestions/help.

:-)

Len

Javascript alert boxes are wrapped in Windows 7 with IE 8

forums_noreply@adobe.com — Fri, 18 Jun 2010 04:55:08 GMT

I can't count the number of JavaScript alert boxes I have throughout my systems and they have always made the transition between IE browsers from 6 to 8 without a hitch. Without a hitch until I setup my first Windows 7 machine. It is a 64 system that has both 32 & 64 bit IE browsers.

It doesn't matter which of the two versions I use, the JavaScript messages that I have so carefully crafted with just the proper layout are now wrapped. The resultant text in the new W7 popups is almost unintelligible because it is so badly scrambled/wrapped on the new white background.

Since an alert box is simplicty itself, there is no way that I can think of to change the inherent size of the box.

Has anyone else notice this phenomena??? If so, do you have a way around it short of redoing all of the text in the effected boxes???

Len

XP machine's JavaScript Alert popup in IE 8

W7 machine's JavaScript Alert popup in IE 8 with wrapped text

Is there an easy way to run an Ajax function from to test the file name in DB?

forums_noreply@adobe.com — Mon, 10 May 2010 23:56:38 GMT

I've had the <input type="file"> ... <cffile ...> thing going for a few years now.

There is a database where the uploaded file names are stored once the files are uploaded to the server. It sees things in terms of problems and stores uploaded file name accordingly with the ProbID prepended onto the file name; e.g., MyPicture.jpg would end up in the designated directory and databawe as P416_MyPicture.jpg. This allows user to store pictures with the same name in different problems without a conflict. There has been an issue with certain characters (e.g., spaces, +, #, etc.) causing problems when they are in file names so we have come up with a way using the <cffile ... rename> to replace these chars with _. This means that MyPic+.jpg would end up being P416_MyPic_.jpg.

This is where the problem appears. If someone were to upload MyPic+.jpg after someone else uploaded MyPic_.jpg in the same problem, then the + file would overwrite the _ file before the system knew they had a problem. And there is now way to restore the original file without going to the system backup and doing so – which is a whole other story … especially, if the person doesn’t tell anyone.

The logical solution would be to be able to test the new final file name (the name after making the substitutions mentioned above) against the existing files in the database before you went from the page where the <input type=file> control to the associated _action.cfm page where the <cffile> object is located. Given that this seems to be the province of Ajax, this would seem like a natural use of the really interesting technology. I have can determine the file name from the onChange action on the <input type=File> so that this would be the place for Ajax to come to the rescue by looking up the final file name and then letting the user know whether the resultant name is a unique within the database or not. If so, I'll just enable the Add button which sets right next to the <input > control and let them upload it. If not, I'll put up an error message telling them that this file already exists in the system.

This would be the perfect solution. It would let me do some Ajax stuff like I've wanted to do for the past year, but never have had the time to do because this is the project that won't go away. This is, in fact, the last thing of any consequence that remains to do on this 2-1/2 year nightmare – be careful what you wish for. If I can get this done this week, then maybe I can finally take a weekend off … maybe it will finally come to an end.

Which finally leads to my question: I'm looking for some tips on how to get this thing going since I can barely spell Ajax. I've got a book and looked at some stuff online about CF and Ajax, but a good example or two or three would be worth a day's worth of poking around on the web and in my books.

Thanks in advance for any suggestions, ideas, help, whatever.

:-}

Len

Conditional use of ...

forums_noreply@adobe.com — Mon, 29 Mar 2010 19:50:02 GMT

I have been using the <cftry>…<cfcatch> methodology for over 5 years. It generally works very well. When there is a case where we need to trap an error and put out a friendly error message that works well also. When we need to know the actual problem, we have been commenting out the <cftry> … <cfcatch> mechanism and letting the CF detailed error message appear on the page. Since we are working on a test server, it doesn’t hurt anything to have the CF Robust error capability turned on. One would never do this on a production server, however.

We have recently decided that we do not want to continue to comment out these items because then the file dates get out of wack with the comment/note dates. There is a big push on, and rightly so, to keep these in synch so that we will know if folks are forgetting to note their changes at the top of the file.

So it occurred to me that if I could surround the <cftry> and <cfactch> with <cfif> statements, then I could make this a conditional thing and enable (include) and disable (hide) them at run-time by changing the setting of a Session varable.

Here is a simplified version of what I tried. I would set Session.UserRobustErrMsgs to false or true depending upon what I wanted the system to do. Normally is we be set to False: do not use robust error messages.

<cftry>

</cfif>

Do something here….

Do friendly error message here>

</cfcatch>

</cftry>

</cfif>

Note that there is nothing between the </cfcatch> and the </cftry>.

While it might have been a good idea, CF didn’t like it. CF threw the following error message:

The start tag must have a matching end tag. This could be because

<cfcatch> is not the last tag nested in the <cftry>. <cfcatch> must

Be the last tag insde a <cftry> tag.

If anyone knows of a conditional <cftry> … <cfcatch> technique/methodology, I would appreciate your shaping it with me.

Thank you in advance for your help.

:-}

Len

Browse text file within CF to determine if there are any 's inside

forums_noreply@adobe.com — Tue, 19 Jan 2010 23:35:35 GMT

We have run into a security situation where we need to browse through all text files that users are going to load into an Attachments directory using <cffile> before we allow anyone to have access to these files because of the danger of cross site scripting (xss).

We have tested the potential for something like “<cfscript> document.location.replace(“http://www.badsite.com”) </cfscript> being run within a browser when the user opens the file in their browser moving the user to this site, which could open them up to downloading a Trojan onto their PC. This just happened to him a couple of few weeks ago and his hard drive was destroyed. (I suppose there is a way to block xss within IE, FireFox, etc., but I can’t count on every user having xss blocked so I have to do it for them.)

Although I haven’t done it yet, it appears that you can use the <cfloop> function to open a file and loop through it line by line so that you could process this file in CF 8 to ensure that “<cfscript>” is not contained anywhere within the file. I’m going to do a proof of concept later today or tomorrow. If this works, then I’m OK for all my systems that run CF8 or CF9, but that is it.

What I really need is a way that would be compatible with previous versions of CF as well. My first instinct was to try something with the FileOpen function within <cfscript> but there does not seem to be anyway to easily parse a file once I have it open in <cfscript>. I’ve done a ton of JavaScript code and I know that <cfscript> is somewhat of a subset of that, but the documentation I’ve found on <cfscript> is so poorly written as to be almost useless. (Forta’s CF8 books give it very short shrift even in the downloadable PDF.)

Does anyone know of a third way to do this that would be compatible with CF6 through CF9???

Thank you in advance for your suggestions.

:-}

Len

ColdFusion Security Best Practices

forums_noreply@adobe.com — Wed, 13 Jan 2010 16:13:05 GMT

I want to make sure that my systems are in tune with the current thinking on security best practices. I have been reviewing and planning on implementing new features as proposed in the Adobe White Paper titled "ColdFusion 8 developer security guildelines" by Erick Lee, Ivan Lelven, and Sarge Sargent, dated Octobe 2007. While this is a great white paper, I'm wondering if this is the state-of-the-art in terms of security.

Does anyone know of a better/newer/more comprehensive reference?

Thanks in advance for your help in this matter.

:-}

Len

Encode and Decode, DES/DESEDE algorithm conumdrum

forums_noreply@adobe.com — Tue, 22 Sep 2009 23:20:48 GMT

Because of a customer requirement, we cannot use Session variable to pass things like item ID values. As a result, I’ve been using encrypted URL’s to do this kind of thing. We discovered by chance the other day, that you could change the HEX encoded (using CFMX_COMPAT algorithm) URL values and change the item ID, which would let the user move to a place he isn’t supposed to go. OOOOps.

I have been using the Session.SessionID as a basis for the key of the CFMX_COMPAT encryption for about 18 months now and no one has discovered this hole in the system, but I guess it is only a matter of time before someone does. Today I tried to figure out how to use the DESEDE algorithm but the thing that has me stymied is how you pass are supposed to pass the key value across to the Decrypt code. In all the manuals and all the examples they show only, they cheat; i.e., the work both sides of Encrypt/Decrypt process from the same form. Well, you can’t do that when you are going across the URL bridge. I suppose I could encrypt the DESEDE key that I generate using the generateSecretKey(“DESEDE”) using CFMX_COMPAT and then decode it across the other side of the URL bridge using the Session.SessionID, but this seems to be getting out of hand.

One other issue, I have to pass things via email between systems so I do have to pass the Session.SessionID value between different Cold Fusion systems, but I have come up with a way treat a passed in Session.SessionID value as a one-time, throw-away key.

Note: I can only get by using the Session.SessionID value because it remains the same throughout the user’s whole session and is not related to any particular item as it would be if I were still using Session.ItemID’s.

As a stop-gap measure I am doubly encrypting the ItemID before I assign it to the URL. After the 1^st encryption I append a known string to the 1^st encrypted value and then do my 2^nd encryption: url_DblStr=”#EnCrypt(#1stEnCryptStr#wxyz)#”. After I’ve done my 1^st decryption on the other side, I ensure that the “wxyz” string is still intact on the end of the 1stEnCryptStr. If it has been changed, then I know that someone changed something in the URL and I can send them to a place where they can do no harm.

So here is my simple question: How can you use DES/DESEDE/etc. algorithms, which seems to require you to use the generateSecureKey() function, when you can not directly share the key through Form or Session variables?

There must be a simple way to do this thing that has not occurred to me even though I have given it a considerable amount of though over the last 24 hours.

Thank you in advance for your help and suggestions.

:-}

Len

Error establishing socket to host: Reason: Connection refused: connect

forums_noreply@adobe.com — Sat, 15 Aug 2009 17:23:03 GMT

I am in the process of moving from an old x32 server to a new x64 bit server. With the help of Adobe support, I have finally gotten CF8.0.1 up and running on the new server: http://forums.adobe.com/thread/470337?tstart=0,

I am now trying to connect CF8.0.1 Standard on the new x64 machine to SQLServer 2005 x64 bit. All of the databases I'm trying to setup on the new server are currently running on a x32 system with CF8.0.1 and SQLServer 2005 x32.

Using the SQLServer drive type I get the following error:

"Connection verification failed for data source: PHREDsevenSQL
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: DELLx64Server:1433. Reason: Connection refused: connect
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: DELLx64Server:1433. Reason: Connection refused: connect."

Using the ODBC Socket type I do not get a ODBC DSN name in the select box so I can't actually try this type of connection. I've tried both x32 and x64 bit ODBC System setups.

I have verified the following:

SQLServer configuration: the port is set to 1433.

Account user name and password are correct.

I have looked for a x64 bit SQLServer driver for CF8 on Adobe, but couldnt find one. Perhaps one is already installed.

If anyone has a suggestion or solution, I would appreicate your help. Thanks in advance for your help.

:-}}}

Len

CF8 standard upgrade installation failed: ODBC services not installed.

forums_noreply@adobe.com — Thu, 30 Jul 2009 20:47:20 GMT

I am upgrading from a 32 bit server to a new 64 bit server. I have had my CF8 Standard Upgrade installed on my 32 bit server for well over a year. I just installed my CF8 Standard Upgrade onto my new 64 bit server. Note: when it didn't work the first time, I uninstalled and then reinstalled -- no change.

There are two problems:

1. The two ODBC services, Agent and Server, were NOT installed.

2. The Inetpub/wwwroot/CFDocs directory and associated files were not installed even though I had CFDocumentation checked on the install setup sheet.

I've attached a graphic showing the CF services that were installed on the 64 bit server.

Thank you in advance for your help and suggestions.

:-}
Len

P.S. I've been installing CF since version 3.1 so this is not my first time around the block.

Message was edited by: PHRED-SE: I should add that my operating system is Windows Server 2003 R2 Standard x64, version 5.2.3790 SP2.

Data Source definition question when using SQL Server

forums_noreply@adobe.com — Mon, 27 Apr 2009 19:02:19 GMT

I am trying to setup a data source connection on a SQL Server database that is on a server that is on a different network from the one that my ColdFusion 8 system is running on.

It seems like this is a simple, straight forward thing: define the CD Data Source Name: MyTestData, Database: TestData, Server: 123.45.78.145\TestServer, User Name: my Name, Password: *****. See my attached jpg for more detail. Note: the IP address is bogus so don't fixate on that.

I can remotely log into that server using Terminal Server and bring up the SQL Server database so I know that both the IP address and the SQL Server names are correct. I know that both the User Name and Password are correct so this leaves on the Server format.

My question is what is the correct Server naming convention/format if this is not the correct format???

Thanks in advance for your help in this matter.

Len

window.opener.location.replace(xxx) - does not always work

forums_noreply@adobe.com — Wed, 25 Feb 2009 06:48:32 GMT

I open a PopUp window from my main page using a JavaScript “open.” I can do several things from this PopUp. When I am done with whatever I need to do on the PopUP, I close it. In the <body> of this page I have embedded a simple onUnload statement that refreshes the calling page so that I can automatically show changes that were made while on the PopUp.

This code has worked successfully for a number of months on my development server as well as our production server. We recently moved the code to a client's server where it doesn't work. When the client clicks on the close button, the PopUp does not close. I believer it is because the onUnload code does not work and this error halts the close process.

I have searched the web and have found several folks who are using similar code, but there is no reference so similar behavior.

Since the PopUp is popping up and seems to be working correctly, I have to believe that all the IE settings are correct. There has been no mention of a JavaScript error message, so I'm thinking that they must have these error features turned off. I've requested that they turn them on, but it may be a day or two before I get an answer back from the client.

I've reviewed all my JavaScript books and can find nothing that would indicate that this code is temperamental, or needs anything special.

So here is my question: Does anyone out there know of any quirks that would cause this line of code from working.

Server Systems: Windows 2003 or greater
CF: CF8
Clients: Windows XP Pro or Vista
SQLServer 2005
Required Browser: IE 6+ (most users have IE 7+)

Thanks in advance for your help/suggestions with this mystery.

:-}
Len

(Code follows)

Note: "window.opener.location" is an object that contains the full URL including all of the original URL paramters.

Using CF8 with a BlackBerry as display device

forums_noreply@adobe.com — Thu, 07 Aug 2008 01:40:04 GMT

We have a CF8 based system that we want to be able to access from a BlackBerry and possible an IPhone rather than from a Windows PC w/IE or FireFox. Since we only have the idea at this point and not even a BlackBerry, I'm wondering how large a task it will be to convert everything over to be compatible with the BlackBerry. What I'm particularly worried about is the many JavaScript modules that are interspersed throughout the system. The JavaScript is all IE 6+ and FireFox compatible. I've even run through the system with Safari and didn't see any huge problems, but a BlackBerry is a very foreign animal to me.

Thanks in advance for your help and suggestions.

:-}
Len

Software Configuration Management

forums_noreply@adobe.com — Thu, 24 Jul 2008 20:46:02 GMT

We have come to a point where we need to start doing Software Configuration Management (SCM). We are using DreamWeaver 8 as our development tool.

We have found some good books and tools, but most SCM systems/references seem to be oriented towards compiled/built systems. Obliviously, a lot of things that are aimed at "real" systems, don't pertain to CF systems so I'm really interested in SCM in a CF environment.

I'm looking for recommendations:
1. The best management software tool; e.g. MS VSS, SubVersion, etc. Want it to be compatible with DW8.
2. How to reference books
3. Any other ideas / tips on the SCM process.

Thank you in advance for your help/recommendations/insight.

:-}
Len

CFFTP Error in CF 8.0.1

forums_noreply@adobe.com — Wed, 23 Jul 2008 17:27:20 GMT

I have just gotten my <cfftp> function working properly after few false starts -- I'm transferring files between two servers. One of the things that I have to do is to transfer files with Chinese characters in their names.

<cfftp> crashes when the file to be uploaded has Chinese characters in the file name. This is the error message that I get:

FTP File transfer failed: 550 P_10_English-????.doc: The filename, directory name, or volume label syntax is incorrect.

Local File: D:\Data\Data\Allaire\Dev\PHREDintel\Attachments\P_8_English-技术支持.doc
Remote File: P_8_English-技术支持.doc.

It takes exception to the Remote File name, which in this case is "P_8_English-技术支持.doc."

The CF function <cffile> uploaded this same file from my PC to the server originally. After a two month effort, Adobe was able to figure out why the <cfdocument> would not import Chinese characters into the PDF file. So it appears that some parts of CF speak Chinese while other parts do not.

If anyone has any ideas how I can get <cfftp> to speak Chinese, I would greatly appreciate your knowledge on this matter.

Thank you in advance for your support

File transfer between servers

forums_noreply@adobe.com — Sat, 19 Jul 2008 19:15:10 GMT

I've been using CF for 10 years, but this is the first time I've had occasion to transfer files between servers under CF control. The only way that I can figure out how to do this is to use CFFTP.

After reading the section on CFFTP in "COLDFUSION 8, Advanced Application Development", it seems to me that I'm going to have to transfer the file(s) from server A to my PC, and then from my PC to server B.

Is there any better way to do this than I've described???

Thanks in advance for your help and suggestions.

<cfdocument> not showing Chinese character

forums_noreply@adobe.com — Tue, 22 Jan 2008 05:29:14 GMT

We have a system that uses a mixture of English and Simplified Chinese on almost every page. After properly installing the Simplified Chinese fonts (gb2312) on all of the users PC’s via the Regional and Language setting, the pages display both languages properly.

We have just started using the <cfdocument> to create PDF documents. We were eager to convert to <cfdocument> in order to be able to use CSS and to be able to display the Chinese characters in the PDF document as they are displayed in the HTML. We tried it first on a CF MX 7 test bed. Once we created the cffont.properties.cn in the cf_root/Lib directory, it worked like a champ.

In order get this feature into production, we moved the .cfm files and the cffont.properties files from out CF 7 test bed to our CF8 development system. No matter what we do, all we see in the PDF file where the Chinese characters should be are “?”.

We can’t find any information on anything else that we need to do to make the Chinese characters appear besides creating the cffont.properties files in the cf_root/Lib directory as we did in CF 7. Using the CF Administrator’s Font Manager, I can see that the required Simplified Chinese fonts (NSimSun, SimSun & Simhei) are installed on the server. The bare bones code seems simple enough:
<cfdocument format=“pdf” fontembed=”selective”>
Page text…
</cfdocument.

If you have done this, or know what we need to do to port form CF7 to CF8, I would appreciate your sharing.

Thank you in advance for your help.

:-}
Len

Charts not displaying in ColdFusion 8

forums_noreply@adobe.com — Thu, 10 Jan 2008 22:25:34 GMT

We have two servers: one development and one production. The development system was upgraded to CF8 several months ago. The productions server was just upgraded to CF8 last month. All of the various CF systems that are running on the development server display charts correctly. However, charts do not display correctly on any of the CF systems running on the production server. Both servers run the same CF code. Both servers are running Windows 2003 (std) with IIS6. Both CF8 systems are standard.

When any chart on any of the various systems is created on the production server, the page shows html objects (buttons, text, etc.) around where the graphic should be, but the space where the chart normally resides is blank. No errors are indicated.

By viewing the source file for the page in question, you can find the name of the swf file that was created and is supposed to be displayed. This swf file is, in fact, in the CF8 cache on the server. Here is the big gotcha: the xxx.swf file IS NOT being downloaded on the user’s PC; i.e., it is not in the temporary internet directory when the user is building a chart on the production server!!! It is there when accessing the development server. It works the same way whether the user is on the Intranet with the production server or across the Internet. ??????

We have compared the CF8 setting in CF Admin on both systems and can find no differences as relates to Charts. There are trivial differences in other places, but most of the setting on both production and development servers are the out-of-the-box values.

If anyone has a clue as to what might be wrong, we’d appreciate hearing from you. Thank you in advance for your help and insight.

Verity error

forums_noreply@adobe.com — Mon, 10 Dec 2007 01:02:38 GMT

We recently moved from CF6 to CF8. Other than Verity indexing being extremely slow, I thought all was going well until I tried to run my Create Collections procedure. These collections were to be populated under program control from MSAccess database(s). I have been running this procedure for over 5 years on CF6 and earlier versions without a hitch. I was setting up my 5th system under CF8 when this successful string ended.

My procedure crashed with the error message, "Unable to register collection [collection name]". I had seen this error a couple of times previously, but just running the procedure again had always sorted things out successfully. It didn't work this time. I rebooted the server but nothing changed. I modified my code so that each of the 21 <cfcollections> in the procedure was with it's own <cftry><cfcatch> routine. Having each contained like this, enabled me to power thorugh all the of creation procedures regardless of how many "failed". If one creation failed, the next might fail or might work so one failure didn't guarantee all failures.

It turns out, that creations didn't fail completely. The collections were actually being created and seemed to work onced they were populated under program control (<cfindex>) with data from an MSAccess database. So I assumed that whatever this message meant, it wasn't a fatal error. I continued to make changes to procedure to see if there was some further info I could get to tell me what was going on. I finally learned something when there was a new error: "Unable to connect to the ColdFusion Search service."

This time rather than reboot the server, which never seemed to help anyway, I restarted each of the 5 ColdFusion services one at a time from the bottom up; i.e., CF8 Search Server, CF8 ODBC Server, ..., CF8 Application Server. I have gotten serveral clean creations since this.

So, does anyone out there know what these errors are all about and how you can prevent them?

Thanks in advance for your help.

:-}}}
Len

CF8 Verity Indexing

forums_noreply@adobe.com — Fri, 07 Dec 2007 21:41:04 GMT

I've been using Verity to build collection of data from my database systems for several years now using CF5 and CF6.1. I recently upgraded my system to CF8. While searching these collections is 5 to 6 times faster, indexing these collections is SIGNIFICANTLY slower.

My system has some 50+ screens that I use to collect and store data into either MSAccess or SQL Sever databases. There are 26 different collections that I use to store this data in. After the data from each screen is stored in the datbase, I then update the pertinent collection based upon the screen and database table(s) where the data is being stored. The collections are a compromise between number of screens and tables. This enables users to always be searching the most current data. Every night we run a scheduled task to rebuild all of the collections because this continual add/dropping of data during the day chops up the Verity collections.

I noticed two thing after creating the new CF8 collections: Indexings is 2 to 3 times slower that it was in CF8. Searching is 5 to 6 time faster than it was. I'm wondering two things at this point:
1. Is this a common experience amoung CF6 to CF8 users?
2. Is there some different technique that you have to use to index collections using CF8 that will improve the indexing speed?

Thank you in advance for your insight in this matter.

:-}
Len

Unable to create Data Source when CF and SQL Server on different servers

forums_noreply@adobe.com — Thu, 01 Nov 2007 19:26:29 GMT

I have just setup CF8 on a new server running Windows 2003 Std.

SQL Server is running on the old server running W2K Server. It also has CFMX6.1 running on the old server. I made the DataDirect JDBC drivers (version 3.5) update several months ago to the old server and set all CF services to run under the domain\Administrator account. Everything is running fine on the old server.

The problem appeared when I tried to create a new Data Source in CF8 server (using the Microsoft SQL Server Driver) that would link back to a SQL Server table on the old server. The error message I receive is: "Connection verification failed for data source: GAISSQL
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'XENONX2\GAIS'.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Login failed for user 'XENONX2\GAIS'."

SQL Server on the old server is running in mixed mode right now, but you get the same error message regardless of the mode. I setup the XENONX2\GAIS account specifically to link back the the GAIS table SQL Server. The passwords are the same on both machines; i.e., in both the Windows account and SQL Server Account.

I'm afraid the rub might be that I'm still using work groups rather than a Domain with Active Directory. But it seems to me that as long as I pass back the domain\accountName for the system/SQL Server that I want to log onto the it shouldn't matter that they are not on the same domain.

I tried setting up a ODBC connection from the new server back to the old server and essentially got the same error.

If anyone knows how to get this going I would appreciate it if you would share the secret. Thanks in advance for sharing.

:-}
Len

Verity Collections in CF8

forums_noreply@adobe.com — Sat, 03 Nov 2007 20:59:19 GMT

I just installed CF8 on a new server. The Verity Collections are being created in a Verity subdirectory in a new CFusionMX directory. There is also a Verity subdirectory in the ColdFusion8 directory that isn't being used. Anyone know why this is???

Also, it takes over twice as long to create CF8 indexes on my new server as it did on my old server running CFMX. I did some comparisons between old and new just to see how my new server with CF8 was doing: indexing on CF 8 took 160.992 seconds and 83.232 seconds on my old server with MX. Both systems built 14 indexes from 22 MSAccess database tables.

The payback for the longer indexing comes when you search: CF8 - 422 milliseconds, and CFMX - 7.563 seconds. They both returned 58 records for the same search. I'm guessing that they are using more complex indexing algorithm so that they can do faster searches. Does anyone know the real answer???

Thanks for your insight in advance.

:}
Len

CF8 Error Messages

forums_noreply@adobe.com — Wed, 31 Oct 2007 16:22:51 GMT

I've just upgraded from CFMX 6.1 to CF8. So far all seems to be going well.

One annoying thing is that the very informative error messages created by MX are gone. CF8 gives a very generic error message telling the user to cantact website administrator. This is all well and good for the user, but I'm the website administrator/developer and there is a big difference between knowing that "sCEChecked" is undefined, and knowing that "sCDChecked" is undefined on line 862 in a particular expression.

Is there any way to go back to the old error message format???

One last thing, 99% of all the errors that happen in a production environment are handled by custom error messages within a <CFTry> <Catch> so the users would not normally see a raw CF error message. During development or maintenance, I comment out the <CFTry> and let the raw CF message point me to the actual error. These new CF8 message don't point anywhere so it can be very difficult to find the actual point of the error.

Thanks in advance for your help.

:-}
Len

MX Installation error

forums_noreply@adobe.com — Thu, 18 Oct 2007 01:59:48 GMT

I am reinstalling an upgrade copy of CFMX on a replacement server. I've installed this version on several different Windows 2000 servers over the past few years. This is the first time I've installed in on Windows 2003 Std Ed. I have selected IIS and am now on the directory setup page. The "Install CFMX files to" selection is set to c:\CFusionMX, which is correct. The problem comes with the "Install Web Files to" selection. It is pointing to just a plain backslash, "\". No disk drive and no directory. I would expect it to be pointing at c:\Inetpub, since it knows I want to use IIS. When I click the Change button, I get the following error msg: "Error 1314. The specified path \ is unavailable". I'll buy that, but I can't do anything about that because it crashes when I try to do something about it. To top it off, it then takes me out of the installation procedure with no way back. You have to go back to the start of the installation and reenter the serial numbers, etc.

Like I said, I've installed CF (3.1 to MX) probably a dozen times on W2K servers over the past 6 or 7 years and never had a problem like this before.

I'd greatly appreciate any suggestions, if anyone has one, because i'd dead in the water at this point. Thanks in advance for your hep.

:-}}}
Len

P.S. I tried it 4 times and got the same result each time.... Does this meet the definiton of insanity yet???

CF search using "LIKE" SQL operator

forums_noreply@adobe.com — Wed, 08 Aug 2007 21:33:51 GMT

I've been doing limited keyword searches of selected fields in both MS Access and SQL Server for several years now. My searches have always been in this format: "WHERE Title LIKE '%#sKeyword#%'." They seem to always work. The only downside to this method is than any word that contains the sKeyword is returned because there is a % on both ends.

What I discovered today was that this form will also work: WHERE Title LIKE '%#sKeyword#'; i.e. returns any word that ends in the Keyword. But that the other variant (WHERE Title LIKE '#sKeyword#%'), where the % is on the end, will not work.

Anyone have any idea why the version with the % on the end will not work???

As a related item, does anyone have any idea how you would search a long text field for just the sKeyword; i.e., it would be like doing a WHERE Title LIKE '#sKeyword#'. I know that a LIKE search without any %'s will not return anything and I'm already doing Verity searchs so I know about that method. I'm just looking for a simple way to find a whole word within a group of words in a single field.

TimeFormat(Now(),'h:mm tt')

forums_noreply@adobe.com — Thu, 12 Apr 2007 16:36:08 GMT

I've been using TimeFormat(Now(), 'h:mm tt') for over 8 years. Suddenly TimeFormat is returning GMT time rather than local time. I know that it is returning GMT time rather than local time because I have some JavaScript code, which I have embedded along side the TimeFormat, that returns both local and GMT time, and the TimeFormat time matches the JavaScript GTM time.

To my knowledge there is no setting within CF 6, or any other version of CF, that allows you to specify whether you want local or GMT time.

It has to be something going on with my development system (Windows 2000 Server, IIS) because the same code running on our production server returns the local time rather than GMT time.

The only thing that I can think of that has changed on my server is that I modified the system with Microsoft's utility to reset the Start and Stop dates for the recent Daylight Saving Time change. Of course, this worked correctly for the new start date but then the time got pushed up again at the old start date. I've since reset the system time to the correct value.

Thanks in advance for shedding light on this problem.

:-}
Len