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

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...

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...

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...

I'm trying to conditionally format a field as bolded or not bolded based on the value of the field. The field is a string and this is the code I am using. "Net Proceeds" I am entering it but clicking the formula button across from the Style field. My intention is that if the value of the...

I am building a website that will include patient names and appointment times on the database. The application will only supply information to the specific patient. What actions/procedures can I take to ensure the security of this data? That it will not be intercepted during transmission...

I am building a website that will include patient names and appointment times on the database. The application will only supply information to the specific patient. What actions/procedures can I take to ensure the security of this data. That it will not be intercepted during transmission...

What's wrong with my code here. I am trying to output two different records dynamically. I have two records in a table. I want to use the same query with a dynamic where parameter that is cfset before each query. If my first record has a value of ONE, and my second record has a value of TWO...

In my home network I have a cable modem, a dlink wireless router/hub, a linksys router/hub and a linksys print server/hub. They are attached as follows: cable modem >> wireless router >> linksys printer server hub >> computer1 (XP) cable modem >> wireless router >> computer2 (win98) cable...

I'm writing a check report that will print computer checks. There are three parts to the check page that prints on a letter sized paper. 1st is the actual check. The next two sections are identical. They are the remittance part that details the invoices that are getting paid. Here is my...

I am getting the following error Method 'Worksheets' of object '_Global' failed when I step through my macro in Excel. On my local desktop I have no issues. But when I post this Excel file on my website, I get the error. So the macro is running erratically. Please go to...

I am getting the following error Method 'Worksheets' of object '_Global' failed when I step through my macro in Excel. On my local desktop I have no issues. But when I post this Excel file on my website, I get the error. So the macro is running erratically. Please go to...

I need to scan a carriage return. I do not want to code my scanner to do the carriage return automatically after the scan. The reason being that sometimes I need to scan one, two or maybe three barcodes before I need the carriage return. I want the user to have a print out of the carriage...

I am scanning a barcode into a field. Once the barcode is scanned, the screen displays the item's description. The user next needs to hit the enter key to submit the scan. I am looking for a way to use the scan gun to enter the carriage return, so that the user does not have to change...

I have a cfloop using a query and within it I have a cfif statement. If the condition is not met, I want to ignore the code, hit the </cfloop> end tag and look at the next record. Before I hit the </cfloop> end tag, I set a value in the current record and all related records (all with the same...