I want a search to return results formatted to show the first 100 characters of field 'Body.' I can use the LEN function, but I fear that in dealing with a field with contents of thousands upon thousands of characters, this process would slow down the site's performance. Is there any other way to limit the data shown to only 100 characters?
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!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Show only 100 characters of field
- Thread starter rmz8
- Start date
- Thread starter
- #3
- Thread starter
- #4
What if I have a collection of 30 records, each of which I want to create a different summary for using the contents of 'Body'? Here is what I have:
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">SELECT ID, Headline, Body FROM Content_Database WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%' ORDER BY Headline ASC</CFQUERY>
<CFSET Summary = LEFT(Search.Body, 255)>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE><CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#Summary#</i>
<br><br>"></CFTABLE>
When I refer to 'Summary' above, it shows the same one for all of the results, since CFSET only built one summary, from the first record returned by the QUERY. How can I have it build seperate summaries and then refer to it in the results? [sig]<p>Ryan ;-]<br>[/sig]
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">SELECT ID, Headline, Body FROM Content_Database WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%' ORDER BY Headline ASC</CFQUERY>
<CFSET Summary = LEFT(Search.Body, 255)>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE><CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#Summary#</i>
<br><br>"></CFTABLE>
When I refer to 'Summary' above, it shows the same one for all of the results, since CFSET only built one summary, from the first record returned by the QUERY. How can I have it build seperate summaries and then refer to it in the results? [sig]<p>Ryan ;-]<br>[/sig]
Hi Ryan,
I'm still a CF Newbie, but try this:
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">
SELECT ID, Headline, Body
FROM Content_Database
WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%'
ORDER BY Headline ASC
</CFQUERY>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE>
<CFSET Summary = #LEFT(Search.Body, 255)#>
<CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#Summary#</i><br><br>"></CFTABLE>
----------------
or
----------------
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">
SELECT ID, Headline, Body
FROM Content_Database
WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%'
ORDER BY Headline ASC
</CFQUERY>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE>
<CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#LEFT(Search.Body, 255)#</i><br><br>"></CFTABLE>
But I think this way might take up more of the server resources.
Hope this was of some help,
NeoTurtle [sig][/sig]
I'm still a CF Newbie, but try this:
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">
SELECT ID, Headline, Body
FROM Content_Database
WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%'
ORDER BY Headline ASC
</CFQUERY>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE>
<CFSET Summary = #LEFT(Search.Body, 255)#>
<CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#Summary#</i><br><br>"></CFTABLE>
----------------
or
----------------
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">
SELECT ID, Headline, Body
FROM Content_Database
WHERE Category1 LIKE '%#URL.Category1#%' AND Category2 LIKE '%#URL.Category2#%'
ORDER BY Headline ASC
</CFQUERY>
<CFTABLE QUERY="Search" COLHEADERS HTMLTABLE>
<CFCOL TEXT="<a href='display_article.cfm?ID=#Search.ID#&Client_Name=#Design.Client_Name#'><b>#Search.Headline#</b></a><br><i>#LEFT(Search.Body, 255)#</i><br><br>"></CFTABLE>
But I think this way might take up more of the server resources.
Hope this was of some help,
NeoTurtle [sig][/sig]
- Status