Questions

HI, can i ask some help,...i have some sql statement that will delete records to the database.but i am confuse on this,what if the third sql statement failed to process and then the first and second delete statement are successfully deleted the records?.how can i return the data that was deleted...I am using cf version 9<cftry>      <cfquery>       // delete statement here    </cfquery>   <cfquery>       // delete statement here    </cfquery>     <cfquery>       // delete statement here    </cfquery>      <cfcatch type='Any'>     <cfset log_error='#CFCATCH.Detail# #CFCATCH.Message#'>      <cfquery name="automatedtask" datasource="#mysource#">       //   INSERT statemnent here   

Hello I am new to cold fusion.I am wondering if there is a way to query a csv file using a read from cffile? Currently I have it setup as a cffile read and then I try to query the file using cffquery. Obviously this doesn't work because I have to set a datasource. Is there anyway to do this or any way to set a csv file as a data source? Any help or direction would be greatly appreciated.Thanks.

Hi,I have a requirement where I need to export query results to Excel. I have a generic code where i can export details to excel which requires query resultset. Is there any way to get the queryresultset from another page?To explain in detail, I have queried DB and I have resultset in First Coldfusion CFM page. I need to use that result set in another coldfusion page. Please help.Thanks,Ravi

Using cfmap in version 9.02 to work with Google maps v3.Location is displayed correctly.  Address is obtained from a query Cannot obtain a marker on the map using below code.            <cfmap             centeraddress="#google_address#"             name="locationmap"             height="350"            type="map"             zoomlevel="15"            scrollwheelzoom="true"            doubleclickzoom="true"            continuouszoom="true"         

Our Coldfusion 10 Standard server ( win2008 IIS7 )  has been handling flash remoting requests from our flex app and AIR IOS, AIR Android APP sweetly for over a year until a few days ago.We're now getting frequent errors of the type: REMOTEOBJECT ERROR Client.Packet.Encoding Error deserializing client message. null- when sending a VO to a coldfusion CFC as follows:mainApp.routeRemoteCall('lessonService','recordLesson',{aLessonVO:myLesson,runIte:runIte},this)     <cffunction name="recordLesson" access="remote" returntype="String"><cfargument name="aLessonVO" type="appcfc.cfcs.LessonVO"> <cfargument name="runITE" type="boolean" >etc etcWe've made no code changes on server or apps to trigger this. We've restarted server.The errors are intermittent and distributed across users.  Typically you get an error when you start a session of use then it resolves. Errors are more common when more users are connected - as you always expect  - howeve

Hi,I have set up a chart in coldfusion 9 which contains 2 line graphs and 2 bar graphs, and also added xml so the chart has 2 y-axis.I have noticed that one of the chartseries is assigned to one of the axis and the other three are assigned to the other. Is it possible to amend so that each y-axis has two graphs assigned to them.Hope this makes sense?Thanks in advance

I recently created a web page for my FlyBoard company in Colombia called Cartagena FlyBoard and thanks to Adobe Flash Player, it came out really cool. Check out the FlyBoard on my website www.cartagenaflyboard.com. Thank you Adobe!

I have a strange problem that has started happening with an application. The application uses a client variable to store the users account number. I am using a SQL database to store my client variables. This doesn't happen with every user, but it seems to be increasing. When the customer logs into the website, I write the client account number. In most cases, client data is stored in the data column in the CDATA table as it should, but for some users, the data is not in there. The cfid/cftoken combination is there in the cfid field, and the app name is there in the app field, but the data column is empty. The strange thing is...when I monitor the log in, the data shows up for about a second when the customer logs in, but then it is removed. Any idea what could cause this to happen?

Installed CF10 dev edition, wtih internal web server on my laptop and desktop. Both 64 bit win 7 and did the servery updates. Laptop sees css file, while the desktop does not - same code base.I have reinstalled CF10 on desktop, but it did not fix the problem.Any ideas?Thanks,Sam.

I've been using CFEclipse for years, looking at CF Builder as an alternative.I installed the trial, been using it for a couple of days and like it so far, but I can't figure out (and I spent way to much time trying) how to get the CFML toolbar to show. I'm probably missing something very basic.Can anyone please point me in a direction?Using CF Builder on OSX Mavericks.Thank you

I am trying to multiply each element of an array by a number (5)Is there an easy way to do it or need to write a function for that?

Hello there...I have a very hard job to do here in the office...Documentation in general...So my problem is this (and i think it's somewhat complicated, at least for me)I have to scan about a dozen of thousands of applications (style: form) and then i have to save and name them.THE PROBLEM:The name of PDF has to be a application field-number, with many characters.I want this number to be pdf's filename while i'm saving....Conclusion: Because of the outrageous number of papers that have to be scanned, i lookup for a solution that will help me from spending time on writing each PDF's filenameThank you very much for your time..I appreciate any help...

HelloI need to count the number of values selected in a form.Here is my form dump:I want to count the values circled in red.So the number I want in this case is 5.Any suggestions?

I need to use Coldfusion 10 to develop my software and sell to my customers. How do I purchase this special license wich gives me the right to distribute CF10 license?Tks,Dario Machado

Hello,I am using CFMX 9 and while playing with the settings in Sandbox Security now I cannot get access to CF Admin. I get the following error:Security: The requested template has been denied access to createobject.Please help....it's urgent

The web service is written to return:<?xml version="1.0" encoding="utf-8"?><UserContactInfo xmlns:xsi=http://www.w3.org/2001/XMLSchema-instance xmlns:xsd=http://www.w3.org/2001/XMLSchema xmlns=http://tempuri.org/><Firstname>Nelson</Firstname><Lastname>Broat</Lastname></UserContactInfo>But somehow Cold Fusion 9 is seeing it as XMLData is org.tempuri.UserContactInfo@16259b42which must be why we have the prolog error.<cfinvoke webservice=http://ouripaddress/folder/servicename.asmx?WSDL method="GetUserBio" returnvariable="XMLData" refreshwsdl="true">   <cfinvokeargument name="uuid" value="#authuser#"/></cfinvoke><cfdump var="XMLData is #XMLData# output="console" /><cfset trimXMLdata = trim(XMLData) /><cfset tmpXML = XMLParse(trimXMLData) />This webservice was written in .net   and runs off a 64-bit computer running Windows 2008 Server R2Is there something special we need to do here? The above

I am hesitant to try to change the JVM Arguments. In the past ColdFusion has failed to restart for me when I changed them. Any advice would be welcome.

Good morning, Is there a method which would allow me to create a ColdFusion report with a 2 page layout?  On the odd pages (the front side), this page would include the data relating to the report and on the even pages (the back side) would include a legend and would be the same on every even page.Thanks,- Chris

I am doing some research on converting from CF9 to CF10.  I have installed CF10 Developer Edition on my workstation.  For some reason I cannot connect to the Mail Server from CF 10 Admin Page (Connection Verification Failed from Mail Server Settings page).  It is working fine with the same settings within CF 9-I have both CF9 and CF10 Dev Edition installed.  Has anyone else run into this?  I am not having issues connecting to dbases or other external sources, so I do not believe it's a network connectivity issue, however in mail.log I am getting the error below: "java.net.SocketException: Network is unreachable: Connect"  Why would this be a problem with CF10 and not CF9?

Hey Folks. Is anyone out there running CF10 on WASCE? I'm trying to.. it deploys ok it seems, but seems like there are a couple of issues during the startup:11/05 11:07:22 INFO Starting Flex 1.5 CF EditionNov 5, 2013 11:07:22 AM Information [main] - Starting logging...Nov 5, 2013 11:07:22 AM Information [main] - Starting license...Nov 5, 2013 11:07:23 AM Information [main] - Evaluation Edition enabledNov 5, 2013 11:07:23 AM Information [main] - Starting crypto...Nov 5, 2013 11:07:23 AM Information [main] - Starting security...Nov 5, 2013 11:07:23 AM Error [main] - Unable to initialise Security service: java.lang.NoSuchMethodError: org.apache.log4j.Logger.<init>(Ljava/lang/String;)VNov 5, 2013 11:07:23 AM Information [main] - Starting scheduler...Nov 5, 2013 11:07:23 AM Information [main] - Starting WatchService...Nov 5, 2013 11:07:23 AM Error [main] - Unable to initialise WatchService service: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Security service is

I am trying to insert or embed and image into cfmail from a database-stored path to an actual image. The actual JPEG image is stored in a folder called "images_personnel". The path to the image under the column titled photopath is stored in my database table as "/file/images_personnel/28.jpg". Displaying the image on the screen renders without a problem, embedding the same image as part of a cfloop query does not insert/embed the image into an email. All of the other output of the same cfloop displays and emails just fine. However none of the photos of each personelle show up. What an I doing wrong?My code is below:<cfquery name="Staffreport" datasource="master">Select staffreport.*, name.personnelid, name.email, name.last, name.noiid, stafflt, CONCAT(name.fname,' ',name.middle,' (',name.last,')') AS teammember, CONCAT(name.fname,' ',name.middle) AS teammember2, concat(name.photopath,'',name.photo)as hisphoto, stafflt.*, trim(concat(ltfname,' ',ltmiddle)) as LT from Staffreport,

Hi,When I installed CF10, I selected the option in the installer to install the documentation.  However I cannot see any sign of it on my PC.Where does it put it?  I realise I can access it online, but I have always found it much more efficient to have an offline copy running on my local server.Alternatively, is it possible to download the docs as a zip file and install them locally?Regards,Andrew.

I am using Coldfusion MX and trying to access a shared folder across the network for listing its contents using <cfdirectory>Even though the shared folder is accessible via normal windows actions (i.e., got to run and type \\server-name\folder-name, i am able to view the contents and access the folder contents) but unable to access via cfdirectory. Also DirectoryExists() method returns false. This is so weird.I have checked the share properties for the folder in that server. everything seems fine as i am able to access the shared folder via windows. Clueless as to why cfdirectory doesn't recognise this folder in remote server.Can someone help with this issue?

I guess EWS is the way to go since Adobe bailed on the CFexchange tags.  I need to access my mail/calendars on a hosted exchange server.  I'm using CF 9.0.1 with hotfix4 and Java 7.  Here's the error I get;Error:Could not log in to the Exchange server. ________________________________________connection="exchangeConn"server="EXVMBX016-5.exch016.msoutlookonline.net"username="exch016\j_ttt"mailboxname="j@ttt.com"password="[removed]"Protocol="http"port="80"formbasedauthentication="TRUE"formbasedauthenticationURL="https://owa016.msoutlookonline.net/owa/auth/logon.aspx"Here's the code I copied from this forum;<cffunction  name="EWSAddEvent" output="false" returntype="Boolean">    <!--- EWS added by vjl  2013/10/31 --->    <!---        CFExchange in CF server  9  or older will not talk with Exchange 2010 at all, it is promissed to be fixed in CF 10.     &

I have over 2,000 emails in mySQL database with company names as well. Unfortunately, these subscribers do not enter the company name the same. So I came up with the idea to pull the company name from the right side of the @ symbol, ie: yourname@company.com. But try as I may, I have not been able to figure out how to do this. Can anyone help me out here?