Search results for query: *

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")>

Option 2 is beautiful. Can you help me out with one more thing. I'm a real uber novice with regular expressions. Your option2 example returned angle brackets. I do not need the angle brackets. I saw this article that talked about excluding but I could not get it right...

I am trying to extract an email address from the following string: "Joe Smith" <joesmith@website.ca> I am trying to use the FIND function in coldfusion to find the first angle bracket. Here is my code: <cfset startpos = #find("<",fromemailstring)#> <cfset endpos =...

Hi, I've been able to successfully use the CFPOP feature of coldfusion. I have set generateUniqueFilenames = "yes". I do get unique filenames when retrieving emails with attachments using the same filename. However, when using the queryname.attachments or queryname.attachmentfiles, they do...

It's doesn't seem to work on a div tag. It does work in a table cell though. I need this to work in a div tag.

I'm not dealing with font size. I'm dealing with Style (ie bolding).