Recent content by cfdeveloper

Rudy, the explaination given in this thread is right Regards cfcoder

>>i know they're related by Issueunique, but i'm not clear on which one is the primary and which one is the foreign The IssueUnique column is the primary key in job_issues table. The jobs table too has a column called IssueUnique which is a foreign key. When logging a new job for the customer...

Hello Travid and Rudy, and thanks for replying to my thread. Sorry for not getting back yesterday. Just got in to work. Rudy, hopefully this will make it clearer. I want the query to return the 5 most frequently used issues in a date range that customes have selected when logging jobs. I'm...

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

it is an intranet site only accessible to users within the organisation

but I get the prompt and my internet connection is behind the firewall. The project I'm working on is a intranet.

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

Hi again, I'm just so loosing my focus here. Not knowing how this things works is probably what's getting me all frustrated. Ok, here is what my query looks like <cfquery name="qBar" datasource="testDB"> SELECT CONVERT(varchar(15), dt.dtlogged, 106) AS dtlogged, dt.jobcount, j.jobPriority...

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

tried it already. Didn't work. when I output srcto outside the cfchart tag, the value is 88

Hi there, thanks a ton for replying to my query. I have done just what you asked me to. I'm having a problem with the values on the y-axis. <cfset scTo=evaluate(ArrayMax(ListToArray(valuelist(qJobsLogged.JOBCOUNT)))+1)> <cfchart show3d="yes" gridlines="#evaluate(scTo+1)#"...

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

Cheers vbkris. Thanks for your help Best regards

function GetCommentsWrapper(txt){ if(REFindNoCase("<(newLog|legacyLog)\b[^>]*>",txt)) return GetCommentsNew(txt); else return GetComments(txt); } I want to display everything between the opening <newLog> or <legacyLog> tag and the closing </newLog> or </legacyLog> tag. The...