It's been a very long time since I've done any real CF coding. Almost 8 years
to be exact. But this is something that a 5 year old with a CFWACK book could
do.
I'm trying to populate a select box with a list of the karate schools in my
database so that people can determine which school they want their lead to go
to. I'm have a problem getting the SchoolID field to work however.
When I view this in the MySQL editor that GoDaddy provides the SchoolID field
is correctly populated with 1 through 13. However when I run the query and
output it I just get 1's and 0's. This is the code I'm using.
<cfquery name="get_schools" datasource="#dsn#">
SELECT SchoolID, SchoolName
FROM Schools
ORDER BY SchoolName
</cfquery>
<cfoutput query="get_schools">#SchoolID# - #SchoolName#<br></cfoutput>
You can see it in action here
http://www.legionofnightmares.com/kungfukat/form.cfm
Any ideas?Thank you,
Katrina
If people knew how hard I worked to gain my mastery,
it wouldn't seem so wonderful after all.
--Michelangelo
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306665
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
