<%@LANGUAGE="VBSCRIPT"%> <% ' *** Edit Operations: declare variables Dim MM_editAction Dim MM_abortEdit Dim MM_editQuery Dim MM_editCmd Dim MM_editConnection Dim MM_editTable Dim MM_editRedirectUrl Dim MM_editColumn Dim MM_recordId Dim MM_fieldsStr Dim MM_columnsStr Dim MM_fields Dim MM_columns Dim MM_typeArray Dim MM_formVal Dim MM_delim Dim MM_altVal Dim MM_emptyVal Dim MM_i MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Request.QueryString End If ' boolean to abort record edit MM_abortEdit = false ' query string to execute MM_editQuery = "" %> <% ' *** Insert Record: set variables If (CStr(Request("MM_insert")) = "form1") Then MM_editConnection = MM_bizbro_STRING MM_editTable = "getupdates" MM_editRedirectUrl = "getupdates_action.asp" MM_fieldsStr = "name|value|email|value" MM_columnsStr = "Name|',none,''|email|',none,''" ' create the MM_fields and MM_columns arrays MM_fields = Split(MM_fieldsStr, "|") MM_columns = Split(MM_columnsStr, "|") ' set the form values For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_fields(MM_i+1) = CStr(Request.Form(MM_fields(MM_i))) Next ' append the query string to the redirect URL If (MM_editRedirectUrl <> "" And Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If End If %> <% ' *** Insert Record: construct a sql insert statement and execute it Dim MM_tableValues Dim MM_dbValues If (CStr(Request("MM_insert")) <> "") Then ' create the sql insert statement MM_tableValues = "" MM_dbValues = "" For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2 MM_formVal = MM_fields(MM_i+1) MM_typeArray = Split(MM_columns(MM_i+1),",") MM_delim = MM_typeArray(0) If (MM_delim = "none") Then MM_delim = "" MM_altVal = MM_typeArray(1) If (MM_altVal = "none") Then MM_altVal = "" MM_emptyVal = MM_typeArray(2) If (MM_emptyVal = "none") Then MM_emptyVal = "" If (MM_formVal = "") Then MM_formVal = MM_emptyVal Else If (MM_altVal <> "") Then MM_formVal = MM_altVal ElseIf (MM_delim = "'") Then ' escape quotes MM_formVal = "'" & Replace(MM_formVal,"'","''") & "'" Else MM_formVal = MM_delim + MM_formVal + MM_delim End If End If If (MM_i <> LBound(MM_fields)) Then MM_tableValues = MM_tableValues & "," MM_dbValues = MM_dbValues & "," End If MM_tableValues = MM_tableValues & MM_columns(MM_i) MM_dbValues = MM_dbValues & MM_formVal Next MM_editQuery = "insert into " & MM_editTable & " (" & MM_tableValues & ") values (" & MM_dbValues & ")" If (Not MM_abortEdit) Then ' execute the insert Set MM_editCmd = Server.CreateObject("ADODB.Command") MM_editCmd.ActiveConnection = MM_editConnection MM_editCmd.CommandText = MM_editQuery MM_editCmd.Execute MM_editCmd.ActiveConnection.Close If (MM_editRedirectUrl <> "") Then Response.Redirect(MM_editRedirectUrl) End If End If End If %> Business Broker for Commercial Real Estate in Florida
Sunbelt Business Brokers of Northwest Florida
List of Businesses for Sale
Business Financing
Area Information
Sunbelt Business Brokers Office Location
Contact us for businesses for sale
Download Forms
Updates of businesses for sale
Site Map
Sunbelt Business Brokers

Name:
Email:
We will email you every time we add a listing.



Located across from
Harbor Docks

543 Harbor Blvd.
Suite 401
Destin, Florida 32541
Office (850) 864-2727
Fax (850) 650-4683
E-mail broker@bizbro.com
"Sunbelt Business Brokers of Northwest Florida...we sell quality cash flow businesses
Area Information
Below you find useful links about buying a business in Florida as well as information to help you relocate to the Emerald Coast.
  Okaloosa County Tourist Development Council.
  South Walton Tourist Develoment Council. Web site dedicated to South Walton County.   Accommodations, restaurants, beaches, visitor information, public organizational information.
  Official City of Destin government website.
  Taxes and Finance information for the State of Florida. Business tax reasons to locate and operate a business in the State of Florida. And... "no Personal Income tax!!!"
  Seeking permanent residence in the United States? and are excellent ways to establish permanent residency. Purchasing a business can be an excellent way to establish permanent residency. "Investment based immigration" and "Employment based immigration are two ways to qualify. In most cases a permanent resident may apply to become a United States Citizen five years after becoming a permanent resident. Click on the topics for more details.
  "Seaside...a small holiday town on the beach where wood cottages with picket fences line brick streets leading to beach front gateways that connect to the sugar white sand and the emerald green water of the Gulf of Mexico." On 30-A, about twenty-five miles east of Destin.
  Ft. Walton Beach - City Calendar of Events, City Council, Employment Opportunities, Golf Club (Pines Course & Oaks Course), Purchasing Department (BIDS, RFP's, etc.), Phone Numbers, A Brief History of Fort Walton Beach, Tourist Information, Area Information Pages (map, homestead, licenses, churches, population, taxes, housing, academicis, transportation, utilities, weather).
  Information on the city of Niceville, Florida - just across the Choctawhatchee Bay from Destin. The new Mid-Bay bridge connects the cities of Destin and Niceville.
  Home page for county school district (includes Destin / Ft. Walton Beach). Includes links to home pages for 7 high schools, 6 middle schools, and 21 elementary schools in the school district! A "must see" for families with children considering relocation to the area.
  Destin Chamber of Commerce.
  Greater Fort Walton Beach Chamber of Commerce.

Member Sunbelt Business Broker National Network
International Business Brokers Association


Copyright © 2005 Sunbelt Business Brokers of NW Florida. All rights reserved.