Version 1:
> list = simg1,limg1,simg2,limg2...
<cfset list="">
<cfloop query="MakeList">
<cfset list = listAppend(list, SmallImage)>
<cfset list = listAppend(list, LargeImage)>
</cfloop>
Or version 2:
> list= simg1,simg2,limg1,limg2...
<CFSET LImage = valuelist(MakeList.LargeImage)>
<CFSET SImage = valuelist(MakeList.SmallImage)>
<CFSET ImageList = ListAppend( SImage, LImage )>
> -----Original Message-----
> From: Jeffrey V. Lemire [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 04, 2000 2:06 PM
> To: CFTALK
> Subject: Creating A List
>
>
> Hello Folks!
>
> I was wondering if someone could point me in the right direction.
> Im trying
> to create a list that is derived from two columns. For example:
>
> <cfquery name="MakeList" datasource="Cars">
> SELECT LargeImage,SmallImage
> FROM CoolCars
> WHERE CarID=#form.CarID#
> </cfquery>
>
> <CFSET LImage = valuelist(MakeList.LargeImage)>
> <CFSET SImage = valuelist(MakeList.SmallImage)>
>
> <CFSET ImageList = valuelist((SmallImage) & (LargeImage))>
>
> I know that the <cfset imagelist> section is wrong
> because....well...it does
> not work. Am I heading in the right direction or is there a
> better way to do
> this.
>
> TIA
>
> Jeffrey V. Lemire
>
> ------------------------------------------------------------------
> ----------
> --
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
> 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.mail-archive.com/cf-talk@houseoffusion.com/
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.
