Questions

I did a WEBMAIL using CFPOP.I want now to use CFIMAP,but when checking date (sentdate), I have a problem :I use function isDate(sentdate), it is OK, passI then I use ParseDateTime with POP attribute<cfif isDate(sentdate)>     <cfset l_date=ParseDateTime(sentdate,"pop")> I get an error : {ts '2011-12-09 14:03:53'} is not a valid date formatHow to get a valid date with this ?It did work with CFPOP and variable "date"Thanks for any suggestion about this change of date formatbetween CFPOP and CFIMAP.What do I need to use to get a valid date with CFIMAP and "sentdate" ?Pierre.

I have installed CF 8.0.1 in my machine and I want to upgrade it to CF 9 because it is the version required by our software. Any ideas is greatly appreciated.Thanks in advance!

I am using Homesite for many years,I would like to switch to CFbuilder,but it does not seem so easy ,My main problem, is that I used to work from my local sites directoriesand not from a working space or projects.So I would like to retrieve in CFbuilder a simple acces to my local websitesin my wwwroot server, and call files from this space.Should I have to declare a project for each website, which is a simple directory in the wwwroot ?And so, how.Thanks for help.Pierre.

It gives errorInvocation of this Java application has caused an invocation targetexception.Alsowhen I click detailZeroGu6: Windows DLL failed to load          at ZeroGa2.b(DashoA10*..)          at ZeroGa2.b(DashoA10*..)          at com.zerog.ia.installer.LifeCycleManager.b(DashoA10*..)          at com.zerog.ia.installer.LifeCycleManager.a(DashoA10*..)          at com.zerog.ia.installer.Main.main(DashoA10*..)          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)          at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega

In the yellow bar Dreamweaver informs me that: "Dynamically related files could not be resolved because your credentials don't allow file activity on the server." I'm quite new to al lthis so I'm not sure what the problem is or where it is. SO I try describe the problem with screenshots.I have set permissions to be allowed to connect from my IP adress in hostgator.The first two images are of me trying to add a recordset. I get the error that Dreamweaver can't connect to _mmServerScripts. Yet mmScripts i located on the root of the site at home/the ace as in other screenshots.The image on the left shows the error I get when I run the test. All the fields in it are filled out the same way as on the screen on the right except I add the "Root Directory" home/theace.Without adding the root directory(same as on the right screeenshot) I get succesfull connection to the SERVERDatabase screen                 &nb

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7930.html

HelloI'm trying to set up a connection to a dbf file. Don't ask me what kind of dbf. Most probably NOT FoxPro but may be "open" dbf. First I tried to set up a data source connection in the Coldfusion administration interface. I was choosing "DB2" as database type but I did not understand how to fill in the fields. Then I tried without setting up a data source connection and I found on the web something like:<CFQUERY NAME="myquery" DBTYPE="dynamic" CONNECTSTRING="Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\Inetpub\wwwroot\dbf\sample.dbf;">SELECT * FROM ???????</CFQUERY>Puhhhhhh, I do not understand this stuff. Can somebody help me out?Thank you

Hello, I purchased and installed Coldfusion 10 enterprise on a webserver that previously had CF 9..cfm compression was working fine on CF 9 but after I uninstalled CF 9 and installed CF 10 the compressionstopped working.The metabase.xml configuration is intact and the server runs windows server 2003 64 bit - IIS 6 - Coldfusion Enterprise 10 64 bits.What am I missing? 

I have  Windows 7 64bit, Coldfusion 10 64bit, I have tried add csv driver and MS Access at 32bit ODBC driver, but still cannot work.Please help what should I do?thanks!

As an CF server administrator ,  how can I give read only access to users for datasources and scheduled tasks?

I want to move data from one column to another. I thought I could just query points2 column then use a cfloop to update the data to points1 column. Finally null out points2 column. Below is my code on the first 2 steps. Unfortunately, I get the following error: Syntax error in UPDATE statement.The error occurred in wwwroot\forms\changepoints.cfm Line 18 <cfquery name="getPoints" datasource="#dsn2#">SELECT leaderID, points2from leaderboard</cfquery><cfloop query="getPoints" startrow=1 >   <CFQUERY NAME="DoUpdate" DATASOURCE="#dsn2#">       UPDATE leaderboard       SET points1=#getPoints.points2#       WHERE leaderID=#getPoints.leaderID#    (line 18)    </CFQUERY></cfloop>What am I doing wrong?

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7930.html

Hi,I have a portal webiste with banner and texts advertising . the advertisers want to know the statistics of the clicks to their website. I searched Google Analytics, coudln't find it. it said I should use a Java script code within the links, to make it work. I am not a Java script propgrammer.Does anyone have experience in this area?  any help is greatly appreciated.

Hi,I have a function that takes in a raw xml and covert to query.  The problem is any leading zeroes are gone.  For example, 000123 will become 123.  Is there any way or function in CF that will stop from removing leading zeroes?Thanks,

Environment ... WIndows 2000 server SP 4 (test environment) ... has CF7.0  installed already.  Trying to install CF10 over it. Get error message Microsoft VC++ 2008 Runtime. Redistributable Package is not installed.  Click OK, watch it install.  Over and over, reboot; always get same error message.  Ok, what causes that? Help!  Please.

I installed the devloper edition of CF10 on OSX 10.7.2 and the automatic updates function is not working. I can see the updates, click on Download and Install, then click Continue but nothing happens. Same with the Download button.Also get the following error when logging in to the CF admin:Error invoking CFC /CFIDE/administrator/updates/download.cfc : WDDX packet parse error at line 1, column 1. Content is not allowed in prolog.. [Enable debugging by adding 'cfdebug' to your URL parameters to see more information]Any help would be appreciated.

I have a basic count select statment that pulls back the top occurances of a certain pid in a table.  I am trying to join that table with another table to pull back the details about that pid but I can't seem to get it to work.  Would it be better to use union.This is my existing querySELECTpid, COUNT(pid) AS pcountFROM Table1GROUP BY pidORDER BY pcount DESCThe basic structure doesn't work..SELECT Table2.name, Table1.pid, COUNT(pid) AS pcountFROM Table1, Table2WHERE Table1.pid = Table2.pidGROUP BY propertyidORDER BY pcount DESCDoes anyone have advice on how to strutcure this... a certain join or a union.  It could be a LOT of records so I don't want to start this with the wrong structure. Thank you!This is ColdFusion 10 on MS SQL

ColdFusion 10 update 4 is now available for install. Important fixes + resolves issues with update 3. For details, read this post on the ColdFusion blog : http://t.co/IH91v6au

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WS5FFD2854-7F18-43ea-B383-161E007CE0D1.html

I can not find the CF10 metrics logs. Reference:http://www.adobe.com/devnet/coldfusion/articles/coldfusion-tomcat.htmlSays in part:Logging mechanism in ColdFusion 10ColdFusion 10 logs Tomcat metrics to metrics.logI can not find the metrics log on the file system or CFadmin web page. Is there some way of enabling the CF10 metrics logging as there was with older CF7 8 9 versions to enable jrun metrics logging? eg: http://helpx.adobe.com/coldfusion/kb/enable-metrics-logging-coldfusion-mx.html As always thanks, Carl.

I was wondering if someone knew the best way to write a query to pull back rows where a table field is found in a a variable string.  I'm using Cold Fusion 10 on Microsoft SQL Server.The table has a series of fields such as carcode          carnameG                GarageC                CarportA               AttachedD               DetachedAnd another query pulls back a field that stores as text all the abbreviations that apply I want to pull back all the carnames that would match the abbreviations stored in that field.  I thought I could use a contains line but that does not work.  How do I pull back matches against a variable string... I t

In this simple component (test.cfc):component {      VARIABLES.obj = {};     VARIABLES.obj.foo = "bar";     VARIABLES.obj['foo2'] = "bart";    remote function func1() {        return VARIABLES.obj;    } }The response from the URL “/test.cfc?method=func1&returnformat=json” looks like this: { foo2: "bart",FOO: "bar"}Note that if you declare the property of a structure with dot notation, it is returned in uppercase. Using array like declarations returns it as you specified.This is still apparent when dumping a structure in a page, but is more of a problem when accessing the results via JSON in a Javascript appliation, as this is case sensitive.Pete

How can i implement Previous week / Next Week, like previous n / next n records?Can you please send me links for implmentation code or help me implement?. Please help.thank you.Previous / Next n Recordshttp://tutorial20.easycfm.com/index.cfm?fuseaction=tutorial&tutorialID=20http://tutorial20.easycfm.com/

Have spent all day trying to get Cofldfusion (64) running on 64bit Windows Server 2008 R2 to talk to our Oracle 11 DBHave added the latest vesions of the Jar files belowclasses12.jarorai18n.jarojdbc6.jarUsing JDBC URL: jdbc:oracle:thin:@//192.168.1.xx:xxxx/yyyDriver Class: oracle.jdbc.driver.OracleDriverDriver Name: Oracle Thin DriverValidate Connection: Not enabled. But getting the following.Connection verification failed for data source: Maginusjava.lang.AbstractMethodError: nullThe root cause was that: java.lang.AbstractMethodErrorCan anyone help?

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-750b.html