<%@ 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: Real_Estate_Directories_Real_Estate.asp '------------------------------- ' Real_Estate_Directories_Real_Estate Custom Includes begin Dim page Dim pageName Dim Cities Dim Counties page = "Real_Estate_Directories_Real_Estate" pageName = "Real_Estate_Directories_Real_Estate" Session("expired") = "No" %> <% ' Real_Estate_Directories_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 = "Real_Estate_Directories_Real_Estate.html" sTemplateFileName = "Skin/Real_Estate_Directories_Real_Estate.html" '=============================== '=============================== 'Save the name of the form and type of action into the variables '------------------------------- sAction = GetParam("FormAction") sForm = GetParam("FormName") '=============================== ' Real_Estate_Directories_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")) ' Real_Estate_Directories_Real_Estate Show end '------------------------------- ' Destroy all object variables '------------------------------- ' Real_Estate_Directories_Real_Estate Close Event begin ' Real_Estate_Directories_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("Real_Estate_Directories_Real_EstateMessage") <> "" Then SetScript "PutYourContentHere","


" & Request("Real_Estate_Directories_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 '=============================== %>
  • Air Conditioning Beverly Hills

  • Allen Edward Appliance Repair has been the most successful appliance repair business in the Greater Los Angeles and San Fernando Valley since 1979.
  • Backyard Offices

  • Unique bespoke garden offices fully insulated, wired, and plastered from 5K any size and shape made.
  • Blythewood SC Real Estate

  • Search for homes in Blythewood, Lexington, Irmo and many other areas in South Carolina with our real estate listings.
  • Center City Charlotte NC

  • Charlotte Real Estate for sale, Real Estate in Charlotte NC is hot and My Charlotte Home real estate team can help you buy and sell Charlotte real estate with peace of mind


  • Circus Tickets

  • This allows our customers to almost hand pick the UFC Tickets,Disney on Ice Tickets, WWE Wrestling Tickets, NFR Tickets they want and WWE Raw Tickets
  • Kihei Homes For Sale

  • Nickens Team assist you in realizing your Maui real estate dream home or condo.
  • Las Vegas Homes

  • We provide FREE listings of new construction, existing Las Vegas homes and condos with photos, size, amenities, and asking price.
  • Panama Real Estate MLS Business Directory

  • Panama Real Estate MLS Business Directory Extensive Panama real estate, info, news, business services/products includes why and how to live and invest in Panama property and have an affordable safe luxury life during retirement


  • Weathervane

  • Bar Harbor Weathervanes is a manufacturer of copper weathervanes and cupolas
    Equal Housing Opportunity - Shreveport Real Estate 2003 All Rights Reserved - Privacy Statement


    Free Reports | Free Forms | Financing | Local Info | Search | Partners | Login | Contact | Tools | | Relocation