#ThrowFormError("ERROR! INVALID STATE IN PARAMETERS")# #ThrowFormError("ERROR! NO STATE DEFINED IN PARAMETERS")# <cfoutput>#statename#</cfoutput> Green Directory
Search OCA:
State News & Activities:
Events
Let us know!
Send in News, Organizations, & Events for #Statename#
#Statename# Green and Organic Businesses
within   of
Zip code:  

Add a Green Business

More Organic Directories
Organic Certifiers
Canadian Links
Eco-Directories
Books
Search Engines
About OCA
State is NOT VALID
#ThrowFormError("ERROR! INVALID STATE IN PARAMETERS")# #ThrowFormError("ERROR! NO STATE DEFINED IN PARAMETERS")# <cfoutput>#statename#</cfoutput> Green Directory
Search OCA:
State News & Activities:
Events
Let us know!
Send in News, Organizations, & Events for #Statename#
#Statename# Green and Organic Businesses
within   of
Zip code:  

Add a Green Business

More Organic Directories
Organic Certifiers
Canadian Links
Eco-Directories
Books
Search Engines
About OCA
> #ThrowFormError("Error! Please enter the 5 digit USA zipcode and/or a keyword.
Click back on your browser.")#
select latitude,longitude from zip where zip = #ThrowFormError("Please enter a valid zipcode.
Or if you are sure it is valid please note that we should have a better
zipcode database installed sometime soon.
In the meantime try using a nearby zip code.
")#
SELECT listing.memid, name, headline, visible, city, state, ( left(zip,5) ) AS shortzip, country, areacode1, areacode2, cat1, cat2, cat3, cat4, cat5, online, numcats, paid, updated, entered, staticname FROM listing LEFT JOIN foodattr ON listing.memid = foodattr.memid WHERE listing.memid IN (#ValueList(indexkey.KEY)#) and (visible > 0 AND visible < 5) AND (country = 2) AND left(zip,5) IN (#preservesinglequotes(square.zipcodelist)#) AND ( cat1 IN () OR cat2 IN () OR cat3 IN () OR cat4 IN () OR cat5 IN () ) SELECT busResultsRAW.*, qSquare.distlist FROM busResultsRAW, qSquare WHERE busResultsRAW.shortzip = qSquare.ziplist ORDER BY qSquare.distlist Click on the Name to See the Full Listing.">


       Name                                Headline                              (city, state)

">
"> #busResults.name# - - #headline# #distance# #city#, #application.stateabrv[state]#) "> "> "> #name# - - #headline# #city#, #application.stateabrv[state]#) "> "> #ThrowFormError("Error! Please enter the 5 digit USA zipcode and radius greater than zero and/or a keyword.")#
#ThrowFormError("ERROR! MISSING A STATE OR TYPE PARAMETER")#
<cfoutput>#statename#</cfoutput> Green Businesses
Search OCA:
State News & Activities:
#statename# Events
Become a News Scout!
Send in News, Events, Organizations, and Campaigns for #statename#
#statename# Green and Organic Businesses
within   of
Zip code:  

Add a Green Business

List of #typename#, Alphabetized by City

#state##type#.html

#statename# #typename#

#ZipSearchOutput#

Error! Subsection File Missing!

NNNO!