Send me all the directory names and field names and I will write the SQL for you. E.g. If Subdircategory is a table, you also need the field names in the SQL. Nancy
-----Original Message----- From: Lisa Deemy [mailto:[EMAIL PROTECTED] Sent: Monday, October 10, 2005 3:11 PM To: CF-Newbie Subject: Re: Error(s) Nancy, Thanks for the reply. The DirCategory numbers are a way to seperate the categories, (What to See and Do = 100, Where to Stay = 101, Where to Shop = 102, Where to Dine = cat_id 103) And the Subdircategory numbers are a way to seperate the subcategories, (Diners/Coffeeshops = subcat_id 120, Family Restaurants = subcat_id 121 etc. in the category Where to Dine) The original designers were calling for a page with category listings like Where to Dine, then by clicking a category you would get subcategory listings from which the user could select and get an alphabetical listing of let's say Diners and Coffeeshops. The company now wants the user to be able to access an alphabetical list of all the places to dine just by clicking Where to Dine. I know if I could get a return on even one query I'd be set. I tried your suggestion and am still getting the same error.... Thanks again, Lisa >Lisa, >If DirCategory and Subdircategory are numeric fields, you cannot use >any quotations marks. Nancy ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1424 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
