Questions

I have SQL query that returns last name of a person and I need to extract the last part of any hyphenated or last names with a space in themIn cases where the person has one last name everything is OKLike Smith. That OK. . I am looking for just SmithThe problem I have is when I have hyphenated last names like Scott-ThomasIn that case I want to extract the last last name or Thomas.Or if I have a last name like Rodham Clinton. In that case I only want to extract the last last name Clinton.How do I do this?

We have been having a problem where the server occasionally running very slow or simply hanging. Performance is uneven sometimes it works fast, sometimes very slow.Environment: ------------ Windows server 2003 STD SP2 (X86) IIS 6 Any pointers/help are greatly appreciated!Thanks!

Hi. I am using CF 9.2.1. I started learning CF yesterday, and I am trying to figure out a way to add a special character (like "?", "!"," & ") to an array row if the first row element (say, element [1][1]) has a specific letter like " t" in the word it is holding. In this case the special character will be added at the end of the last row element (element [1][3]).Example: The take columns are: "Firstname", "Lastname", "Age".  If Firstname contains an "s" or "S" (in any order) then add "!" at the end of the row so that :Sam, Rubins, 26 !Nick, Palo, 32Robert, Williams, 28Oscar, Ramirez, 23 !I tried using the ReReplace, Refind and the #findoneof functions. I could probably loop through the array and return a value and store, while storing the value in a separate variable and using an if/Boolean function to compare that value and so on.... But I am sure there's an easier and more efficient way. Thanks in advance.<!--- #1 I will create a three column query named CityInfo--->&

I am using Coldfusion Report Builder. If the value of a feild is zero, how can I hide it or show a blank. Keep in mind this field is a DollarFormat() field.

I am new to CF and I am trying to understand some CFSTOREDPROC code. My question is withing this code there is sometimes a CFIF statement to determine how the CFPROCPARAM is set, whereas with other lines this is not done. <CFPROCPARAM VALUE="#arguments.frmstruct.cutomerIdAutoValueContainer#" cfsqltype="CF_SQL_VARCHAR"vs<cfif isdefined('arguments.frmstruct.SALESPERSON') and len(arguments.frmstruct.SALESPERSON) gt 1><cfelse>     <CFPROCPARAM VALUE="" cfsqltype="CF_SQL_VARCHAR"></cfif>Does this make sense to have the code like this and why? Couldn't we just have the CFPROCPARAM without the CFIF to test the value if GT 1? i.e.     <CFPROCPARAM VALUE="#arguments.frmstruct.SALESPERSON#" cfsqltype="CF_SQL_VARCHAR">     <CFPROCPARAM VALUE="#arguments.frmstruct.SALESPERSON#" cfsqltype="CF_SQL_VARCHAR">

Hi,I am having problems setting up a datasource for a local sql express 2012 server. Its running as the default instance. Connections are working with ODBC and client told just not Coldfusion.When I try to set up a connection using the sql driver I get this error:Connection verification failed for data source: Leaf java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connect The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: 127.0.0.1:1433. Reason: Invalid argument: connectWhen I try a Socket connection with an ODBC connection I setup in windows I get this error:Connection verification failed for data source: LeafDB java.sql.SQLException: [Macromedia][SequeLink JDBC Driver]Internal network error, connection closed. The root cause was that: java.sql.SQLException: [Macromedia][Seq

Helloon two CF8 Servers which we are running for several years I could see that recently we have two processes inside the Jrun4 folder cfusion82\cfusion.ear\cfusion.war\CFIDE\m32\m32.exe and cfusion82\cfusion.ear\cfusion.war\CFIDE\m64\m64.exe taking 100% of the CPU. Action appears randomly and occurs on two server without any user interaction. Killing those processes does not seem to have any effect on the functionalty of the system.Also in the coldfusion reactor I am not able to see any request which would be connected to this behaviour.Does anyone know what are these processes? Strange thing is that the files have been created just recently and on each system/instances in different days.Thank you very much for answer!

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!