Search results for query: *

Hello everybody, I really need someone to help me here. I'm developing a report and stats front-end interface for a job logging system in ColdFusion and SQL Server 2000. I need your help in writing a sql query. I want to get the top 5 issues used when logging a job for a customer from the...

Hello everybody, Is it possible to do this in ColdFusion 6.1? I ask this because the email that is sent via cfmail has a div tag in it with the style background-image attribute and when I try to open the email in ms outlook, I get prompted to enter the username and password. I have XP...

The values displayed on the y-axis are are mix of float and int. The chart displays int values on the y-axis if I use only one cfchartseries tag. The code below calculates the value for the gridlines and scaleto attributes. <cfset...

Hello everybody, I really need someone to help me here. I'm new to charting. I'm developing a graphical interface to report the no of jobs logged in a period. The x axis displays the period (days) and the y-axis displays the number of jobs logged in a given day. The data is pulled from the jobs...

Hi, Just wondering if anyone has experience with using the Microsoft Text ODBC Driver with Coldfusion? The problem I am getting is that the datasource I have to work with is named "account.dat.cgi". I have set up a System DSN on the server for the folder containing this file, and...

I'm really hoping someone could help me. I am a ColdFusion developer. I'm trying to re-write some CF code in ASP, and am stuck. To give you an overview, I'm working on a job logging system. The customer calls the helps desk to log a job, the help desk creates a new job, adds the comments to the...

I'm really hoping someone could help me. I am a ColdFusion coder and can code in ASP (not that much). I'm trying to re-write some CF code in ASP, and am stuck. I have a regular expression that does a patter matching that I would to re-write in ASP To give you a brief history, I'm working on a...

Hello everybody, I was wondering if someone could help me. I am trying to get the distinct record from a select statment. Here is the code. <cfquery name="getEmployeeDetails" datasource="db"> select distinct reference, uniqueID, firstname, lastname FROM employee WHERE reference = 'cfcoder'...

Hello everybody, I'm hoping someone can help me. I am working on this exception handling code. I have written a custom error handler that displays a custom error message when a coldfusion error occurs and sends an email to the administrator. I want to append the complete error block to the...

Hi Guys, I'm hoping someone can help me. I've tried everything but can't quiet nail this problem. I have this page that has a hyper-link. Clicking on the hyper-link opens up a pop-up window. The url looks something like this...

Hello, I'm assuming this one should be an easy one. I'm running an insert query and one of the fields is date/time. When I DO NOT send a value to it, I want to insert is as <NULL>, but instead, it's going in as "1/1/1900". How should I do my query where I can send a NULL Value? Thanks...

Hi Guys, I'm trying to word wrap some text. I don't know if there is a client side tag that does this for you. I'm just displaying comments/text on the browser window. I have a table. <table> <tr> <td colspan="6"> Comments </td> </tr> <tr> <td colspan="6"> #COMMENTS#...

Hello everybody, I'm working on this script to get the date difference between two dates in minutes. After doing that; I want to then deduct/subtract the value returned by the datediff function from another date value. Here is what I'm trying to do: Reading the two date values from a...

Hi there, I'm working on a undelivered email tracking application. I have CFMX installed on my pc. I want to check if there are any undelivered emails in the "Undelivr" folder. If true and provided the last modified date of the file in the undeliverable directory is older than 1 day, I want to...

Hello everybody, I've written this code that exports the search results to a csv file. Here is the code: <CFFILE ACTION="Write" FILE="searchResults.csv" ADDNEWLINE="Yes" OUTPUT="Date, Ref, Name #Chr(10)##Chr(10)#"> <CFSET QUOTE = Chr(127)> <cfoutput...

Hi Guys, I'm passing a url variable a string/text that has a apostrphee in it. Ex: mytext = It's a test I'm escaping it like this: window.location.href = "somepage.cfm?txt="+escape(mytext); I'm passing this url varialbe, url.txt to the select statement, I get an error: Incorrect...

Hello everybody, I want to re-arrange everything dumped out by cfdump and comma separate all the elements of the cfdump structure. <cfdump var="#url#"> I want to take the results returned by the above cfdump structure and comma separate each element. I want to insert all the comma separated...

Hello everybody, I was wondering if someone could help. I'm hopeless with string manipulation and am in right mess. There was someone helping me out but I've pissed him off and he doesn't want to help anymore. I'm working on a logging system for the help desk, the key to which is the log...

I'm hopeless with regular exprssions and was wondering if someone could help me in traslating the following: var Regexp = "(?m)^[ \t]*({3}[^\n]*?{3}|[^\n]*?\d{1,2}/\d{1,2}/\d{4}[ \t]+\d{1,2}:\d{1,2}:\d{1,2})[ \t]*$"; Best regards, cfcoder

I'm working on a logging system. The site search as you can imagine is very complicated and a lot depends on it. I have written a stored procedure for the search to make the search quicker with a lot of inner and outer joins (the usual). The seach is very quick most of the times, but if the...