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

" & Request("Construction_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 '=============================== %>

Custom Made Furniture Western Trails carries an exclusive line of home decor, high quality silver accents, belt buckles, and home accents.	Effective Team Communication Skills We offer world-class training, facilitation and consultation in Strategic Planning, Leadership Development, Culture Change, High-Performance Teamwork, Sales Training, Customer Care Training.	Eyewear For Cycling Bicyclerx.com - eyewear & glasses.	French Classes Social & Holiday French/English plus business English in the City of London at your office or city venue.

Motorcycle Accident New York Excoplawyer.com is very popular in Dui Lawyer Westchester, Defense Lawyer Westchester, Dui Lawyer Bronx, Defense Lawyer Bronx, Dui Lawyer New York, Defense Lawyer New York.	Passport Agency RushPassport.com is a full service passport, visa and vital documents expediting company and Information Agency that secures US Passports, Passport Renewals and Visas for international travelers who	Prescription Polarized Sunglasses PolarisedRx.com - eyewear & glasses.	Romantic Getaway Ylang Ylang & El Sano Banano offers everything from Weddings Honeymoon In Costa Rica, Travel to Beach Resort & Hotels Costa Rica to Yoga in Costa Rica.

Rv Resorts Westwind RV and Golf Resort in Yuma, Arizona offers rv parks and campgrounds. A summer and winter golf resort with all the amenities

Browse through our Gatlinburg communities to find the home of
your dreams in the area of your choice. Let me help today!

Equal Housing Opportunity - Gatlinburg Real Estate ©2012 All Rights Reserved - Privacy Statement