Nancy, I really appreciate this, more than you know....What you're doing is really above and beyond. This is what I have as far as Table names and Feild names. Thank you again. Lisa
Table: DirCategory Table: Subdircategory BGCOLOR CAT_ID CATNAME SHORT_DESC CAT_FOOTER SUBCAT_ID CAT_HEADER SUBCAT_IMAGE CAT_ID SUBCAT_MENU CAT_IMAGE SUBCAT_NAME CAT_MENU SUBCAT_NAVBAR CAT_NAVBAR CAT_ORDER FORECOLOR SHORT_DESC Table: Directory ACTIVE_FLG ADDRESS ADDRESS2 ADVERTISE AD_BANNER AD_FLG ANNUAL COMPANY_NAME CONTACT_NAME COUNTY_ID CR_DT DIRECTORY_ID DIR_DATE_DESC DIR_EMAIL DIR_IMAGE DIR_PHONE DIR_START_DATE DIR_WEBSITE EMAIL FAX LOCATION MAP_CODE MOD_DT PHONE PHONE800 SHIP_ADDRESS SHIP_ADDRESS2 SHIP_CITY SHIP_FLG SHIP_STATE SHIP_ZIP SHORT_DESC STATE SUBCAT_ID TOWN WEBSITE ZIPCODE >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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:15:1425 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
