Questions

I have following code to assign value from my stored procedures.The text cfinput works to get value from stored procedure, but check box does not get value.The check box value return to 1, but check box does not check.I would like to know are there any way to assign a stored procedure value to check box.Your help and information is great appreciated,Regards,iccsi, <td><cfinput type="checkbox" name="Mychk" id="Mychk" value="#MySP.MyCheckValue#"></td> <td><cfinput type="text" name="Mytxt" id="Mytxt" value="#MySP.MyTextValue#"></td>

Please,My Coldfusion 10 Standart change to Developer after restart server. I do no to resolve!Thanks,Eduardo.

Please download the attached file to view this post

I need to pass a byte array as my input and an int as the output length for the Class ProgramCall.My error is    parameterList[0] (null): Parameter value is not valid.My thoughts areI think (but I'm not completely sure) I'm having trouble because I'm passing a Coldfusion Array where a Java Array is needed to pass the arguments.Coldfusion arrays start at index 1 and Java Arrays start at index 0.(1) Am I correct in what I believe is causing my error?(2) How can I convert the Coldfusion Array to a Java Array? Here is the documentation for Java JT400 object Class ProgramCallhttp://publib.boulder.ibm.com/iseries/v5r1/ic2924/info/rzahh/javadoc/com/ibm/as400/access/ProgramCall.htmlHere is my code <!--- I am the system object ---><cfobject         action="create"         type="java"         class="com.ibm.as400.access.AS400"         name

I believe I am getting the hang of the left outer join, but I am not there yet.I have the same devotional that goes out to several clients which have the option of making changes to the devotional before it goes out.For example I have 3 clients and one of them changed the devotional. So two of them will get the original devotional and the third company will get the modified version.I’ve been able to figure out how to get the modified version to go out, but the 2 other clients are getting the modified version instead of the original. <!--- get subscribers timezone and layout options, ie: header and color combinations ---><cfquery name="getClients" datasource="#application.dsn#">select *from (subscriber INNER JOIN contacts ON subscriber.contact_id = contacts.contact_id) INNER JOIN layout ON contacts.contact_id = layout.contact_idwhere subscriber.timezone = '4'</cfquery><!--- determine which version of the devotional is available for this day ---><cfquery name="

CF Grid not generating due to this error.SecurityExceptionMissing required Permissions manifest attribute in main jar:http://   /CFIDE/classes/cfapplets.jarWhat is the fix for this error?

CF10 update 12 running on Windows Server 2012 x64. This is a legacy app that is just doing some basic CRUD and has a handful of form fields - a coupe of selects, a couple of radio buttons. It gets used once a year. Last year we would've been on CF10 with whatever update was current as of March 2013.When submitting the form, we get a Tomcat HTTP 500 error with the following text. I'm not able catch or abort anything since the error is coming out of Tomcat and not CF. I have insured that the isapi_redirect.dll connector has been rebuilt; I've restarted the server and CF admin has nothing unusual going on - nor are we sending much data to begin with. We have other pages on the same server processing thousands of form fields with no problem. Any suggestions on where to look here?"Severity","ThreadID","Date","Time","Application","Message""Information","ajp-bio-8012-exec-27","03/27/14","12:30:50",,"C:\ColdFusion10\cfusion\logs\coldfusion-error.log initialized"Mar 27, 2014 12:30:52 PM org.apa

Please let me know if you can help me with the following, I would be happy to pay for time to help create this codeI need a script which is capable of retrieving ALL of the Facebook IP numbers based on their AS32934 record, so that we have a list of ALL IPv4 IP's that they could potentially utilize.It would need to run on a ColdFusion 8 serverPerhaps these IP's could be retrieved from arin.net?According to facebook the follow command should workwhois -h whois.radb.net -- '-i origin AS32934' | grep ^routeThe script will output a list of all IP's which we will then be able to insert into our SQL database.ThanksMark

Apologies for what is no doubt a simple question - I'm trying to help out IT and I'm not a programmer, although maybe one day...Anyway, I'm going to need to read a text file, and search for a string in that text file and replace it.  I see "replace" as a function but I'm not familiar with how to use it.  Poking around I found <cffile action=append> and used that to add a line to a text document.  (Just a notepad .txt)Ultimately I'll need to unzip a folder, search and replace the string in a specific file in there, and then re-zip the file, but we'll get to that later.  I managed to unzip a folder already, that's easy enough.  Putting it all together is my current challenge.I'm using ColdFusion Builder 2.0Thanks for any help you guys can give.

I have following code to filter my second list from my list.It works when user click the dropdown, since onchange event trigger.I tried to load the data from stored procedure then the onchange event does not trigger, when user need update data then will see whole list without filtering.I would like to know if it is possible to trigger onchange event when I load data from stored procedure,Your help and information is great appreciated,Regards,Iccsi, <td><select name="Mylst" id="Mylst">         <cfoutput query="MySP">                  <option value="#MySP.MyID#"          <cfif (isDefined("form.MyID") AND form.MyID EQ MySP.MyID)>selected="selected"</cfif>> #MySP.MyName# </option>          </cfoutput>     </s

Any one know of a reputable firm I could take a crash 4/5 day programming class in NYC?

Hi all,I have an issue validating dates, my sample code:<cfoutput><cfset value1 = "21A"><cfset value2 = "05/02/11 12:45"><cfset tempDate= "05/02/11 12:45"><cfset value3 = "#DateConvert( 'Local2UTC', tempDate)#"><cfset dateValue = value1 />#dateValue #<br/>IsNumericDate - #IsNumericDate(dateValue )#<br/>isValid (USDATE) - #isValid("USDate",dateValue )#<br/>isValid (DATE) - #isValid("Date",dateValue )#<br/>isValid (USDATE, dateFormat) - #isValid("USDate",dateFormat(dateValue ,'mm/dd/yyyy'))#<br/><cfif isNumeric(dateValue)>    number <cfelseif IsNumericDate(dateValue) and isValid("Date", dateValue) >    date<cfelse>    varchar</cfif></cfoutput>Why CF9 thinks that 21A is date?If I use UTC date value isValid("USDate",dateValue ) = NOHow can I do better date validation?Any ideas?Thanks!

G'day:I'm concerned about how Adobe have implemented the list-oriented member functions in ColdFusion 11. And I was hopeing to capture some community input as to what other people think, before raising it with Adobe:Survey: lists in CFML, and the naming of list member functionsIt'd be cool if you could take the time to complete the survey.Thanks.-- Adam

Does anybody out there have a simple solution to scanning a range of IP's against a user's IP?Let's say I have a group of IP's123.456.654.10/50111.222.333.444.5/20I need a script where I guess I could put in the min and max and scan for a match against the end users IP #remote_addr#So I'd be looking at all IP's in the range:123.456.654.10to 123.456.654.50And the111.222.333.444.5to111.222.333.444.20Appreciate any helpThanksMark

Hi.  I'm using cfhttp to post data to an API.  An example of one of the parameters required as input by that API is "subscription[planId]".  Question is, how in the world to I pass a sort of "named array" like this where "planId" isn't a variable, it's text.  I apologize that clearly I'm missing something pretty basic here, but... I'm sure missing it.  Thanks.P.S.  In case it lends any insight at all, here's a snippet of sample PHP code that is supposed to do this (I cannot confirm, not being a PHP guy):"subscription" => array("planId" => "1")

I am using several threads within a ColdFusion request to create PDF files.  When I run the code on my ColdFusion developers edition environment, it works just fine.  However, when I attempt to run it on another environment, I always get the same error:An error occurred when performing a file operation read on file MYAPPDIRECTORY\WebRoot\WEB-INF\cftags\META-INF\taglib.cftld. The cause of this exception was: java.io.FileNotFoundException: MYAPPDIRECTORY\WebRoot\WEB-INF\cftags\META-INF\taglib.cftld (The system cannot find the path specified).The issue is of course that ColdFusion is looking in the incorrect directory.  I researched the issue and found the mention of a ColdFusion bug, but I am curious if anybody else has run into a similar issue and if they found a workaround/solution.

I have a function in cfc file like following to call MS SQL server stored procedure.The stored procedure check ID if ID exists then update table, if not then insert a new record. <cffunction name="NewRecord" access="remote">    <cfargument name ="MyID" required="yes" default="1" hint="My ID">   <cfargument name ="MyText" required="no" default="" hint="MyText">  <cfstoredproc datasource="mydatasource" procedure = "mySP">      <cfprocparam value = "#MyID#" CFSQLTYPE = "cf_sql_integer">      <cfprocparam value = "#MyText#" CFSQLTYPE = "cf_sql_varchar"></cfstoredproc>   </cffunction>The insert works if the record does not exist from my click button on cfm file, I run the stored procedure works from SSMS works on update and insert.I got excute query error when the record exists in the table.The update works if I provide integer value for the text field.[

I have a Web, that use a symbolic link for centralized code. The Application.cfm, stored in the original web-root, will not read from codein the linked directory.Thank you for your assistance.

I'm exporting data to an Excel Spreadsheet but when the Excel spreadsheet is generated, if the user has used a carriage return during data entry, it creates a a new row in Excel. I've tried using a replace in the export field #replace(Comments,Chr(13),"", "all")# and if I use: #replace(Comments,Chr(13),"xx", "all")# I can actually see the xx, but the extra row is still being created before the rest of the entry starts. Any ideas on getting rid of the line breaks during export? Full Code is below (edited for clarity). <CFSET tab=chr(9)> <CFSET carriage=chr(13)> <cfif action IS "export"> <CFHEADER name="Content-Disposition" value="inline; filename=MNC_Data.xls"> <cfcontent type="application/vnd.ms-excel"> <cfquery name="get_Data" datasource="#appDSN#"> SELECT ml.DateSubmitted, ml.FirstName, ml.LastName, ml.Address1, ml.Address2, ml.City, ml.State, ml.comments, FROM #diff#mailing ml </cfquery> <cfoutput>Location#tab#Date Submitted# F

I read on a different forum that coldFusion 9.0 installs can be requested from support for developers who are working with clients who have not upgraded to CF10.  Where does one make that request specifically?

Hi all.  We are a county government organization that needs to keep all of its application and server  configuration settings backed up in the event of a disaster (flood, earthquake, terrorist act, etc.). I don't see a way to back up the CF Admin settings for CF10 Standard.Does anyone know how I can back up the settings and then restore them if needed?Thanks for your time.-Andy

I have and exisiting form and I want to take the email and name from the form and input it into mysql database of emaillist . I also only want to do this if the i wish to subscribe is selected.Quotation Request For:Date: #DateFormat( Now(), "MMMM DD, YYYY")#Need By: #form.needby# Company: #form.company# Name #form.firstname# #form.lastname# Title: #form.title# Address: #form.address# #form.city#, #form.state#, #form.zip# phone: #form.phone# fax: #form.fax# e-mail: #form.email#Reference: #form.reference#DescriptionTruck Mounted Tank Capacity: #form.capacity# Fill Valve: Size: #form.fill_valve_size# Style: #form.fill_valve_style# Discharge Valve: Size: #form.discharge_valve_size#Vacuum Pump: #form.vacuum_pump# : #form.other_vacuum_pump#Aluminum Toolbox, Size: #form.toolbox_size# Mounting: #form.mounted# Misc. Custom Features: #form.custom_features#Service Units#form.port_toilet_service#UnitsMaterial: #form.scu_material# Number of Compartments:#form.compartment#Vacuum Pump:#form.scu_vacuu

Our Coldfusion 10 Standard server does not ever spike higher than 25%.I have a hard time believing we write such incredibly excellent code to have over a hundred users never make our server spike above 25%...How do I check to see how many CPU's ColdFusion is using or the maximum number of cpus it will use?Thanks!

When I logged off my bank account, the words "transferred to ColdFusion" appeared. What does this mean? My bank suggests virus or mole.

I am having an issue on one of our production ColdFusion 9 servers where the session variables are never timing out.I set up a very simple page to make sure I'm not missing something.Application.CFC page (I tried Application.cfm as well)<cfcomponent><cfset This.name = "TestApplication"><cfset This.Sessionmanagement=true><cfset This.Sessiontimeout="#createtimespan(0,0,1,0)#"><cfset This.applicationtimeout="#createtimespan(5,0,0,0)#"> <cffunction name="OnApplicationStart"><cfsetting showdebugoutput="yes" enablecfoutputonly="No"> </cffunction> <cffunction name="OnRequestStart"><cfdump var="#this#"> </cffunction></cfcomponent>Index.cfm page<cfif isDefined("Session.TimeStamp")><cfdump var="#Session#"><cfdump var="#Application#"><cfoutput>#Session.TimeStamp#</cfoutput><cfelse><cfset Session.TimeStamp=Now()></cfif>The TimeStamp session variable never times out and once it is