<%@ Language="VBScript" %> <% Dim Conn, Rs, searchID, strSQL, strImgNum, filePath,folderNum ' Create ADO Connection Component to connect with the database Set Conn = Server.CreateObject("ADODB.Connection") Set Rs = Server.CreateObject("ADODB.Recordset") ' Filename: Business_Real_Estate.asp '------------------------------- ' Business_Real_Estate Custom Includes begin Dim page Dim pageName Dim Cities Dim Counties page = "Business_Real_Estate" pageName = "Business_Real_Estate" Session("expired") = "No" %> <% ' Business_Real_Estate CustomIncludes end '------------------------------- '*** TOOLS *** '** FROM FILE ** root=Replace(server.MapPath("AdminOwnerXML.html"),"AdminOwnerXML.html","") 'Set fso = CreateObject("Scripting.FileSystemObject") 'If fso.fileexists(Root & "alreadyAsked.txt") then 'set f = fso.OpenTextFile(Root & "alreadyAsked.txt", 1) 'sHTML2 = f.ReadAll() 'set f=nothing 'End If '** REMOTE XML ** 'sHTML = "" 'url = "http://www.nailsoupmedia.com/PostLinkLetter.html" ''Set xml = Server.CreateObject("MSXML2.ServerXMLHTTP") 'Set xml = Server.CreateObject("Microsoft.XMLHTTP") 'xml.Open "GET", url, False 'xml.Send 'sHTML = xml.responseText 'set xml=nothing '** REMOTE DATABASE ** 'Set Conn = Server.CreateObject("ADODB.Connection") 'Set Rs = Server.CreateObject("ADODB.Recordset") 'Conn.Open "Provider=sqloledb;" & _ ' "Data Source=216.127.88.120,2433;" & _ ' "Network Library=dbmssocn;" & _ ' "Initial Catalog=Accounting;" & _ ' "User ID=sa;" & _ ' "Password=buckler;" 'rs.Open SQL,conn,1,1 'rs.Close 'conn.Close 'set rs=Nothing 'set conn=Nothing ' Set conn = CreateObject("ADODB.Connection") ' Set rs = Server.CreateObject("ADODB.Recordset") ' filePath = Server.MapPath("AdminMyStuff.html") ' conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & filePath ' strSQL = "SELECT * FROM MyListings ORDER BY ID Desc" ' Set rs = conn.Execute(strSQL) ' rs.Movefirst 'rs.Close 'conn.Close 'set rs=Nothing 'set conn=Nothing '=============================== ' Save Page and File Name available into variables '------------------------------- sFileName = "Business_Real_Estate.html" sTemplateFileName = "Skin/Business_Real_Estate.html" '=============================== '=============================== 'Save the name of the form and type of action into the variables '------------------------------- sAction = GetParam("FormAction") sForm = GetParam("FormName") '=============================== ' Business_Real_Estate Show begin '=============================== ' Display page '------------------------------- ' Load HTML template for this page '------------------------------- 'Dim LoadedPage 'LoadedPage = LoadTemplate2 (sAppPath & "Skin/Objects/AutoBlog.html") LoadTemplate sAppPath & sTemplateFileName, "main" '------------------------------- ' Load HTML template of Header and Footer '------------------------------- '------------------------------- SetVar "FileName", sFileName '------------------------------- ' Step through each form '------------------------------- 'OpenDB Load_Cities_Counties Item_Show '------------------------------- Parse "main", True '------------------------------- ' Output the page to the browser '------------------------------- Response.write fixPage(PrintVar("main")) ' Business_Real_Estate Show end '------------------------------- ' Destroy all object variables '------------------------------- ' Business_Real_Estate Close Event begin ' Business_Real_Estate Close Event end UnloadTemplate '=============================== '=============================== ' FUNCTIONS '------------------------------- '=============================== ' Display '=============================== Sub Load_Cities_Counties() Counties = replaceLastComma(Session("counties")) Cities = replaceLastComma(Session("cities")) End Sub Function ShowMyListings Dim con Dim rst Set con = CreateObject("ADODB.Connection") Set rst = Server.CreateObject("ADODB.Recordset") filePath = Server.MapPath("AdminMyStuff.html") con.Open "Driver={Microsoft Access Driver (*.mdb)};" & _ "DBQ=" & filePath strSQL = "SELECT * FROM MyListings ORDER BY ID Desc" Set rst = con.Execute(strSQL) rst.Movefirst Response.Write While not rst.EOF Response.Write "" & rst("mls") & "
" rst.MoveNext Wend con.Close:set rst=Nothing : set con = Nothing End Function '=============================== ' Display Search Form '------------------------------- Sub Item_Show() %> <% If LoadedPage <> "" Then SetScript "PutYourContentHere",LoadedPage Else If Request("Business_Real_EstateMessage") <> "" Then SetScript "PutYourContentHere","


" & Request("Business_Real_EstateMessage") & "
" End If End if For totalDynamics = 1 to DynamicVarIndex aDVar = DynamicVarItem(totalDynamics) & ",load" SetScript aDVar , DynamicVar(totalDynamics) Next SetScript "MyListings",ShowMyListings Parse "FormSearch", False End Sub '=============================== %>

Acworth Real Estate

 
  • Anger Management Seminars

  • The Official Website for Release Technique! The Abundance Course, is a simple, powerful and comprehensive course for achieving total Financial Freedom through Stress Management and Relief.
  • Bumper Repair

  • Dial1Auto.com is the best online resource for Car Tune Up, Auto Glass Repair, Auto Glass, Auto Detailing Service, Auto Body Repair, Auto Detailing, Auto Body Repair , Windshield Replacement etc.
  • Create Free Websites

  • Create Free Websites, AdSense! The Scope of Success, The fastest way of earning money, Many Free Websites, Online Internet Jobs.
  • Credit Repair Company

  • Welcome to StraightCreditRepair.com, an innovative credit repair clearinghouse that connects individuals to trustworthy credit repair providers.


  • Desktop Support Technician

  • ASi Networks, Inc. (ASi) is a privately owned company specializing in the deployment of network solutions and technical services for today?s business market.
  • Earn By Advertise In Site

  • Earn By Advertise In Site, The fastest way of earning money, Many Free Websites, Online Internet Jobs.
  • Earne Money For Online Surveys

  • Earne Money For Online Surveys, Jobs, Who will pay?. How you can start? Learn more about Online internet Part time Jobs.
  • Glow Light Sticks

  • Glow Bracelets Glow Necklaces Glow Sticks 10mm, 6 Glow Sticks 10mm, 4 Glow Sticks 15mm, 6 Wholesale Case Pricing Bright Glowsticks, Bulk Glow Stick, Glow Necklace and Wholesale Glow Sticks.


  • Homebased Business

  • We are dedicated to providing the greatest value, and the finest shopping experience available.
  • How Iso Certified

  • We have a 100% success rate for satisfying product and project goals on four continents, in multiple languages, giving us the ability to support your multi-language workforce, multiple facilities or
  • Imitation Rolex

  • Swiss Quality Watchez is your online headquarters for Replica Designer Watches such as Rolex Yachtmaster Replicas at low Wholesale-Direct Prices.
  • Jobs On Internet

  • AdSense! The Scope of Success, The fastest way of earning money, Many Free Websites, Online Internet Jobs, Online Typing Jobs, Online Data Entry Jobs, Who will pay?. How you can start? Learn more ab


  • long lasting lipstick

  • Vita Liberata -Ordering is simple and safe! To order a product simply click on the add to basket situated under the product price.
  • Money Making Opportunity

  • JWB Global LLC is a network of websites devoted to making your shopping experience thought the internet easier and more enjoyable
  • Online Survey Jobs Sites

  • AdSense! The Scope of Success, The fastest way of earning money, Many Free Websites, Online Internet Jobs, Online Typing Jobs, Online Data Entry Jobs, Who will pay?. How you can start? Learn more ab
  • Open Signs

  • We''ve been providing our clients with quality products and services for fifteen years.


  • Retail Display Case

  • Display Case Company specializes in distributing and manufacturing Fixtures for the retail industry.
  • Rolex Replica

  • Swissreplicastore has been the #1 Leading Online Manufacturer and Wholesale Distributor for the Best Genuine Swiss Rolex Replica Designer Watches such as our Rolex Replicas.