Okay,
I have a 7 layer error code. I want to do a query to display only the one
that is not 0. e1-e7. Six will be 0 and one will be occupied by a 1. This
is how it will be displayed: <td align="center">#ecode# </td>. What
would the code for all of th <cfif> tags would be. Here is the query:
<cfquery name="ctrdetail"
datasource="0424_SQL_TSG_DISPOS"
dbtype="ODBC"
username=""
password="">
SELECT RRDD, SLIC, SONum, ModNum, DateArriv, AttnTo, Creator, E1, E2,
E3, E4, E5, E6, E7
FROM exception
where rrdd ='#url.dis#' and slic = '#url.slic#'
order by datearriv
</cfquery>
Joshua Tipton
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
