Hi gang,
I have a page that pulls out a list on stories, then loops over them,
setting a variable for a font colour for each one, and selecting the authors
name for each one from another table.
It all works, but in IE5.5 and IE6, the page seems to get stuck in a loop,
and sometimes throws and error saying "Processing aborted". This is not an
error I have seen before. The code is below, minus the hmtl around it, which
I have checked and is alright.
Any ideas??
<cfquery name="getstories" datasource="#Request.App.dsn#">
SELECT storyID, author, agezone, title
FROM tbl_stories
ORDER BY title ASC;
</cfquery>
<cfoutput query="getstories">
<cfswitch expression="#getstories.agezone#">
<cfcase value="1">
<cfset fontcol = "#Request.App.zone1#">
</cfcase>
<cfcase value="2">
<cfset fontcol = "#Request.App.zone2#">
</cfcase>
<cfcase value="3">
<cfset fontcol = "#Request.App.zone3#">
</cfcase>
<cfcase value="4">
<cfset fontcol = "#Request.App.zone4#">
</cfcase>
<cfcase value="5">
<cfset fontcol = "#Request.App.zone5#">
</cfcase>
</cfswitch>
<style type="text/css">
<!--
szbiglink {font-family: Arial, Helvetica, sans-serif; font-size: 12pt;
font-weight: bold; color: #fontcol#; text-decoration: none}
-->
</style>
<cfquery name="getauthor" datasource="#Request.App.dsn#">
SELECT *
FROM tbl_authors
WHERE authorID = #getstories.author#
</cfquery>
<tr>
<td colspan="2"><font color="#fontcol#" face="Arial,Helvetica,sans-serif"
size="2"><a href="preview.cfm?e=#storyID#" style="font-family: Arial,
Helvetica, sans-serif; font-size: 12pt; font-weight: bold; color: #fontcol#;
text-decoration: none"><b>#title#</b></a> <a
href="authordetail.cfm?e=#author#" style="font-family: Arial, Helvetica,
sans-serif; font-size: 10pt; font-weight: normal; color: #fontcol#;
text-decoration: none">by #getauthor.author#
#getauthor.surname#</a></font></td>
</tr>
</cfoutput>
Cheers
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists