?
Solved

export query result to excel spreadsheet

Posted on 2014-04-24
5
Medium Priority
?
362 Views
Last Modified: 2014-04-25
Hi,

Please tell me how can I have the query result sent to an excel spreadsheet.

so, when the user click on the button the data should go to the spreadsheet.

Thanks,
Lulu

button


      
<CFIF isDefined("QSearchResult") and #QSearchResult.RecordCount# gt 0>

<cfparam name="url.page" default="1">
<cfset page_links_shown = 5>
<cfset records_per_page = 10>

<cfset total_pages = ceiling(QSearchResult.RecordCount / records_per_page)>

<cfif val(url.page) lt 1>
  <cfset url.page = 1>
<cfelseif val(url.page) gt total_pages>
  <cfset url.page = total_pages>
</cfif>
<cfset start_record = ((url.page - 1) * records_per_page ) + 1>

<table style="width:100%;border: solid 1px #dddddd;" id="ResultListTbl">
<tr style="background-color:#d0d2d3;font-weight:bold;">
 <th style="width:100px;padding-left:5px;">Issue ID <img id="SortByIssueID" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by issue ID" onclick="FlipImage(1);" /></th>
 <th style="width:150px;">Ticket# <img id="SortByTicketNumber" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by ticket number" onclick="FlipImage(2);" /></th>
 <th style="width:210px;">Category <img id="SortByCategory" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by category" onclick="FlipImage(3);" /></th>
 <th style="width:350px;">Title <img id="SortByTitle" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by title" onclick="FlipImage(4);" /></th>
 <th style="width:80px;">Status <img id="SortByStatus" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by status" onclick="FlipImage(5);" /></th>
 <th style="width:110px;">Date <img id="SortByDate" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by date" onclick="FlipImage(6);" /></th>
  <th style="width:110px;">&nbsp;</th>
</tr>
<cfset previousParentIssueID = QSearchResult.ParentIssueID> 
<cfoutput query="QSearchResult" startrow="#start_record#" maxrows="#records_per_page#">

 <cfif val(QSearchResult.ParentIssueID)> 
 <!-- //Child Row -->
 <tr class="bg2row">
   <td style="padding-left:20px;">#QSearchResult.ParentIssueID#(#QSearchResult.issueID#)</td>
 <td>#QSearchResult.ticketNumber# <cfif #QSearchResult.TicketNumberTxt# neq ""> - #QSearchResult.TicketNumberTxt#</cfif></td>
 <td>#QSearchResult.Category#</td>
 <td>#QSearchResult.TitleOfIssue#</td>
 <td>#QSearchResult.Status#</td>
  <td>#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
    <td><a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"><img src="images/edit.png" alt="Edit Log" /></a>
  <!---  <a href="ViewLogEntry.cfm?filter=1&TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"> --->
    <img src="images/view.png" alt="View Log" onClick="ViewDialog(900,600,#QSearchResult.CategoryTypeID#,#QSearchResult.issueID#);" />
   <!--- </a> --->

    </td>
    </tr>  
 <cfelse>
 <tr class="bgrow">
	 <td style="font-weight:bold;padding-left:5px;">#QSearchResult.issueID#</td>
	 <td style="font-weight:bold;">#QSearchResult.TicketNumber# <cfif #QSearchResult.TicketNumberTxt# neq ""> - #QSearchResult.TicketNumberTxt#</cfif></td>
	 <td style="font-weight:bold;">#QSearchResult.Category#</td>
	 <td style="font-weight:bold;">#QSearchResult.TitleOfIssue#</td>
	 <td style="font-weight:bold;">#QSearchResult.Status#</td>
	  <td style="font-weight:bold;">#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
	  <td style="color:dark blue;">
      
      <a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"><img src="images/edit.png" alt="Edit Log" /></a>
     <!--- <a href="ViewLogEntry.cfm?filter=1&TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"> --->
	  <img src="images/view.png" alt="View Log" onClick="ViewDialog(900,600,#QSearchResult.CategoryTypeID#,#QSearchResult.issueID#);" />
	  <!--- </a> --->
       <cfif not val(previousParentIssueID)>
      <a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&IDP=#QSearchResult.issueID#"><img src="images/add.png" alt="Add Log" /></a>
      </cfif>
	  </td>
  </tr>
</cfif>
</cfoutput>

</table> 

Open in new window

0
Comment
Question by:lulu50
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 22

Expert Comment

by:plusone3055
ID: 40021213
ive asked the very same question before Back when I was starting out with Coldfusion

here is the link to my question and the answer :)

http://www.experts-exchange.com/Programming/Languages/Scripting/Cold_Fusion_Markup_Language/Q_24450995.html
0
 
LVL 16

Accepted Solution

by:
Gurpreet Singh Randhawa earned 2000 total points
ID: 40021867
For this purpose, i prefer using the following UDF

http://cflib.org/udf/Query2Excel

Which fits in your code like this:

<cfscript>
function Query2Excel(query) {
    var InputColumnList = query.columnList;
    var Headers = query.columnList;

    var AlternateColor = "FFFFFF";
    var header = "";
    var headerLen = 0;
    var col = "";
    var colValue = "";
    var colLen = 0;
    var i = 1;
    var j = 1;
    var k = 1;
    
    var HTMLData = "";
    
    if (arrayLen(arguments) gte 2) {
        Headers = arguments[2];
    }
    if (arrayLen(arguments) gte 3) {
        InputColumnList = arguments[3];
    }

    if (arrayLen(arguments) gte 4) {
        AlternateColor = arguments[4];
    }
    if (listLen(InputColumnList) neq listLen(Headers)) {
        return "Input Column list and Header list are not of equal length";
    }
    
    HTMLData = HTMLData & "<table border=1><tr bgcolor=""C0C0C0"">";
    for (i=1;i lte ListLen(Headers);i=i+1){
        header=listGetAt(Headers,i);
        headerLen=Len(header)*10;
        HTMLData = HTMLData & "<th width=""#headerLen#""><b>#header#</b></th>";
    }
    HTMLData = HTMLData & "</tr>";
    for (j=1;j lte query.recordcount;j=j+1){
        if (j mod 2) {
            HTMLData = HTMLData & "<tr bgcolor=""FFFFFF"">";
        } else {
            HTMLData = HTMLData & "<tr bgcolor=""#alternatecolor#"">";
        }
        for (k=1;k lte ListLen(InputColumnList);k=k+1) {
            col=ListGetAt(InputColumnList,k);
            colValue=query[trim(col)][j];
            colLength=Len(colValue)*10;
            if (NOT Len(colValue)) {
                colValue="&nbsp;";
            } 
            if (isNumeric(colValue) and Len(colValue) gt 10) {
                colValue="'#colValue#";
            } 
            HTMLData = HTMLData & "<td width=""#colLength#"">#colValue#</td>";
        }
    HTMLData = HTMLData & "</tr>";
    }
    HTMLData = HTMLData & "</table>";
    
    return HTMLData;
}
</cfscript>
<cfif isDefined('form.excel')>
	<cfset getquery = Query2Excel(yourquery)>
    <cfdump var="#getquery#">
</cfif>
<form>
<input type="submit" name="excel" value="Export">
</form>
<CFIF isDefined("QSearchResult") and #QSearchResult.RecordCount# gt 0>
<cfparam name="url.page" default="1">
<cfset page_links_shown = 5>
<cfset records_per_page = 10>
<cfset total_pages = ceiling(QSearchResult.RecordCount / records_per_page)>
<cfif val(url.page) lt 1>
  <cfset url.page = 1>
  <cfelseif val(url.page) gt total_pages>
  <cfset url.page = total_pages>
</cfif>
<cfset start_record = ((url.page - 1) * records_per_page ) + 1>
<table style="width:100%;border: solid 1px #dddddd;" id="ResultListTbl">
  <tr style="background-color:#d0d2d3;font-weight:bold;">
    <th style="width:100px;padding-left:5px;">Issue ID <img id="SortByIssueID" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by issue ID" onclick="FlipImage(1);" /></th>
    <th style="width:150px;">Ticket# <img id="SortByTicketNumber" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by ticket number" onclick="FlipImage(2);" /></th>
    <th style="width:210px;">Category <img id="SortByCategory" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by category" onclick="FlipImage(3);" /></th>
    <th style="width:350px;">Title <img id="SortByTitle" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by title" onclick="FlipImage(4);" /></th>
    <th style="width:80px;">Status <img id="SortByStatus" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by status" onclick="FlipImage(5);" /></th>
    <th style="width:110px;">Date <img id="SortByDate" style="cursor:hand;" src="images/ArrowDowndefault.png" alt="Sort by date" onclick="FlipImage(6);" /></th>
    <th style="width:110px;">&nbsp;</th>
  </tr>
  <cfset previousParentIssueID = QSearchResult.ParentIssueID>
  <cfoutput query="QSearchResult" startrow="#start_record#" maxrows="#records_per_page#">
    <cfif val(QSearchResult.ParentIssueID)>
      <!-- //Child Row -->
      <tr class="bg2row">
        <td style="padding-left:20px;">#QSearchResult.ParentIssueID#(#QSearchResult.issueID#)</td>
        <td>#QSearchResult.ticketNumber#
          <cfif #QSearchResult.TicketNumberTxt# neq "">
            - #QSearchResult.TicketNumberTxt#
          </cfif></td>
        <td>#QSearchResult.Category#</td>
        <td>#QSearchResult.TitleOfIssue#</td>
        <td>#QSearchResult.Status#</td>
        <td>#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
        <td><a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"><img src="images/edit.png" alt="Edit Log" /></a> 
          <img src="images/view.png" alt="View Log" onClick="ViewDialog(900,600,#QSearchResult.CategoryTypeID#,#QSearchResult.issueID#);" /> 
          </td>
      </tr>
      <cfelse>
      <tr class="bgrow">
        <td style="font-weight:bold;padding-left:5px;">#QSearchResult.issueID#</td>
        <td style="font-weight:bold;">#QSearchResult.TicketNumber#
          <cfif #QSearchResult.TicketNumberTxt# neq "">
            - #QSearchResult.TicketNumberTxt#
          </cfif></td>
        <td style="font-weight:bold;">#QSearchResult.Category#</td>
        <td style="font-weight:bold;">#QSearchResult.TitleOfIssue#</td>
        <td style="font-weight:bold;">#QSearchResult.Status#</td>
        <td style="font-weight:bold;">#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
        <td style="color:dark blue;"><a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&ID=#QSearchResult.issueID#"><img src="images/edit.png" alt="Edit Log" /></a> 
          <img src="images/view.png" alt="View Log" onClick="ViewDialog(900,600,#QSearchResult.CategoryTypeID#,#QSearchResult.issueID#);" /> 
          <cfif not val(previousParentIssueID)>
            <a href="LogEntry.cfm?TechType=#QSearchResult.CategoryTypeID#&IDP=#QSearchResult.issueID#"><img src="images/add.png" alt="Add Log" /></a>
          </cfif></td>
      </tr>
    </cfif>
  </cfoutput>
</table>

Open in new window



above code can be placed in application.cfc and be reusable whereever required
Another possible way is to use the cfspreadsheet tag if you are on coldfusion 9+

Sample for this:


http://www.raymondcamden.com/index.cfm/2011/6/1/ColdFusion-Sample--Create-an-Excel-File

also you should check the question by the above expert, that is also a solution.

So there are many solutions to the one you have, you can even use custom tags for this..
0
 

Author Comment

by:lulu50
ID: 40022679
hmm,

I am not sure what I'm doing wrong, the data is not getting exported to excel.

this is my all my code on that page.

data

 <cfquery name = "QSearchResultCriteria"  datasource='#strDSN#' username='#strUID#' password='#strPWD#' result="rs">
  SELECT distinct  L.IssueID
		 , L.ParentIssueID
   FROM LogEntry L
      LEFT JOIN IssueStatus I on I.StatusID = L.StatusID
      LEFT JOIN CategoryType C on C.CategoryTypeID = L.CategoryTypeID
      LEFT JOIN TicketNumber T on T.TicketNumberID = L.TicketNumberID
      LEFT JOIN SelectedDepartment SD on SD.IssueID = L.IssueID 
      LEFT JOIN DepartmentImpacted DI on DI.DepartmentImpactedID = SD.DepartmentImpactedID 
   where 1 = 1
   
    <CFIF (IsDefined("Cookie.CookieDateFrom") && #Cookie.CookieDateFrom# neq "" )  && (IsDefined("Cookie.CookieGetDateTo") && #Cookie.CookieGetDateTo# neq "" )   >
    	AND (L.DateIdentified >= '#Trim(DateFormat(Cookie.CookieDateFrom, "mm/dd/yyyy"))#' and L.DateIdentified <= '#Trim(DateFormat(Cookie.CookieGetDateTo, "mm/dd/yyyy"))#')
        

	</CFIF>
    
    <CFIF IsDefined("Cookie.CookieStatus") && #Trim(Cookie.CookieStatus)# neq "1">
       AND (L.StatusID = #Trim(Cookie.CookieStatus)#)
	</CFIF>

   <!---- add all your where clause filters here below ---->
   <cfif not IsDefined("url.ID") && (IsDefined("Cookie.CookieSearchBy") && IsDefined("Cookie.CookieSearchField")) && (#Cookie.CookieSearchField# neq "" )>
   
	 <cfswitch expression="#Trim(Cookie.CookieSearchBy)#"> 
     <cfcase value="1"> 
  			and ((DI.Department like '%#Cookie.CookieSearchField#%')
            <cfif (not isdefined("url.ID") && isNumeric(#trim(Cookie.CookieSearchField)#))>
            or (L.IssueID = #trim(CookieSearchField)# or L.ParentIssueID = #trim(CookieSearchField)#) 
            </cfif>
           or (T.TicketNumber like '%#Cookie.CookieSearchField#%' or L.TicketNumberTxt like '%#Cookie.CookieSearchField#%')
            <cfif isNumeric(#trim(Cookie.CookieSearchField)#)>
            or (L.UserID LIKE '%#Cookie.CookieSearchField#%') 
            </cfif>
            or (L.TitleOfIssue LIKE '%#Cookie.CookieSearchField#%') 
            or (C.Category LIKE '#Cookie.CookieSearchField#%') )
    </cfcase> 
        <cfcase value="2"> 
  			AND (DI.Department like '%#Cookie.CookieSearchField#%')
    </cfcase> 
    <cfcase value="4"> 
            	AND (L.IssueID = #trim(CookieSearchField)# or L.ParentIssueID = #trim(CookieSearchField)#) 
    </cfcase> 
    <cfcase value="6"> 
      		AND (T.TicketNumber like '%#Cookie.CookieSearchField#%' or L.TicketNumberTxt like '%#Cookie.CookieSearchField#%')
    </cfcase> 
    <cfcase value="8"> 
    		AND (L.UserID LIKE '%#Cookie.CookieSearchField#%') 
    </cfcase> 
        <cfcase value="9"> 
    		AND (L.TitleOfIssue LIKE '%#Cookie.CookieSearchField#%') 
    </cfcase> 
        <cfcase value="10"> 
    		AND (C.Category LIKE '#Cookie.CookieSearchField#%') 
    </cfcase> 
	    <cfdefaultcase> 
	        
	    </cfdefaultcase> 
	</cfswitch> 
    <cfelseif IsDefined("url.ID") && #url.ID# neq "">
    		AND L.IssueID = #url.ID# or ParentIssueID = #url.ID#
   </cfif>

 </cfquery>

<!---<cfdump var="#QSearchResultCriteria#" /> 
<cfoutput>SQL: #rs.SQL#</cfoutput>  ---> 

<cfset FoundIssueIDs = "">

<cfloop index="kk" list="#valueList(QSearchResultCriteria.IssueID)#,#valueList(QSearchResultCriteria.ParentIssueID)#">
 <cfif listFind(FoundIssueIDs,kk) eq 0> 
     <cfset FoundIssueIDs = listAppend(FoundIssueIDs,kk)>
 </cfif> 
</cfloop> 


<!---<cfset FoundIssueIDs = valueList(QSearchResultCriteria.IssueID)>
<cfset FoundIssueIDs = listAppend(FoundIssueIDs, QSearchResultCriteria.ParentIssueID)> --->

 <cfquery name = "QSearchResult"  datasource='#strDSN#' username='#strUID#' password='#strPWD#' result="r">
  SELECT case when L.ParentIssueID is null then L.IssueId
         else L.ParentIssueID
		 end  as TopIssueID
		 , L.IssueID
		 , L.ParentIssueID
		 , T.TicketNumber
		 , L.TitleOfIssue
		 , I.Status
		 , L.DateCreated
         , L.CategoryTypeID
         , C.Category
         , L.TicketNumberTxt
   FROM LogEntry L
     LEFT JOIN IssueStatus I on I.StatusID = L.StatusID
     LEFT JOIN CategoryType C on C.CategoryTypeID = L.CategoryTypeID
     LEFT JOIN TicketNumber T on T.TicketNumberID = L.TicketNumberID
  <cfif len(FoundIssueIDs) eq 0 >
   where 1 = 2 
 <!---  <cfelseif IsDefined("url.ID") && #url.ID# neq "">
    where L.IssueID in  (#FoundIssueIDs#) and ParentIssueID = #url.ID# --->
  <cfelse>
   where L.IssueID in  (#FoundIssueIDs#)
  </cfif>

  
<cfif isdefined("Cookie.TempArrow")>
<cfswitch expression="#Trim(Cookie.TempArrow)#"> 
     <cfcase value="1"> 
  			 order by 1 asc, case when L.parentIssueID is null then 1 else 2 end 
    </cfcase> 
    <cfcase value="10"> 
  			 order by 1 desc, case when L.parentIssueID is null then 1 else 2 end 
    </cfcase> 
    <cfcase value="2"> 
      		 order by TicketNumber asc
    </cfcase> 
    <cfcase value="20"> 
      		order by TicketNumber desc
    </cfcase> 
    <cfcase value="3"> 
    		order by Category asc
    </cfcase> 
        <cfcase value="30"> 
    		order by Category desc
    </cfcase> 
        <cfcase value="4"> 
    		order by TitleOfIssue asc
    </cfcase> 
            <cfcase value="40"> 
    		order by TitleOfIssue desc
    </cfcase> 
           <cfcase value="5"> 
    		order by Status asc
    </cfcase> 
          <cfcase value="50"> 
    		order by Status desc
    </cfcase> 
     <cfcase value="6"> 
    		order by DateCreated asc
    </cfcase> 
        <cfcase value="60"> 
    		order by DateCreated desc
    </cfcase> 
	    <cfdefaultcase> 
	       order by 1 desc, case when L.parentIssueID is null then 1 else 2 end 
	    </cfdefaultcase> 
	</cfswitch> 
<cfelse>
  order by 1 desc, case when L.parentIssueID is null then 1 else 2 end 
</cfif>
</cfquery>

<!---<cfdump var="#QSearchResult#" /> 
<cfoutput>SQL: #r.SQL#</cfoutput>   --->



<cfscript>
function Query2Excel(query) {
    var InputColumnList = query.columnList;
    var Headers = query.columnList;

    var AlternateColor = "FFFFFF";
    var header = "";
    var headerLen = 0;
    var col = "";
    var colValue = "";
    var colLen = 0;
    var i = 1;
    var j = 1;
    var k = 1;
    
    var HTMLData = "";
    
    if (arrayLen(arguments) gte 2) {
        Headers = arguments[2];
    }
    if (arrayLen(arguments) gte 3) {
        InputColumnList = arguments[3];
    }

    if (arrayLen(arguments) gte 4) {
        AlternateColor = arguments[4];
    }
    if (listLen(InputColumnList) neq listLen(Headers)) {
        return "Input Column list and Header list are not of equal length";
    }
    
    HTMLData = HTMLData & "<table border=1><tr bgcolor=""C0C0C0"">";
    for (i=1;i lte ListLen(Headers);i=i+1){
        header=listGetAt(Headers,i);
        headerLen=Len(header)*10;
        HTMLData = HTMLData & "<th width=""#headerLen#""><b>#header#</b></th>";
    }
    HTMLData = HTMLData & "</tr>";
    for (j=1;j lte query.recordcount;j=j+1){
        if (j mod 2) {
            HTMLData = HTMLData & "<tr bgcolor=""FFFFFF"">";
        } else {
            HTMLData = HTMLData & "<tr bgcolor=""#alternatecolor#"">";
        }
        for (k=1;k lte ListLen(InputColumnList);k=k+1) {
            col=ListGetAt(InputColumnList,k);
            colValue=query[trim(col)][j];
            colLength=Len(colValue)*10;
            if (NOT Len(colValue)) {
                colValue="&nbsp;";
            } 
            if (isNumeric(colValue) and Len(colValue) gt 10) {
                colValue="'#colValue#";
            } 
            HTMLData = HTMLData & "<td width=""#colLength#"">#colValue#</td>";
        }
    HTMLData = HTMLData & "</tr>";
    }
    HTMLData = HTMLData & "</table>";
    
    return HTMLData;
}
</cfscript>
<cfif isDefined('form.excel')>
	<cfset getquery = Query2Excel(yourquery)>
    <cfdump var="#getquery#">
</cfif>

<CFIF isDefined("QSearchResult") and #QSearchResult.RecordCount# gt 0>

	<table style="width:100%;border: solid 1px #dddddd;" id="ResultListTbl">
  	<tr style="background-color:#d0d2d3;font-weight:bold;">
    <th style="width:100px;padding-left:5px;">Issue ID    </th>
    <th style="width:150px;">Ticket#    </th>
    <th style="width:210px;">Category</th>
    <th style="width:350px;">Title    </th>
    <th style="width:80px;">Status    </th>
    <th style="width:110px;">Date</th>
    </tr>
  	<cfset previousParentIssueID = QSearchResult.ParentIssueID>
 	 <cfoutput query="QSearchResult">
<cfif val(QSearchResult.ParentIssueID)>
      <!-- //Child Row -->
      <tr class="bg2row">
        <td style="padding-left:20px;">#QSearchResult.ParentIssueID#(#QSearchResult.issueID#)</td>
        <td>#QSearchResult.ticketNumber#
          <cfif #QSearchResult.TicketNumberTxt# neq "">
            - #QSearchResult.TicketNumberTxt#
          </cfif></td>
        <td>#QSearchResult.Category#</td>
        <td>#QSearchResult.TitleOfIssue#</td>
        <td>#QSearchResult.Status#</td>
        <td>#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
        </tr>
      <cfelse>
      <tr class="bgrow">
        <td style="font-weight:bold;padding-left:5px;">#QSearchResult.issueID#</td>
        <td style="font-weight:bold;">#QSearchResult.TicketNumber#
          <cfif #QSearchResult.TicketNumberTxt# neq "">
            - #QSearchResult.TicketNumberTxt#
          </cfif></td>
        <td style="font-weight:bold;">#QSearchResult.Category#</td>
        <td style="font-weight:bold;">#QSearchResult.TitleOfIssue#</td>
        <td style="font-weight:bold;">#QSearchResult.Status#</td>
        <td style="font-weight:bold;">#DateFormat(QSearchResult.DateCreated, "m/d/yyyy")#</td>
        </tr>
    </cfif>
  </cfoutput>
</table>
</CFIF>

Open in new window

0
 

Author Comment

by:lulu50
ID: 40022882
I got it thanks
0
 

Author Closing Comment

by:lulu50
ID: 40022885
Thanks,
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article  is about submitting  form through  ColdFusion.Ajax.submitForm to the action page and send a response back in JSON format which later can be decoded using ColdFusion.JSON.decode. By this way you can avoid the usual page refresh for subm…
Today, I was working on some optimization and spam-stopping techniques when I encountered Ben Nadel's post to reduce spam feature using Math (http://www.bennadel.com/blog/197-How-I-Stop-Spammers-On-My-ColdFusion-Blog.htm). While this method is not o…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question