How to: Populate listbox with fields from DB

[Captain Ru]

I created a .cfm page using various queries to output a company phone list (1.
lname alpha, 2. dept, 3. branch). I then have it create a .PDF using the
<cfdocument> tag.

Now I am trying to recreate this site but allow the user to manually choose
the parameters in which to query, creating a custom .pdf.

The problem I am having is that I do not know how to call the fieldnames
themselves to be available for queries, and I would like them, once selected,
to not be available in the next list box. I'm also not sure if the #index# used
in the select is correct. Maybe it should be #recordindex# ?

I have my select * query, and <form action = "phonebook.cfm" method = "post">
<cfoutput query = "getfields">
<select name = "param#index#">
<option value = DON"T KNOW WHAT TO PUT HERE>
</select>
</cfoutput>
</form>

Maybe my logis isn't right as well.

[warddc]

the cfquery tag returns a property called columnlist which is the name of each column returned from the query. so you could do a select * and then loop over columnlist.

dave.

[Captain Ru]

So I'm going to want columnlist and loop through to index. Is there a
columncount, like the recordcount attribute?

That way I could use that to determine how many 'option value's i will use. If
possible have....

Maybe I'll have one listbox, then have another popup if a record is selected
for use in a query OR allow multiple selections via one listbox....

I want this to be as user-friendly and error-prone free. Thanks for your help!

[warddc]

you don't need to know how many options tags to create. just loop over the
list that was returned.

<cfloop index="item" list="#myquery.columnlist#">
<option><cfoutput>#item#</cfoutput>
</cfloop>

better yet just use a cfselect form object and let it build the options
automatically.

<cfselect name="myselect" query="myquery" display="columnlist"
value="columnlist">

d

d.

[Captain Ru]

well what I mean is that I want the user to custom create a phonelist based on
parameters to be shown.

This will let the user select from the first listbox to display the Lname, the
next box the FName, third box Phone...Ext...and so on. The number of available
boxes to choose shouldn't exceed the number of columnlist elements.

I could also achieve the same results allowing multiple selections from one
listbox.

However, the other way could allow the user to custom sort as well based on
all those criteria.