Or QuotedValueList(MyQuery,Column)
if the columns are text based and not numeric Regards Stephen ----- Original Message ----- From: "Mike Townend" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, November 27, 2001 1:13 PM Subject: RE: put a recordset in a list > Use the ValueList command > > <CFSET lstFoo = ValueList(MyQuery.Column)> > > HTH > > Mike > > > > -----Original Message----- > From: loic jegouzo [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2001 13:07 > To: CF-Talk > Subject: put a recordset in a list > > > This is a multi-part message in MIME format. > > ------=_NextPart_000_0028_01C1774C.CDA3ABC0 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > hello, > > i would like to know how to put the result of a query in a list. > > if you know how, > > thank's > > > ------=_NextPart_000_0028_01C1774C.CDA3ABC0 > Content-Type: text/html; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = > charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4522.1800" > name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> > <DIV><FONT face=3DArial size=3D2>hello,</FONT></DIV> <DIV><FONT > face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial > size=3D2>i would like to know how to put the = result of a=20 query in a > list.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> > <DIV><FONT face=3DArial size=3D2>if you know how,</FONT></DIV> > <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT > face=3DArial size=3D2>thank's</FONT></DIV> <DIV><FONT face=3DArial > size=3D2></FONT> </DIV></BODY></HTML> > > ------=_NextPart_000_0028_01C1774C.CDA3ABC0-- > > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
