RE: query result to list

2001-03-21 Thread Clifton . Reichle 

ValueList(query.column [, delimiter ])

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 09:47
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread C. Hatton Humphrey 

After the query, use ValueList(Queryname.RowName) to set a variable name to
a list of the results.

Hatton

 -Original Message-
 From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 21, 2001 10:47 AM
 To: CF-Talk
 Subject: query result to list


 Hi all,

 what's the easiest way to get the outut of a query into a list?

 ex.

 CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
  SELECT ID, Title, Name
  FROM Options
  /CFQUERY

 and I want to access the resulting Names as a list?

 List(rob,ray,eddie,eagle)

 thanks,

 s


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Raymond Camden 

ValueList(getOptInfo.name)

===
Raymond Camden, Principal Spectra Compliance Engineer for Allaire

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

"My ally is the Force, and a powerful ally it is." - Yoda 

 -Original Message-
 From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, March 21, 2001 10:47 AM
 To: CF-Talk
 Subject: query result to list
 
 
 Hi all,
 
 what's the easiest way to get the outut of a query into a list?
 
 ex.
 
 CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
  SELECT ID, Title, Name
  FROM Options
  /CFQUERY
 
 and I want to access the resulting Names as a list?
 
 List(rob,ray,eddie,eagle)


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Dave Watts 

 what's the easiest way to get the outut of a query into a list?
 
 ex.
 
 CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
  SELECT ID, Title, Name
  FROM Options
  /CFQUERY
 
 and I want to access the resulting Names as a list?
 
 List(rob,ray,eddie,eagle)

The easiest way is to use the ValueList function:

ValueList(getOptInfo.Name)

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Howarth, Craig (IBK-NY) 

valueList(getOptinfo.Name)

 -Original Message-
 From: Ethan Rosch [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, March 21, 2001 10:47 AM
 To:   CF-Talk
 Subject:  query result to list
 
 Hi all,
 
 what's the easiest way to get the outut of a query into a list?
 
 ex.
 
 CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
  SELECT ID, Title, Name
  FROM Options
  /CFQUERY
 
 and I want to access the resulting Names as a list?
 
 List(rob,ray,eddie,eagle)
 
 thanks,
 
 s
 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Larry Juncker 

CFSET lstNames = #ValueList(getOptInfo.Name)#

Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.


-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 9:47 AM
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Kevin Gilchrist 

You could do something like,

cfset lst_ID=ValueList(getOptinfo.ID)
cfset lst_Title=ValueList(getOptinfo.Title)
cfset lst_Name=ValueList(getOptinfo.Name)


-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 10:47 AM
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Adkins, Randy 

I am sure there is a custom tag in the gallery for it however:

Establish the list variables at first:
cfset namelist=""
cfset idlist=""
cfset titlelist=""

Then execute the query:
CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
/CFQUERY

The output query to list:
CFOUPUT QUERY="getOptinfo"
cfset namelist=#ListAppend(namelist,getOptinfo.name)#
cfset idlist=#ListAppend(idlist,getOptinfo.id)#
cfset titlelist=#ListAppend(titlelist,getOptinfo.title)#
/CFOUTPUT

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 10:47 AM
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Daniel Lancelot 

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY


cfset list = ValueList(getOptinfo.Name)

look up query functions in cfdocs for moore info...

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 15:47
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Aidan Whitehall 

 CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
  SELECT ID, Title, Name
  FROM Options
  /CFQUERY
 
 and I want to access the resulting Names as a list?
 
 List(rob,ray,eddie,eagle)


CFSET variables.ListOfNames = ValueList(getOptinfo.Name)



-- 
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Patricia Lee 

#Valuelist(getoptingo.name)#

|-Original Message-
|From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
|Sent: Wednesday, March 21, 2001 10:47 AM
|To: CF-Talk
|Subject: query result to list
|
|
|Hi all,
|
|what's the easiest way to get the outut of a query into a list?
|
|ex.
|
|CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
| SELECT ID, Title, Name
| FROM Options
| /CFQUERY
|
|and I want to access the resulting Names as a list?
|
|List(rob,ray,eddie,eagle)
|
|thanks,
|
|s
|
|
|
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Aidan Whitehall 

 CFSET lstNames = #ValueList(getOptInfo.Name)#

FYI, no need for the # signs...

CFSET lstNames = ValueList(getOptInfo.Name)



-- 
Aidan Whitehall [EMAIL PROTECTED]
Netshopper UK Ltd
Advanced Web Solutions  Services

http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: query result to list

2001-03-21 Thread Adkins, Randy 

I feel like a dumb$

I forgot all about the ValueList.

Must be write's block.


-Original Message-
From: Daniel Lancelot [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 21, 2001 11:12 AM
To: CF-Talk
Subject: RE: query result to list


CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY


cfset list = ValueList(getOptinfo.Name)

look up query functions in cfdocs for moore info...

-Original Message-
From: Ethan Rosch [mailto:[EMAIL PROTECTED]]
Sent: 21 March 2001 15:47
To: CF-Talk
Subject: query result to list


Hi all,

what's the easiest way to get the outut of a query into a list?

ex.

CFQUERY NAME="getOptinfo" DATASOURCE="#ACBMainDS#"
 SELECT ID, Title, Name
 FROM Options
 /CFQUERY

and I want to access the resulting Names as a list?

List(rob,ray,eddie,eagle)

thanks,

s
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists