Copy link to clipboard
Copied
Hi all. I'm novice and would like to use cfselect to populate a drop-down list with a query but I haven't been successful so far, can someone tell me what I'm missing?
It's a financial application and I just need a drop-down of accounts (like 'utilities,' 'supplies,' etc.) . . .
The code I'm using is:
<cfselect name="formCategory" cfquery="categories" value="category"></cfselect>
But it doesn't work. (Sorry, I can't see the error message because I'm using a shared server and the specific message doesn't display.) My 'categories' query is a very simple list of the account names with the column name 'category'.
Why isn't this working?
Thank you.
Copy link to clipboard
Copied
You need a display attribute.