ColdFusion

I have an order form where my buyers can add items to my form. I am using a loop that adds an extra line when they add a new product. I am storing the info in two different mySQL tables. The first is alll of the personal info, the second is the items. THe personal info saves correctly. However, I get the following error when saving the items:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1, 'wer 2345', 1, 1 )' at line 9 The error occurred in E:\webs\clarkwebhosting.com\SSL\esrc\order_add.cfm Line 74 ++ After storing the personal info I grab the order ID to populate the items table<cflock timeout="5"><cfquery name="qGetorderID" datasource="#application.dsn#">select max(orderID) as oid from orders</cfquery></cflock><cfoutput><cfset getoid = #qGetorderID.oid#></cfoutput>++ this is the loop I am using to populate the items table ++<cfloop from="1" to="#form.n

A ColdFusion 8 project was running under Windows server 2003 which was upgraded to Windows server 2008.The project has frames and client variables stored in the registry.After the Windows upgrade, a few users have had client variables disappear. The variables are assigned and displayed in a template in a frame but lost after being submitted to another template in another frame.The users get an error that "element xx in undefined in client".What are possible causes and solutions?

Hello -We have recently migrated about a dozen sites to a new server running Windows Server 2012 R2 and ColdFusion 11.  Everything seems to be working correctly except for .cfr pages.  IIS throws a generic 404 when attempting to access pages with this extension.  We have the Jakarta virtual directory setup correctly and our file mappings also look to be correct.  Allowing the app pool to run 32-bit applications changes the error from a 404 to an internal server error 500.  Any ideas?  Thank you!

Hi. I have a field in my SQL database that is an integer field. When I try to use this field in my form, it only allows whole numbers to be entered. How can I allow numbers with decimal points to be entered? The field name is called Eng_Hrs. Here's what I have on the Form:<tr><td class="edit" align="left">Engineering Hours:    <input type="text" name="Eng_Hrs" size="12" validate="integer" <!--- required="no" ---> message="You must enter a valid number in the Engineering Hours field"></td></tr>I realize I could make this a text field and it would allow decimal points, but then how could I validate this field to make sure that only whole numbers or numbers with decimal points are entered?Thanks.Andy

Hi,Currently running Cold Fusion 11 on a 32 bit Windows 2008 server.At times receiving the message on the screen "The service is unavailable"Restarted the ColdFuison 11 Application Server service and the application came back.I  looked in the coldfusion-error.log file and found the following message:Caused by: java.lang.OutOfMemoryError: Java heap space] with root causejavax.servlet.ServletException: ROOT CAUSE: coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:309) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:462) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42) at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40) at coldfusion.filter.PathFilter.invoke(PathFilter.java:142) at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94) at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter

Hello-I upgraded my Windows 7 to Windows 8.01, and after up gradation Coldfusion services are missing from windows. i.e I have to start Coldfusion services Manually by going to C:\ColdFusion10\cfusion\bin and run the cfstart.bat fileAny idea to resolve the issue. ThanksRegardsTayyab Hussain

Hello,Do Universities receive a discount for the purchase of ColdFusion?Thanks!

Hello all.....below is my code snippet which is trying to initialize the connection using Java Socket and was working fine sine few days ago.All of sudden it stopped working and I am not able to understand what happened. can any one help what cause this issue.<!---Set and initialize the socket--->52 :     <cfset sock = createObject("java", "java.net.Socket")>53 :     <cfset sock.init("localhost", 1500)>54 :     <cfset success = sock.isConnected()>Error which I am getting is below.Object instantiation exception.An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: ''. Thanks in advance.

I've been successfully using Salesforce's api till they made the switch to SHA 256 algorithms about 2 weeks ago (HTTPS Security Certificate Change from SHA-1 to SHA-256 hash algorithms). I know that coldfusion 8 is capable of supporting sha 245 hashing, but I've had no luck connecting to salesforce objects. Where exactly do i need to implement the SHA 256 encoding? Here's my CF code that is currrently functioning on a server where the sha 256 hasn't been implemented yet: <cfhttp url="https://cs8.salesforce.com/services/data/v30.0/sobjects/SFOBJECT/describe" method="get" result="apique">  <cfhttpparam type="header" name="Authorization" value="Bearer XXXXXXX">   <cfhttpparam type="header" name="X-PrettyPrint" value="1">   </cfhttp>This works correctly, so I assumed I just need to do the hashing on either the url or the authorization value. l tried both, then one or the other, but still no luck. Any advice is welcom.

I am trying to fix a number of issues our company's platform has with an integration with Adobe Connect. One that has me perplexed is intermittent failures with the login method. We have one client whose credentials fail regularly, but not always. I have the login method call in a try/catch block with the CFHTTP output dumped into an email and sent to me. Here is a sample failure, using the cfhttp tag <cfhttp url="#httpCall#" method="GET" />:However, when I invoke the login method via browser, using the URL attribute that is invoked by the CFHTTP tag (eg. http://[host].adobeconnect.com/api/xml?action=login&login=[username]&password=[password]&account-id=[id]), I get the following callback:<results>     <status code="ok"/></results>The request header I get back is as follows:So, there is nothing wrong with the credentials passed in, nor with the response: it does return a MIME type of text/xml, when called directly. This points to

I have a report (CF10) that exports to an excel spreadsheet. Sometimes one of the fields needs extra height to show all the data. When this happens only the field needing the height expands and I need the entire row to grow taller.For all the fields:Under Fields and Properties under the Formatting section I have Stretch with Overflow set to True. Under Print Control I have Print When Detail Overflows set to True and Stretch Type set to Relative to Tallest Object.What am I missing?

Hi I've managed to change location all coldfusion log files for naming instance  but not ex catalina.out files: catalina-out.log and catalina-error.log.Anyone has any idea where settings are ?The only solution works so farredirect 1>>STDOUT.file 2>>STDERR.file and remove default log file folder..

Hi! I have a ColdFusion variable which contains a URL:For example, it looks like <iframe width="640" height="360" src="//www.youtube.com/embed/XXXXXX" frameborder="0" allowfullscreen></iframe>.What I'd like to do is replace the width of "640" with that of "450" and the height of "360" with "253". I'm passing a string into an "if" statement which will change the variables if the conditions are met. I CANNOT change the variables before making it a string. I must change the variables.What is the best way to do this in ColdFusion? I don't know this language (my expertise is more in JavaScript and PHP), so I appreciate all the help you could give me.Thank you for your help!BP

This piece of code:                 <cfscript>                 for (j = 1 ; j LTE 500000 ; j = (j + 1))                 {                         dummyc = createObject("component","Dummy");                         dummyc.dummyf();                 }                 </cfscript> that creates objects like this one: <cfcomponent name="Dummy" output="false">    &nbs

We currently have ColdFusion 8 Standard installed on a server running Red Hat Linux 2.6.This server is going out of service and we have a new one that is running Red Hat Enterprise Linux Server 6.6. I have been told that Coldfusion 8 will not run in this environment so we will most likely be purchasing and installing ColdFusion 11 Standard.In the system requirements for ColdFusion 11 it states: Red Hat Enterprise Linux 6.X (up to version 6.5).Does anyone know if I will have any trouble installing and implementing it with Linux Server 6.6. I don't want to purchase it until I can confirm.Thanks in advance.

I am looking for a helpful start (key words or even phrases) to begin understanding what it takes for a web site to give auto notification to an app on iOS and Android. I hope that wording is understandable, but in short how can things that happen on my website be automated to send the data as information to phones apps. Is this handled via web services? The way I was imagining it was like a site that a user (contributor) interacts with to let you know some feedback from another contributor is needed. The user (contributor) would then interact with the site and a phone application would instantly notify the other contributor. I was thinking this could be instant (as fast as servers can work). Simply from something like a click. Thanks

Installed Cold Fusion 11 standard, on window 2008 R2 and it will not serve up .CFM tags that are not in the root directory of a web site

Hi all,I would like to know if a ColfFusion 9 website (installed on Windows Server 2008 R2) can authenticate to Domain Controllers that run Server 2012 R2. We are upgrading our Active Directory Domain Controllers from Server 2008 R2 to Server 2012 R2, I would like to know if this will cause a problem for ColdFusion websites that use Active Directory authentication.Thanx in advance!Kind regards,Patrick

Anybody used wdCalendar (or a similar HTML5 calendar) with ColdFusion? I'm specifically looking for such calendar that let's you have a custom form when you create/edit an event.It doesn't have to be a free one. I'm willing to pay for it.Any help would be great.thanks!- Sivan

I have a ColdFusion 10 Enterprise server setup with a number of instances and a bunch of websites all accessing a shared codebase using IIS 8.5. After running wsconfig to setup the websites for ColdFusion it adds the *.cfm handler mapping in for each instance and site just fine. I'm attempting to use the application.cfc onMissingTemplate function to implement SEO friendly URLs with ColdFusion. To this end I have added a URL Rewrite to the web.config in that folder to rewrite URLs with no ColdFusion file to map to a non-existent cfm file:<rule name="Missing Templates" stopProcessing="true">     <match url="^(.*)$" />     <conditions>          <add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />          <add input="{REQUEST_FILENAME}" matchType="IsDirectory" negate="true" />     </conditions&

When I create a page and position objects with CSS style attributes ColdFusion debug info which is placed after the closing </html> by the server, is not pushed to the bottom of the page.  It is displayed as a background to the html objects, above background image, below HTML.  Is there a fix for this?  A server setting or CSS or HTML snippet that will force the debug info to the bottom of the page?ThanksBill

I have a summary report and a detail report. I would like to export both reports to excel on separate worksheets. I would also like to name the tabs.

can I upgrade ColdFusion 9 enterprise to coldfusion 11 standard?

We are experiencing an issue where our users are being intermittently logged out of the website. This issue seems to occur directly after the initial log in to the website. After a user logs in, they click a link, then are redirected to the login page again. We are upgrading from CF 9 to CF 11 and we were not seeing this issue in CF 9. There are two main things that I've noticed when this issue occurs. The GetAuthUser() call is returning an empty string (for the user that was logged in with cfloginuser) and part of the session has been removed (as if a structdelete was performed on a variable in the session struct).Is anyone able to help with this problem?

I run a small call center where a small group of employees log into an authenticated ColdFusion web site.  The purpose of the web site is to poll an Access database every 30 seconds, and any consumer asking for information (having submitted a lead from a web form that posts the customer info to the database) is then promptly contacted.  At this point the process is conducted using an index page that refreshes (every 30 seconds via a meta refresh).  But I am wondering if this is a scenario that would be better served through the use of web sockets? I must say that web sockets is a new technology to myself.  And upon my attempts to learn more via examples on the web, I find that the typical example consists of a web chat interface.  That too is intriguing to myself, but I am most concerned with at this time with a means to better implement efficiencies to the index page.  I estimate that 4,000 queries are made every day against the Access database.  It