Use or instead or and in the query. Paul
On 8/9/09, John Barrett <[email protected]> wrote: > > 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:4688 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
