Or, just loop over the list directly like:
<cfloop list="#qMyQuery.Column#" index="i">
<cfoutput>#Variables.i#</cfoutput>
</cfloop>
Nate Nielsen
BlurWeb Technologies
[EMAIL PROTECTED]
----- Original Message -----
From: Edward Chanter <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, March 27, 2000 10:29 AM
Subject: RE: Question - Multiple Records
> Try using a <cfloop> and the ListGetAt function embedded within it.......
try
> the following:
>
> <cfset Length = ListLen(COLUMN_NAME)>
> <cfloop Index="element" FROM=1 TO=#Length#>
> <cfset current = ListGetAt(COLUMN_NAME, element)>
> #current#<br>
> </cfloop>
>
> If you've got the books by Ben Forta you'll find excellent examples in
> that........
>
> HtH
>
> -= Edward
>
> :> -----Original Message-----
> :> From: Greg Edmonds [mailto:[EMAIL PROTECTED]]
> :> Sent: Monday, March 27, 2000 4:35 PM
> :> To: [EMAIL PROTECTED]
> :> Subject: Question - Multiple Records
> :>
> :>
> :> I'm inserting several records into one field of an Access dB. The
field
> :> looks like this: record1,record2,record3... etc. The problem I am
having
> :> is displaying these records. If a person chooses several records they
> :> string across the page. Is there any way to put a <br> in between
these
> :> records? I have tried to put a break after the #fieldname#, but it
thinks
> :> this record is one long sentence. I know this is probably a real
stupid
> :> question, but it has me baffled right now.
> :>
> :> Thanks,
> :> Greg
> :>
> :> --------------------------------------------------------------------
> :> ----------
> :> Archives: http://www.eGroups.com/list/cf-talk
> :> To Unsubscribe visit
> :> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_t
> alk or send a message to [EMAIL PROTECTED] with
'unsubscribe' in
> the body.
>
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
