I tested this and it worked fine but made one change:
You have a TR with " inside the <>.
Also to get it to work without the datasource I used CFSET to establish
the
ListElement.strSelect =
'D:\test\'dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5,D:\test\dir6'
Such as:
<CFSET ListElement.strSelect =
"'D:\test\'dir1,D:\test\dir2,D:\test\dir3,D:\test\dir4,D:\test\dir5,D:\test\dir6'">
Are you having some other functionality in here that was not posted
which could resolut in the error?
>>> [EMAIL PROTECTED] 11/04/02 01:31PM >>>
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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
