select listbox 2

[Albert3162]

Hello.
I have data in column like (Albert, John, Brenda, ...)
I need show this data as select listbox
do anybody have something like this?

Thanks.

 

[webmigit]

Essentially:

<cfquery...name="testc">
  select * from table
</cfquery>

<cfoutput><form action="#listlast(cgi.script_name,"/")#" method="post">
  <select name="xsel">
  <cfloop query="testc">
    <option value="#DATA_COLUMN#">#DATA_COLUMN#</option>
  </cfloop>
  </select>
</form></cfoutput>

You'll have to make the revisions of specifying a datasource, changing DATA_COLUMN to a data column...

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[ecobb]

Try this:

<cfset MyList = ValueList(Query.column)>

<cfoutput>
 <select>
  <cfloop index="i" list="MyList" delimiters=",">
    <option value="#i#">#i#</option>
  </cfloop>
 </select>
</cfoutput>

Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[ecobb]

Man, I've got start typing faster if I want to get an answer in before webmigit or bombboy around here!



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[webmigit]

No, just check TT every two seconds... That should be a skill on my resume... "I can program, act as DBA, and check forums fast."

haha...

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[ecobb]

"I can program, act as DBA, and check forums fast."

You're Hired!



Hope This Helps!

Ecobb
Beer Consumption Analyst

"My work is a game, a very serious game." - M.C. Escher

 

[TruthInSatire]

I even tried to put TT in a frame to auto update every 60 seconds once, but it would break out of it.

webmigit sounds like your server admin too. don't forget that.

I wonder if that's something that TT can offer. We can be Certified TT refreshers.

Human beings, who are almost unique in having the ability to learn from the experience of others, are also remarkable for their apparent disinclination to do so.
-Douglas Adams (1952-2001)

 

[webmigit]

Certified?

As in a certificate?

Or as in "certifiable" (calling someone crazy)..

I think both fit nicely.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.