I can get it to output properly using that code but when I loop through it (i require <input boxes in front of each directory) and ctry to output the results in 4 columns everything after the 8th entry is getting blown away and I don't know why.
On Mon, 04 Nov 2002 14:03:08 -0500, Randell B Adkins wrote: > When you get your data from the query, to create the LIST > simply do the following: > > <cfset myList = ''> > <cfoutput query="ListElement"> > <cfset myList = ListAppend(mylist,strSelect)> > </cfoutput> > > That should generate a proper LIST to you to use > in the CFLOOP function. > >>> [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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
