Recent content by fdgsogc

Hi, Here's my problem statement: I'm using a query that uses the SQL Pivot function. But I'm having issues displaying the results. Here's my query. <cfquery name="showprofileresults" datasource="#db#" username="#dbusername#" password="#dbpassword#"> select * from ( select...

This is a two part question. - I am building a report in Report Builder 3.0. - I have one datasource (an MS Analysis Services cube) with two datasets. - The first dataset has a single value using one parameter to filter for a single location and a date parameter to filter for single day of...

I have a cfscript from the common FCKeditor. See code below: <form id="issueinsert" method="post" name="issueinsert" onSubmit="checkDescription();"> <cfscript> fckEditor = createObject("component", "fckeditor/fckeditor"); fckEditor.instanceName = "issuedescription"...

This is great advice. thanks!

I have a child window with email address in a form that I want to pass onto my parent window with a form. I am getting an error saying, "opener.document.formname is undefined". where "formname" is a variable that I passed in the javascript script call on the parent form which is then used by...

Hi, I want to catch a database truncate error and provide a very specific message that indicates the user is entering too much information. That is, I don't want to just catch the database error generally and say, "You have a database error.". The error code is 8152. Can I catch that specific...

Thanks Glenn. I'm getting where you're going with this. However, I don't have an EVALUATE function in my Excel 2007. Is this found with an Excel Add-in?

Here is a proper working link to the sample file.http://www.claimscorpinc.com/files/formulabuildertest.xls

I am creating an Excel template that will build a report based on responses to a questionnaire and based on how the questions are answered, different text will appear in the report on second worksheet. However, I don't want to hard code the formulas for the text output. I want an admin type...

I have a table of user permissions for project records. I want to be able to select the users that share permissions for the same projects for a selected list of users. Here is an example of the record set for the permissions table. USERID PROJECTID 5 43 5 44 5...

So here's what I ended up with. I think this will work. I'll end up with a few dashes because I'm not using a regular expression to find the number of dashes but rather the words, "Original Message". Thanks for all your help. <cfset bodytext = #htmlcodeformat(getmail.body)#> <cfset...

I'm able to get rid of all text with this following expression, but how to I limit it to only all text AFTER my "----Original Message----" text? <cfset cleanbodytext = reReplaceNoCase(bodytext, "[a-z]*", "", "all")>

OK. I'm part of the way there. I can take the body of an email and remove the "--- Original Message ---" text whether it has 2 or more dashes. My next challenge is that I want to remove every other characters after the "--- Original Message ---" text. Not getting how to instruct selecting...

Hi cfSearching, May I ask for one more favor. I am receiving emails into a database. But I want to peel away everything after and including the "original message" text: -----Original Message----- Sometimes there are more or less dashes from a user depending what email system they are...

Thanks very much. I used this version of your solution: <cfset result = reReplaceNoCase(fromEmailString, "^([^<]*<)|(>[^>]*)$", "", "all")>