<%@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 & "?" & Server.HTMLEncode(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_mitchell_STRING MM_editTable = "freereport" MM_editRedirectUrl = "formaction.asp?action=freereport" MM_fieldsStr = "sell|value|sell1|value|sell2|value|buyer|value|buyer1|value|fname|value|lname|value|email|value|iam|value" MM_columnsStr = "sell|none,'Y','N'|sell1|none,'Y','N'|sell2|none,'Y','N'|buyer|none,'Y','N'|buyer1|none,'Y','N'|fname|',none,''|lname|',none,''|email|',none,''|iam|',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))) session(MM_fields(MM_i)) = Request.Form(MM_fields(MM_i)) 'this sets the session for a given field name 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 %> Mitchell Team | Real Estate Newmarket, RealCanada Networks














Psychology Of Colour
Do Different Colours Affect Your Mood?

Colour is all around us.  We see it all the time.  The psychology of colour is based on three psychological responses; emotional, behavioral and physical.  It can create an uneasy feeling in certain rooms or very relaxed in another, this is called “colour of mood”.  Colour often has different meanings in the various cultures.

Red – the most emotional intense colour, stimulates appetite and energy levels, urgency, passion, heat, love, strength and power, passion, speed and danger

Pink – is associate with things that are sweet and innocent, nurturing, has a short term calming effect, security

Orange – orange lowers hostility and is a very sociable colour, often used in fast food restaurants, movement, playfulness and warmth

Green – popular decorating colour, it is the easiest colour on the eye and can improve vision, hospitals use green because it relaxes the patients, brides in the middle ages wore green to symbolize fertility, dark green is masculine and implies wealth, seamstresses often refuse to use green on the eve of a fashion show for fear it will bring bad luck

Yellow- cheerful optimistic colour, people can lose their temper in yellow rooms, babies can cry more, it is the most difficult colour for the eye to take in, speeds up the metabolism, enhance concentration

Purple – wealth, royalty, sophistication, intelligence, spirituality, and philosophical

Blue – colour of the sky and the ocean, peaceful, tranquil blue causes the body to produce calming chemicals, so it is often used in bedrooms, people are more productive in a blue rooms,  honesty, integrity, truth, dignity, power, belonging, spirituality

Black – is colour of authority and power, it is timeless and stylish, black also implies submission, sophisticated, dignity, power, death, seduction, mystery and evil

Brown – solid, reliable, brown can be sad and wistful, men are most apt to say brown is one of their favorite colours.

White – brides wear white to symbolize innocence and purity, white reflects light, represents cleanliness and sterility, purity and emptiness

 

Click here to view a gallery of rooms before and after Staging
10 tips for creating the perfect curb appeal
Psychology of Colour

 

For more information on FREE Home Staging Consultation please fill out the simple form below.

 

Required fields are bold. We respect your privacy – your information is never shared or sold to outside entities. See our Privacy Policy.

 

First Name :

Last Name :

Home Phone:

Email :

Address:

Comments: