Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cfdeveloper
  • Order by date
  1. cfdeveloper

    query that returns the top 5 records (most frequently used)kindly read

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

    query that returns the top 5 records (most frequently used)kindly read

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

    query that returns the top 5 records (most frequently used)kindly read

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

    query that returns the top 5 records (most frequently used)kindly read

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

    embedding an image in cfmail

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

    embedding an image in cfmail

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

    embedding an image in cfmail

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

    format y-axis in cfchart

    ...AS dtlogged, dt.jobcount, j.jobPriority, j.jobNumber FROM ( SELECT CAST(CONVERT(varchar(15), logdatetime, 106) AS datetime) AS dtlogged, COUNT(*) AS jobcount FROM job WHERE logdatetime >= '01/02/2005 00:00:00' AND logdatetime <= '02/02/2005 23:59:59' GROUP BY...
  9. cfdeveloper

    format y-axis in cfchart

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

    cfchart and cfchartdata question. Kindly help!

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

    cfchart and cfchartdata question. Kindly help!

    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)#"...
  12. cfdeveloper

    cfchart and cfchartdata question. Kindly help!

    ...logdatetime <= @x + '23:59:59' insert into #temp_report values(convert(varchar(15),@x,106), @count) select @x = dateadd(d, 1, @x) end select * from #temp_report drop table #temp_report set nocount off GO <!-- sp code ends here --> The above sp loops from the user selected start...
  13. cfdeveloper

    Problems Querying Text File Datasource Using ODBC/Coldfusion MX

    ...occurred in E:\inetpub\wwwroot\artman_dev\Coldfusion\admin.cfm: line 21 19 : <cfquery name="getAccount" datasource="articleManager"> 20 : select * from account.dat.cgi 21 : where LCASE(USERLOGINID) = '<cfoutput>#LCASE(session.user.username)#</cfoutput>' 22 : </cfquery> The first...
  14. cfdeveloper

    Pattern matching in ASP - Kindly help

    Cheers vbkris. Thanks for your help Best regards
  15. cfdeveloper

    Pattern matching in ASP - Kindly help

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

    Pattern matching in ASP - Kindly help

    ...var timestampRegexp = "\d{1,2}/\d{1,2}/\d{4}\s+\d{1,2}:\d{1,2}:\d{1,2}"; var stTmp = StructNew(); var stReturn = StructNew(); // remove *** if necessary header = REReplace(header,"(^\s*{3}\s*|\s*{3}\s*$)","","all"); // find timestamp stTmp = REFind(timestampRegexp,header,1,true)...
  17. cfdeveloper

    Pattern matching in ASP - Kindly help

    I really need someone to help me here, conehead, if I don't get this done by today, I won't be getting any salary :)
  18. cfdeveloper

    Pattern matching in ASP - Kindly help

    VB Script ASP
  19. cfdeveloper

    Pattern matching in ASP - Kindly help

    ...var timestampRegexp = "\d{1,2}/\d{1,2}/\d{4}\s+\d{1,2}:\d{1,2}:\d{1,2}"; var stTmp = StructNew(); var stReturn = StructNew(); // remove *** if necessary header = REReplace(header,"(^\s*{3}\s*|\s*{3}\s*$)","","all"); // find timestamp stTmp =...
  20. cfdeveloper

    regular expressions help - re-writing Coldfusion Code to ASP

    ...var timestampRegexp = "\d{1,2}/\d{1,2}/\d{4}\s+\d{1,2}:\d{1,2}:\d{1,2}"; var stTmp = StructNew(); var stReturn = StructNew(); // remove *** if necessary header = REReplace(header,"(^\s*{3}\s*|\s*{3}\s*$)","","all"); // find timestamp stTmp =...

Part and Inventory Search

Back
Top