"ListElement" isn't a list. It's a query. Did you want <cfloop list="#listElement.ColumnList#" index="i"> ?
> -----Original Message----- > From: FlashGuy [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 25, 2002 9:27 AM > To: CF-Talk > Subject: RE: Display 3 column text *FOLLOWUP* > > > OK...I added your code and now I get an error. Why? > > Error Diagnostic Information > > LIST > > The value cannot be converted to a string because it is not a > simple value. Simple values are booleans, numbers, strings > and date-time values. > > The error occurred while processing an element with a general > identifier of (CFLOOP) > > > Here is my code with yours included: > > <cfquery name="ListElement" datasource="user-profiles" dbtype="ODBC"> > SELECT strUsername,strGroup,strSelect > FROM profiles > WHERE strUsername = '#auth#' > </cfquery> > > <table width="100%" cellpadding="6" cellspacing="0" > border="0" align="center"> > <tr class="wdirlinks"> > <td colspan="2"> > <cfif COOKIE.DisplaySelect GT 0> > <cfset j = "1"> > <cfloop list="#listElement#" index="i"> > <cfoutput>#i#</cfoutput> > <cfif j MOD 3 EQ 0> > <tr> > </cfif> > <cfset j = j + 1> > </cfloop> > <cfelse> > <b>None Selected</b> > </cfif> > </td> > </tr> > </table> > > > > --------------------------------------------------- > Colonel Nathan R. Jessop > Commanding Officer > Marine Ground Forces > Guatanamo Bay, Cuba > --------------------------------------------------- > > > > ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
