calling for information from 2 tables. I want to find out which row is even
and which is odd from one of them. I'm using. <cfif error_table.CurrentRow
MOD 2 IS 1> but this throws an error saying that currentrow is undefined.
Yet if I take out the error_table. part it works, without ever finding the
odd and even rows. I'm trying to use this to format the bgcolor and txtcolor
of a <tr> & <td>. The code is below. How do I fix this error.
<cfquery datasource="#mydbname#" name="display">
SELECT *
FROM error_table, importance
</cfquery>
<cfoutput query="display">
<cfif error_table.CurrentRow MOD 2 IS 1>
<cfset bgcolor="white">
<cfset txtcolor="black">
<cfelse>
<cfset bgcolor="black">
<cfset txtcolor="white">
</cfif>
<tr bgcolor="#bgcolor#" style="text-color:#txtcolor#;">
Thanks for the help
Phil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
