Contact Us ~ Services Offered ~ Our 6 Year Develpment Plan ~ Strategic Advantages ~ Related Links ~ Home
View Zoning Map Zoning Key: C-1 = Retail Commerial C-2 = General Commercial C-3 = Commercial Park District M-1 = Manufacturing B-1 = Business
Please Note:
Other properties are available that require special permits. Please contact one of the real estate agents listed for further inquiries. Click on the images below to see a larger version. View a listing of Canton's Strategic Advantages for business.
<%
'this shows what is before the needed asp code
'Declare a record set
dim oRS
'Create a record set object to store data in
set oRS=Server.createObject("ADODB.recordset")
'Set up the SQL statement
sSQL = "select * from CommercialProperty" 'name of table that info drawn from
'Add an ORDER BY clause to the SQL to sort the records
sSQL = sSQL & " order by zoning;" 'a field in table if you want it ordered
'Run the query and store the results in the oRS record set
oRS.Open sSQL, "dsn=ced" 'this is where you enter the name of the DSN set up by ISP
if oRS.EOF then 'No records found; eof = end of file
response.write "
No records found"
else
oRS.MoveFirst
Response.write " "
'Loop through the record set and build HTML code to fill the table with items
Do while NOT oRS.EOF
'enter as many fields as you want to display from the table
Response.write ""
Response.write " | " & _
"" & " "
Response.write ""
Response.write "Location: " & oRS("Location") & " "
Response.write "Zoning: " & oRS("Zoning") & " "
Response.write "Square Footage: " & oRS("SquareFootage") & " "
Response.write "For: " & oRS("SaleRent") & " "
Response.write "Price $: " & oRS("Price") & " "
Response.write "Contact: " & oRS("Contact") & " "
Response.write "Comments: " & oRS("Comments") & " "
' Response.write ": " & oRS("") & " "
Response.write " | "
oRS.MoveNext
if not oRS.EOF then
Response.write ""
Response.write " | " & _
"" & " "
Response.write ""
Response.write "Location: " & oRS("Location") & " "
Response.write "Zoning: " & oRS("Zoning") & " "
Response.write "Square Footage: " & oRS("SquareFootage") & " "
Response.write "For: " & oRS("SaleRent") & " "
Response.write "Price $: " & oRS("Price") & " "
Response.write "Contact: " & oRS("Contact") & " "
Response.write "Comments: " & oRS("Comments") & " "
' Response.write ": " & oRS("") & " "
Response.write " | "
Response.write " "
oRS.MoveNext
End if
Loop
end if
Response.Write " "
%>
|