SELECT * FROM Community WHERE code = '#communityCode#' AND State = '#stateID#' SELECT Business.*, Industry.name AS IndustryName FROM Business LEFT JOIN Industry ON Business.Industry = Industry.ID LEFT JOIN Community ON Business.Community = Community.ID WHERE Community.code = '#communityCode#' AND Business.State = '#stateID#' AND Business.showListing = 'Y' ORDER BY Business.Industry, Business.name Community Profile Network - <cfoutput>#communityName#, #stateID#</cfoutput> Business Directory
Business Directory Business Directory Business Directory

#communityName#, #stateID# Business Directory
UPDATE Business SET accountStatus = "D", showListing = "N" WHERE ID = #businesses.ID#

#IndustryName#

 #name# #name# - Shop Online
#street#
#city#, #State# #zip# #country#
Phone: #phone#
Fax: #fax#
http://#url#
#fileTitle#
#businesses.description#

Community Profile Network, Inc. &
VillageProfile.com, Inc.

About Our Company

Copyright ©2002 Community Profile Network, Inc.
Community Profile Network is a trademark of Community Profile Network, Inc.
Village Profile and Builder Profile are trademarks of VillageProfile.com, Inc.

This Site is a Cyberworks Media Group Production