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

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

America Mortgage Loans Loans America has incredible mortgage loans programs and low rates for homeowners. Mortgage Rates are at an all time low. Loans America allows you to shop hundreds of lenders with just one click.	Buying Overseas Property Come to the place in the sun live exhibition for advice on finding your ideal home abroad. It is the largest exhibition of its kind in the UK with over 300 exhibitors.	cabinet hardware product Our comprehensive Website will guide you through one of the largest selections of artistic decorative hardware available.	Candles Super scented candles at great prices.

Deadbolts Open your homes with locks, and door handles, other door hardware and security systems designed and styled to transform ordinary rooms into unique showplaces	Decorative Architectural Fiberglass Columns Offering the finest decorative and structural architectural details for residential and commercial installation.	door accessories Our hardware collection s large variety of finishes, functions and styles is designed to blend with your architectural style.	Drain Cleaning Dallas Baker Brothers Plumbing provides clean and professional licensed plumbers for leak location, drain cleaning, plumbing repairs and all pipe fitting services.

home and garden	moisture resistant dry wall The DRAGONBOARD family of products ideal choices for walls, ceiling, and flooring panels. Flooring Diaphragm stiffness.Flexural strength equivalent to concrete.	Montana Timber Montana family log home business since 1989. Log structures, trusses and log accents for architects,builders and home owners. Supplies precut notched logs for log homes and log cabins.	pacific poker The interactive poker information source.

poker tips The best online poker guide.	Sliding door locks We are a full-line residential and commercial door hardware manufacturer based in Charlotte , NC	stainless steel kitchen sink Looking for durable stainless steel kitchen sinks? Visit Stainless Steel Store for the best steel kitchen sinks, utility sinks & much more. Affordable prices. Free shipping!


	Site Map	Privacy

Century 21 Graham Realty \| 1101 E. Landis Avenue Vineland, NJ 08360 \| 856-696-0696 \| contact@c21graham.com