I am trying to make a dynamic navigation.
I have a database(MySQL) table called "Navigation" for my CF data source.
the format is:
record_id text URL category
in my navigation I want to display two categories at once. There is global, and
lets say Health. If I want to display them on the same page at once, how can I
do this?
I thought that using AND with the WHERE clause would work, but does not.
THIS WORKS FINE:
<cfquery name="Navigation" datasource="#REQUEST.dataSource#">
Select *
FROM navigation
WHERE Category ="Global"
</cfquery>
<table border="0">
<cfoutput query="Navigation">
<tr>
<td><a href="#Navigation.URL#">#Navigation.Text#</a></td>
</tr>
</cfoutput>
</table>
You can see this at:
http://gotnutrients.net/FoodSystems/url_test.cfm
This works for one category, but if I want to display both Global & Health is
where things break.
I was thinking that I could use:
WHERE Category ="Global" AND Catagory ="Health"
Any help here would be great!
By the way is this a good way to make a dynamic navigation system?
Thanks so much,
John
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4687
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
