ColdFusion

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

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

I have a query that has rows added to it from another source. I have a QoQ which then updates the order by (date order). I then need to set a startRow and endRow limit like MySQL's LIMIT to page the recordset back to an AJAX call? Does anything know how to do this?CheersShaun

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSc3ff6d0ea77859461172e0811cbec0e4fd-7ff0.html

Hi, I'm using the following query/<cffifle> (see below) command to create a .csv with information from our SQL 2008 database. However, I'm having a problem when exporting data fields with certain characters in them. Specifically, line breaks and ' " 'For example, one of our product's description may be:18.5"  HP LED BL MonitorThe " character disrupts the format of the field, because field-transitions are marked with double quotes.Is there a way to escape this character? (And perhaps others, such as line breaks and special characters)Alternatively, is there a better way to export specific inventory information other than the current method? Notes : This is a verbose function that runs in a web browser. This detail isn't necessary.I can provide the full .cfm file as well as the ouput if necessary. -------------------------------------------------------------------------------------------------------------------------------<cfoutput>Getting Active Products..</cfoutput&

I'm trying to cache a query on our live web server, but not on our testing server (developers need to see changes realtime, but the public doesn't).I tried something like this:<cfif listfirst(servername,".") eq "test"><cfset cachetime = 5><cfelse><cfset cachetime = 0></cfif><cfquery name="GetContactInfo" datasource="MyDSN" cachedwithin=#createtimespan(0,0,cache,0)#">SELECT....But the results were unexpected (it didn't seem to work).Is there a way to do this?

I want to reinstall ColdFusion 10 as I have a corrupted installation since Windows Crashed 98% in.  When I try to reinstall using the 64bit installer, it only gives me the J2EE server configuration option instead of server.  So, I proceeded on attempting to uninstall it from the programs menu in Windows, but am receiving the following error:The uninstallation could not complete due to an error.I'm not sure what the error is or where to even find log files pertaining to this.  Is there a manual way of uninstalling CF10 completely?Any help would be appreciated, thank you.

(I first posted this on the dynamic dreamweaver forum but I think I was supposed to post my question here)Hi,I'm trying to figure out a way to notify someone that another person has replied to a post they made in a discussion.  I'm pretty sure I know how to figure out who the email should be sent to, but for now I'm just trying to get it to work by just sending it to my personal email.  This is the code I'm trying to get to work:Thanks,Mike======================================================================                  <cfif isDefined("FORM.title")>  <cfprocessingdirective suppresswhitespace="No">      <span class="blogtitle">Your Email has been sent.<br><br>I'll get back to you as soon as I can.    </span>     <cfmail           &nbsp

I read Raymond Camden's blog post about triple related selects and I'm trying to implement a solution of my own.  I can only get the first dropdown to populate and am getting three bind errors "Bind Failed, element not found: SelState ..." for the first two and then "Bind Failed, element not found: SelDestination ... " for the last.My code looks accurate (to me anyway) but clearly its not working.Can someone please help me debug this?<cfform name="Localiza"><table><tr><td width="100">State:</td><td width="150"><cfselect name="SelState" bind="cfc:_fc_cfc_triple.GetState()"        display="misc_state" value="misc_state" BindOnLoad="true"/></td></tr><tr><td width="100">County:</td><td width="150"><cfselect name="SelCounty" bind="cfc:_fc_cfc_triple.GetCounty({SelState})"        display="destination_county" value="destination_county" Bin

As part of the installation I was led to the web admin to complete the configuration; whereas, I was not allowed to continue because my credentials were stated as wrong . I was able to successfully go to one of the other remote computers which its IP was included in CF10s "Secure Profile" settings. After that I entered 127.0.0.1 as part of the allowable IPs. Still no luck with getting access from within the same server as CF10.Details:Win2008R2IE9CF10 Enterprise

've just installed Coldfusion 9, and everything is now working fine and it's connected to my MySQL databse via the Coldfusion Administrator as a datasrouce, but I get this error occuring infrequently, maybe 5 - 10 times a day. I don't know how to recreate it, and if you get it and refresh the page it goes away.Error Executing Database Query. Communications link failure Last packet sent to the server was 0 ms agoThe error is being caught by coldfusion as it's displaying a user friendly message and emailing me the problem.Almost all of the time the pages load and work fine, and this problem has only happened since going from CFMX7 to CF9, both using MySQL.The MySQL version I am using is "5.0.77"I've tried localhost and 127.0.0.1 as the host in the datasource, it makes no difference.Does anyone have any idea what this is and how to fix it? I've seen some similar posts for Java but I don't see how to translate the fix across into Coldfusion?And could it be a MySQL or Apache problem anyway?

Good Morning,I'm a newbie when it comes to this so I apologize ahead of time.I'm trying to build a Year/Make/Model related select search. I found a HTML, PHP, and the JQuery Related Select Plugin that i'm trying to convert to use with CF. It looks like i can use an array to replace the PHP page that supplies static data: <?php $stateID = $_GET['stateID'];$countyID = $_GET['countyID'];$townID = $_GET['townID'];$html = $_GET['html'];$states = array();$states['MA'] = "Massachusetts";$states['VT'] = "Vermont";$states['SC'] = "South Carolina";$counties = array();$counties['MA']['BARN'] = 'Barnstable';$counties['MA']['PLYM'] = 'Plymouth';$counties['VT']['CHIT'] = 'Chittenden';$counties['SC']['ANDE'] = 'Anderson';if($stateID && !$countyID && !$townID){          echo json_encode( $counties[$stateID] );} elseif( $stateID && $countyID && !$townID ) {          echo json_enc

HI, I upgraded from CF8 Dev to CF9 Dev edition a few months ago. I haven't coded much since then, but have noticed that when I open CF Admin, it doesn't seem to want to load. When I click stop on the browser and then reload, it opens fine. I have a desktop shortcut to a little password manager I use and the same thing happens when I try to open it as well. This was never an issue with CF8.Anyone have any idead why this issue would be occuring? Not sure which information from my server configuration is needed, but I'll be glad to post any info needed. Thanks in advance!

We have resently installd CF 10 64 bit om three new windows 2008 R2 servers.One of them keeps generating an error "PermGen Space null" when processing CF script files.There is nothing special about the scripts resulting in errorwe have tried to increse Maxpermsize from 192m to 768m but that had no effect.the other two servers seems to bee doing fine.Any ideas what to do?

Is there a way of making a field visible and Required if a particular selection is made in a drop down menu.For instance I have 4 different options in my drop down menu including "Other" and if Other is selected, I want a new text field to be visible so the user can add more specific information.Any help or guidance would be appreciated.

Can someone tell me what is wrong with this code? I'm getting a too few parameters expected 4 error. <cfquery datasource="poll" name="registration">          INSERT INTO Members(login,password,first_name,last_name,email,phone,address)        VALUES ("#form.username#","#pw#","#form.firstname#","#form.lastname#","#form.email#","#form.phone#","#form.address#")    </cfquery>All database fields are text even for the phone number and password.

Hello Everyone,I have some code (posted below) that works great to develop a 2 level drop down where the second selection is based on the first.  What I want to do is adapt this to be a 3 level drop down where the second selection is based on the first selection and the third selection is based on the second selection.  I have seen several examples but I am not a coder and do not know java script so I was not able to make them work.  The example below I understand so I would like to use this format.  Any help would be much appreciated since my deadline is fast approaching.Thanks                  <cfif isDefined('form.Park')>                    <cfset page.Park = form.Park>                 </cfif&

I cannot get cfcookie to stop expiring immediately.  It worked fine until recently switching to a new VPS.  Now the cookies only get set the first time Application.cfm is run.  If you visit any other page in that same director the cookie mysteriously disappears.Here is my application tag...<cfapplication name="KYND" sessionmanagement="yes" sessiontimeout="#CreateTimeSpan(0,3,0,0)#" setclientcookies="no" setdomaincookies="yes">http://www.kyndoutdoors.com/dbf/_kynd-controller/my-kynd.cfmUse timmyv as both the username and password.

I'm not completely clear on how cfinvoke works.Am I using the returnvariable correctly with this cfinvoke?  Would the variable scope name be the returnvariable name?  Is it returned parsed?Can the return value come back to the same page that had the cfinvoke on it or should it be a separate page?<cfinvoke component="#PaymentGateway#" method="createSubscription" returnvariable="result"><cfoutput>#result.resultcode#</cfoutput>Thanks!

Hi,I am new to cold fusion and have been hunting for something that will take me through creating a very simple (e.g. "Hello World") cold fusion application in CF10. I have just downloaded the developer edition and have been unsuccessful at finding something that actually gets me started! The web site is all about what's new in 10, etc, but nowhere can I find something that takes me through the steps of creating, installing and testing the application.

I have this problem with a dummy site i'm working on (for learning purposes) and i have 20 form text fields with an "add extra field" button. They are for entering sales of products, but the problem i'm having is that i use a DB, but come to realize that anything greater then 20 entries won't work if i want to use a DB. So i was wondering if you can save the information given from the form fields onto a file of some sort (like excel or pdf), but later on if i want to make a change to an entry on that file would it be possible to recall the file and make the changes accordingly without rewriting the entire thing?Hope that makes sense. thx

Using cfindex to attempt to boost the "Question" field over the "Answer" field of Q&A data. I see no effect from adding anything in the fieldboost field on the index.<cfindex action="refresh" collection="faq" type="custom" title="question" body="question,answer" fieldboost="question:2" key="faq_id" query="updateQuery" location_i="location_id" />I get the exact same results if fieldboost is there or not. No change.

We have a client that created a webservice to identify users.  They are requireing that we use that service to identify users.  I seem to have read somewhere that someone used .net to create the connection and then passed that data to ColdFusion ( or allowed access to the data).  Subsequent searches have not proven to be fruitful.  Has anyone else run into a similar issue?  Know where I can find some information on how to accomplish this requriement?

We have a CFC page that was working fine before moving to CF9 from CF8.  Any ideas on why it is no longer working?  It is not processing at all now - just giving us this error.<cfcomponent displayname="Checks For Email Address" output="true" hint="Checks for an Existing Email">               <cffunction access="remote" name="CheckInData" returntype="boolean" description="Checks Email and Returns True if Email Address Exists" hint="Checks Email and Returns True if Email Address Exists">               <cfargument name="Email_Check" type="string" required="true"/>               <cfquery name="data" datasource="datasource" dbtype="OLEDB">            SELECT      &nbsp