ColdFusion

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSd160b5fdf5100e8f-4439fdac128193edfd6-7f75.html

I have a database with spaces in the field names (not my fault).I am having a problem with the query because one of the fileds I am joining on has a space in its name. See bolded text.SELECT *FROM employee_passwordsINNER JOIN employee_general_infoON employee_passwords.Employee_ID=employees.[Employee ID]WHERE username = '#username#' AND password = '#password#'   So I get this error messageError Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'employees.Employee ID'. Is there a way to alias the employees.[Employee ID] field?

Hi,I need help.  My problem is this:Browser does not read *.css and <img> files output by CF10, but browser does read page created by CF9.I will lay out the information in steps.1. When I have the following in the CF10 page, the browser reads and displays the file just fine.    <img src="http://www.powersuasion.com/Media/Images/Feedback/AssResult.jpg" alt="View Your Writing Profile Results" width="396" height="25" border="0">2. When I have the following on my CF9 page, the browser displays properly.    <img src="../../Media/Images/Feedback/Intro.jpg" alt="View Results with Introduction" width="396" height="25" border="0">3. When I have the following on my CF10page, the browser displays all elements of the page, except for jpgs and css files.    <img src="../../Media/Images/Feedback/Intro.jpg" alt="View Results with Introduction" width="396" height="25" border="0">    My hypotheses:1. CF10 is instal

Hello,I'm trying to merge two pdfs, one from a variable using cfdocument (A) and the other from an actual file  (B).  (A) would remains constant but (B) would change depending on what users upload.  Once in a while I would get the following error especially when (B) is a verizon bill in pdf.  CFPDF action="merge"Error","jrpp-1822","......","Unable to instantiate com.adobe.internal.pdftoolkit.pdf.interactive.navigation.PDFBookmark object from CosObject. The specific sequence of files included or processed is:[], line: 493 "java.lang.RuntimeException: Unable to instantiate com.adobe.internal.pdftoolkit.pdf.interactive.navigation.PDFBookmark object from CosObject.          at com.adobe.internal.pdftoolkit.pdf.document.PDFCosFactory.newObject(Unknown Source)          at com.adobe.internal.pdftoolkit.pdf.document.PDFCosFactory.getInstance(Unknown Source)     &nbs

Installed CF10 on a Windows 2012 server.  Used the builtin web server.  after install, the admin page fails to laod, and I see the following in the coldfusion-error log:May 12, 2013 3:28:09 PM org.apache.catalina.core.AprLifecycleListener initINFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: C:\\ColdFusion10\\cfusion\lib;C:\\ColdFusion10\\cfusion\jintegra\bin;C:\\ColdFusion10\\cfusion\jintegra\bin\international;C:\\ColdFusion10\\cfusion\lib\oosdk\classes\winMay 12, 2013 3:28:10 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["http-bio-8500"]May 12, 2013 3:28:10 PM org.apache.coyote.AbstractProtocol initINFO: Initializing ProtocolHandler ["ajp-bio-8012"]May 12, 2013 3:28:10 PM org.apache.catalina.core.StandardService startInternalINFO: Starting service CatalinaMay 12, 2013 3:28:10 PM org.apache.catalina.core.StandardEngine startInternalINFO: Starting

I have built and administer 2 CF servers for the government for over 12 years. The government has this idea that they can drop all of the said applications into a SP server/folder and it will all magically work. If anyone has an existing briefing or talking points that compares CF advantages that I can use to make them understand I would be really thankful. Thanks in advance, Jeff

Please indicate the URL for the ColdFusion Builder 2.0 to Coldfusion Builder 2.0.1 upgrade.  All I can find is the CFB trial download site wich does not indicate if it is the upgrade or the version.

Hi,I have a problem inserting dates in a MS Access database. Days and month are swapped everytime the date stay valid.Ex: 05 of june 2013 become six of may 2013 but 13th of june is not changed. I use:#CreateODBCDate(Dateformat(mydate,"dd/mm/yyyy"))# Of course i put in my Application.cfm :<cfset Locale=setLocale("French (standard)")>I tried too using a variable :<cfset variables.MyDate="##" & "#Dateformat(form.MyFormDate,"dd/mm/yyyy")#" & "##">and thenInsert into myTable (MyDateField)Values(#variables.MyDate#)Where etc...but the result is the same.Windows 2003 server and CF8. Sorry for my terrible english and thanks in advance. Jean-Jacques

Hi All,These days I am getting some weird errors like,Element DATASOURCE is undefined in APP.Element DATASOURCE is undefined in SESSION.Variable LANG_LOC is undefined. (that UDF is included in global.cfm, which is in a common template)Detail Story:- There are 3 modules in my application. Each modules contains separate module specific "application.cfm". And two common files "global.cfm" and "config.cfm" (These are included in all module specific "application.cfm" file). "config.cfm" is included in "global.cfm", and "global.cfm" is included in "application.cfm". The <cfapplication> tag is present in "config.cfm", which implies all modules in the application shares same application name. The "global.cfm" and "config.cfm" includes 2 cfm tempates contain some common UDFs All SESSION specific variables are defined in "config.cfm" file. The application has been running last 3-4 yrs. without showing any issues. But suddenly started getting above Variable Undefined error from Production

Has anyone seen this error?  Running CF 9 Enterprise.This happens on every page, every time.  That's all of the info I have, but I have never seen this type of error, I thought someone might have an idea on this Saturday.

How do I update my Coldfusion code assist to include the new Coldfusion 10 tags

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.html

I have a problem when it come to upgrade my CF. My server is windows 2008 with IIS 7.0Installation end with a warning that migration has fail.After that I can't even open my CF administrator, it request a program to open the index.cfm file. so I assumed .cfm handler were not set up. I have set up all my handler and even there nothing is working....I have 2 time, the 2nd time I started by deleting all CF 8 handler and stop cf8 services, still end up the same .....Now I believe I have lost enough time trying this update  ...My next move is to try uninstall CF8, delete all traces of CF8 and try to install CF10 as a new install ....  is this a good ideas or are there possibilities that I will end up with the same problem ???I started using ColdFusion with Allaire Cold Fusion 3.1 and NEVER did I had this much problem upgrading ....  very very frustrating ......

Error code 147:20

How do I update my Coldfusion Builder 2 reference (help) to include Coldfsuion 10 ?

I set cookies like this:<cfcookie name="ckwhatever" value="hello">I try to kill the cookie like this:<cfcookie name="ckwhatever" expires="now">This does NOT work. the cookie remains.I've tested on mozilla and IEI don't get it.

I have a large number of solaris 10 servers we use at work. We are moving to CF 10, so on my first attempt to install it, the connector blows up:There was an error while running the connector wizardConnector installation was not successfulI've seen that a bunch, typically when the version of Apache I'm using isn't supported or something. For the record, this is Apache 2.2.22. Very supported by many other version of ColdFusion, so I'm lost as to why this doesn't work. The mod_jk.conf gets created and stored in the Apache conf directory, the include to the file is there. Everything looks clean and good. This is a stock Apache instance, compiled from source. I think the failure results from this error message in the Apache logs:[emerg] Error in reading worker properties from '/web/cf10/config/wsconfig/1/workers.properties'I've verified that Apache and ColdFusion are running under the same account and have equal access back and forth between apps. Furthermore, I have verified that this acc

I use CFLOGIN to check user ID and password and let user login in to system.I would like know how shoudl I save the login information.Should I use session varaible to save user ID and rights and create at Application.cfc?Your information and help is great appreciated,Regards,Iccsi,

Do I have to go through the hotfix procedures or can I run the ColdFusion 9.0.2 complete package to update from 9.0.1 to 9.0.2? Thanks, Jeff

Hi everyone, we're in the process of updating our servers from CF8 to 10.  We've only done one so far, which has allowed us time to compare/contrast/fix issues.We've noticed that before, on IE, pdf files would open right in the browsers.  Oddly enough, on the CF 10 server, it now always prompt to save.  IIS settings prior to the CF10 install did not change, and we're not aware of anything that CF would have done there.Has anyone else encountered something like this, or able to replicate it?

I am reposting this from CF forum.What is this "Zzz Refresh Content (Sleeping) in the progress of CF Builder 2? Any time this comes up, it freezes CF Builder. This thing in CF Builder 2 is becoming so frustrating. You can hardly save codes without this thing hanging, I have to restart CFB to get work done

I have a form that is bound to a cfgrid.  The grid is populated from a database.  When you navigate in the grid the data displayed in the form changes to match the selected row.  I can edit the data in the form and update the database.  After updating the data I refresh the cfgrid, which then displays the updated data.Unfortunately the cfgrid always highlights the first row, row 0, after a refresh.  I want to highlight the same row that was highlighted when the data was edited and saved.  Can anyone advise as to how I can do that?I have tried setting a listener when the grid is initiated that responds whenever the store is refreshed and triggers the function refreshSelection():g.getStore().on('load', refreshSelection) ;Before the form data is saved, the row number is stored in selectedRow[0].  When the grid is refreshed, refreshSelection is run:function refreshSelection() {    if (0 >= selectedRecords.length)    &

Hello I'm new to Coldfusiion, and I was wondering what would be the best way to have search results so that the user could select a column. For instance If someone was searching for the sku aaa they would be able to select the upc column to copy from. Right now I'm using cfoutput query which list the result in table that the user can't copy from a single column. Any help would be great,

Today, following windows updates and the subsequent reboot (perhaps coincidentally?), I lost all functionality of cfinclude and cffile.I'm running IIS 7.5 & CF10 with applicable lockdown rules. Since the problem began - earlier today - when briefly disabling 'resource security' via the CF administrator, cfinclude functions properly. This does not fix cffile and is not an acceptable fix for cfinclude due to security concerns.The cfinclude error:access denied ("java.io.FilePermission" "C:\[path&file]" "execute") nullPlease advise.Thank you.

One of my users was trying to upload a Microsoft Word document using CFFILE.  The document was created in  Office 2007, but was saved in Office 2003 format (.doc).  The upload is done  with this code, which has worked in the past with PDF's:<cftry>    <cffile action="UPLOAD"        filefield="file_upload"        destination="files\temp"        nameconflict="OVERWRITE"        accept="application/unknown,application/pdf,application/msword,text/html,text/plain,application/rtf,text/richtext,text/xml">        <cfset accepted="true"><cfcatch type="any">    <cfset accepted="false"></cfcatch>    </cftry>When I cfdump the cfcatch structure after this fails, it shows the MIME type of the file that I was attempting to u