Hello,
Here is a dumb beginners question.
I am working on a small site which has a database of songs. For each song
there are fields like type, language, tempo, etc. In the admin page I need
to allow editting of the type of song or its language or its tempo. The data
that was given to me was initially inputted manually into a SQL Server
database so for each song there is at least one value for type, language and
tempo. I do show this value with the following code:
<td class="text">
<select name="Type">
<cfoutput query="rsSongEdit">
<option value="#rsSongEdit.Type_ID#" <cfif
(isDefined("rsSongEdit.Type") AND rsSongEdit.Type_ID EQ
rsSongEdit.Type)>selected</cfif>>#rsSongEdit.Type#</option>
</cfoutput> </select> </td>
Now I want to be able to add also the rest of the values in the recordset
without repeating the value that is already selected. If there is no value
selected, then I want to be able to show the full list of entries in the
recordset.
How do I go about it?
Thanks in advance,
Mitko Gerensky-Greene
****************************************************************
"Make no search for water. But find thirst,
And water from the very ground will burst."
(A Persian mystic poet, quoted in Delight of Hearts, p. 77)
"The world is but one country and mankind its citizens"
Baha'i Faith
http://www.us.bahai.org
*****************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
