Hi,
I'm looping through a query and displaying the results on my page. The problem I'm
having is it craps out on the 3rd line when I try to display the results. Why?
I check the field in the database and it looks fine.
<cfquery name="ListElement" datasource="database" dbtype="ODBC">
SELECT *
FROM profiles
WHERE Username = '#auth#'
ORDER BY strSelect
</cfquery>
ListElement.strSelect =
'D:\test\'dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5,D:\test\dir6'
<cfform action="action.cfm" method="post">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
<tr">
<td height="2"></td>
</tr>
<cfset columnmode = "1">
<cfloop list="#ListElement.strSelect#" index="i">
<td class="wdirlinks">
<table cellpadding="0" cellspacing="0" border="0">
<tr valign="middle"><td class="wdirlinks"
valign="top"><input type="checkbox" name="select"
value="<cfoutput>#i#</cfoutput>"></td><td class="wdirlinks"><cfoutput>#i#
</cfoutput></td></tr>
</table>
</td>
<cfif columnmode MOD 4 EQ 0>
</tr><tr>
</cfif>
<cfset columnmode = columnmode + 1>
</cfloop>
</tr>
</table>
</cfform>
---------------------------------------------------
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---------------------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
