Ok, this is what i am trying to do....I want to look through my records in a
table called Buttons. There is a field in the Buttons Table named Location.
This field contains either a 1, 2, 3, 4, 5, or 6. What i want to do is
dynamically populate a list box of the numbers that are NOT in the database.
This is what i have so far, but i get messed up outputs..... can someone
help me please????
<cfquery datasouce="data" name="info">
SELECT *
FROM Buttons
</cfquery>
<select name="Location">
<cfoutput query="info">
<cfif info.Location IS "1"> <cfelse>
<option value="1">1</option>
</cfif>
<cfif info.Location IS "2"> <cfelse>
<option value="2">2</option>
</cfif>
<cfif info.Location IS "3"> <cfelse>
<option value="3">3</option>
</cfif>
<cfif info.Location IS "4"> <cfelse>
<option value="4">4</option>
</cfif>
<cfif info.Location IS "5"> <cfelse>
<option value="5">5</option>
</cfif>
<cfif info.Location IS "6"> <cfelse>
<option value="6">6</option>
</cfif>
</select>
Now is there something i am doing wrong? should i be using a CFLOOP
instead????
Help me please....
Thanks
Kev
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
