ColdFusion

Hello, everyone,I'm kind of getting the hang of querying LDAP.  Now, I'm trying to learn how to MODIFY an LDAP entry.  I'm attempting to set department to "WebShop" for any entry that has a non-NULL mail attribute.The following code:<cfldap action="modify" attributes="department=WebShop" dn="mail=*" server="first.second.tld" username="#request.cfldapun#" password="#request.cfldappw#">.. is returning an error message:LDAP: error code 1 - 000020D6: SvcErr: DSID-031006CC, problem 5012 (DIR_ERROR), data 0The user account that is accessing the AD LDAP has admin privileges for the domain.  What am I doing incorrectly?V/r,^_^

We have few instances running in ColdFusion 9.0.1 environment that we need to rename. I tried some google searches and found nothing that would help me do that. I can rename an instance in JMC Admin tool, but when I do that, the Windows service for that instance will not start (I suspect it's because the two names no longer match). What step am I missing? Thank you

Hi,I'm using ColdFusion version 10,0,11,285437.I'm trying to create a Scheduled Task using ColfFusion admin page. If I set Start Time as "1:00 AM", I get message saying: "An error occured scheduling the task.1:00:00 ap. is an invalid date or time string."And same error message comes with any input. Here are some examples what I have tried:"01:00", "13:00", "13:00:00", "1:00:00 PM"...

We seem to be having issues with Jrun Closed Connection/Server errors occuring on a daily basis now. The server will stop responding to requests until the ColdFusion service is restarted.We're using CF 6.1, the following error message is from the log files and seems to be Java/JVM related but I was hesitant to make any changes to the JVM parameters.Any suggestions on how to resolve this daily issue of restarting CF service? Other than upgrading to more recent version of CF which we'll be doing later this year.Thanks,Dave>>>>>>>>>>>>An unexpected exception has been detected in native code outside the VM.Unexpected Signal : EXCEPTION_ACCESS_VIOLATION (0xc0000005) occurred at PC=0x77FCAFF8Function=[Unknown.]Library=C:\WINNT\system32\ntdll.dllNOTE: We are unable to locate the function name symbol for the error      just occurred. Please refer to release documentation for possible      reason and solutions

Hello, everyone.I'm going to be learning as much as I can about CFLDAP.  Pointers appreciated.Some questions:1. Is it possible to import/export data between LDAP and an Excel spreadsheet?  Or XML?  Other formats?2. If I don't know any structure values (like organization, etc), I will need to put something in the "start" attribute; are there any values that can be used, if not obviously known?  (My practice LDAP server hasn't been set up, yet.. just curious.)3. There was a third question in my mind when I started this thread, but I've forgotten it.  I'll come back and edit this, if/when I remember.V/r,^_^

Good afternoon,We have a weekly magazine that was at a wholesale price of $0.70 to purchase.  The retail price was $1.00. After February 21,2014 the price of this magazine's wholesale price has increased to $1.00 and the retail price increased to $2.00. All wholesale prices before February 20, 2014 was at $0.70. What I am trying to do is tally up the total that each salesman sold say from January 01, 2014 thru today 03/06/2015 reflecting both to totals from the old wholesale and the new wholesale price. So if I had a member that sold one magazine per week from 01/01/2014 until 02/19/2014 at the $0.70 price, it will total $5.60.Then from 02/20/2014 until 03/06/2015 sold 1 magazine per week at the $1.00 price I get $3.00. The total from January 01 until March 06,2015 would be $8.60. The old code using the $0.70 wholesale calculation is below. The new code using "cfif" statement (which it throwing the error) is right below that. Am I doing something wrong?<!--- Existing Code---&gt

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