Content is currently being developed.
October 5th, 2009 | Published in Internet, Internet Marketing
Content is currently being developed.
October 5th, 2009 | Published in Halifax
So <b>where is the Fairview overpass?</b> LOL yeah, the way the Halifax Department of Transportation worded it when they “notified the public” was a bit vague, and they used a name that is not “official”. They assumed everyone knows what the Fairview overpass is, and where it is, just like they assume everyone knows that the Provincial highway #102 is called the “bi-hi”. There are about 50 overpasses that could constitute as a “fairview overpass” in Halifax. Anyway, the <u>Fairview overpass in Halifax</u>, where the construction will be occurring, will affect you if you go 1 of two ways into the city:
As you can see below, it is between point a and b on the map. You know when you leave halifax, and you pass the windsor street interchange, you can loop hard right and get yourself on the Joseph Howe Dr? Well that “overpass” you drive under, is the Fairview Overpass. It is directly before the Windsor St. Interchange, one of only 3 ways onto the peninsula that Halifax sits on (besides the bridges from Dartmouth) These include:
The majority of traffic that will not be able to use the construction route will likely divert to the highway 102 inbound route.
Regardless, it’s going to make my commute 50% longer in the morning. Nice. You may have found this if you are a frustrated Halifax commuter looking for:
October 3rd, 2009 | Published in Programming
What is a Disconnected Recordset?
A Disconnected Recordset is A recordset object that exists in an application, but does not have an associated data connection associated with it.
Why use a Disconnected Recordset?
The ADO Recordset is considered an extremely “rich object model” which means it provides more functionality than say, an array.
Also, you can load XML into a disconnected recordset, which means that there is no difference in your RS than if you hit a database.
How to code a Disconnected Recordset?
Here is an example of putting data from XML into a recordser, a disconnected recordset to be exact.
Const adVarChar = 200
Const adSingle = 4
Const adPersistxml = 1
Const adUseClient = 3
Const adOpenStatic = 3
Const adLockBatchOptimistic = 4
Const adStateOpen = 1
Public Function fGetXmlForRs(strFieldsCsv, intFieldLen)
Dim objRs, arrFields, intCount, objXmlDom, objXmlRows, objXmlRow, objXmlColumns, objXmlColumn
Set objRs = CreateObject("ADODB.recordset") 'create disc. rs
Set objXmlDom = CreateObject("Msxml2.DOMDocument")
objXmlDom.LoadXML "YOUR_XML_HERE"
arrFields = split(replace(strFieldsCsv," ",""),",")
For intCount = 0 To uBound(arrFields)
objRs.Fields.Append arrFields(intCount), adVarChar, intFieldLen 'fieldname, type, size
Next
objRs.Open , , adOpenStatic, adLockBatchOptimistic
Set objXmlRows = objXmlDom.selectNodes("YOUR_ROW_NODE_HERE")
For Each objXmlRow In objXmlRows 'for each row
intCount = 0
set objXmlColumns = objXmlRow.selectNodes("col")
objRs.AddNew()
For Each objXmlColumn In objXmlColumns
objRsLocal (arrRequestedFields(intCountCol)).value = objXmlColumn.text
intCount = intCount + 1
Next
objRs.Update()
Next
Set objXmlDom = Nothing
Set fGetRntRs = objRs
Set objRs .ActiveConnection = Nothing
End function
To use the XML to Recordset function, just call this:
Set yourNewRs = fGetXmlForRs("field1name, field2name, etc", 255)
do while not yourNewRs.eof....
September 27th, 2009 | Published in Web Development, Web Hosting | 1 Comment
Well, my website was hacked with iframe injections pointing to ageegle dot ru -ageegle.ru- last week (not this site). The hacker added malicious code to my index or default web files that included iframe tags pointing to a site called ageegle dot ru (do not visit that site) on port 80. This page, when visited, caused the site to try to download malware to the users computer.
The first thought to enter my mind was that my web host was hacked. I don’t quite remember how i ruled that out, but it was not that. I then considered that there was a vulnerability in my code, since it was a site written in classic asp with vb script that I had written entirely myself. I ruled that out as well, because I was meticulous in ensuring that there were no holes that would allow sql injection attacks, or any access to the file system itself. I did my own testing to ensure this, then hired two separate consultants to review and test the code again.
I opened the file browser within my web hosts control panel, and noticed that the modified date of the files were updated to the date the malicious code was written to them. Since I do not share my hosting password with anyone, it had to be FTP, with the credentials stolen by malware on my own computer. Many are quick to dismiss that, but it can happen easy.
I had never been hit with malware or a virus in 11 years of computing without an antivirus software, so I got cocky. I found that I got a piece of malware with a download of some plugins for dreamweaver.
Even when I changed my FTP password on the host, the spammer was able to write to my files with the iframe injections. This means that when I changed the FTP credentials in Dreamweaver, they were capturing them there.
Install at least two anti-virus applications on any development boxes you use, and scan everything. Use SFTP if you can. NEVER use pirated web development tools, as normally the keygens (exe files) contain the malware that steals passwords. Its just too damn risky.
If this has happened to you, and you are having issues getting things back on track, feel free to leave me a comment, and I will be happy to help out if I can, or at least point you in the direction of more information.
You will have found this post if you searched for any of the following:
Sites linked to in the malicious code (Don’t visit these sites):
May 8th, 2009 | Published in Website Management
Below is a draft of a “Terms and Conditions of Use” or “Disclaimer” statement template.
There are a few tags to replace in the template before publishing it to a web property:
{{ORG_NAME}}
– Your main or Parent Company’s Name. (e.g. the “bing” website’s parent would be “Microsoft Corp” for example)
{{SITE_URL}} – http://www.YourURL.com{{SITE_NAME}} – The general operating name of your website (e.g. http://google.com/adsense Site Name would be “Google AdSense for Publishers” for example)Scope and Purpose of this Disclaimer
This disclaimer document governs your use of our informational website. By using the website located at {{SITE_URL}} and it’s subdirectories, you agree to, and accept this disclaimer in full. If you disagree with any part of this disclaimer, do not use our website, as that condition prohibits you from doing so. {{ORG_NAME}} reserves the right to modify these terms at any time, and thus, you should check for changes before proceeding to utilize the services and content of {{SITE_NAME}}. By using this site after changes have been made to this document, you agree to accept those changes, whether or not you have reviewed them.
Rights to information published
All materials on this site are protected by copyright and intellectual property laws and are the property of {{ORG_NAME}}. Unless stated otherwise, you may access and download the materials located on {{SITE_URL}} only for personal, non-commercial use. You may not reproduce this material on your personal website, blog, social network, or any other online resource.
Any and all content (including user and visitor generated content) submitted either via email, comment forms, or any other page hosted at {{SITE_URL}} or its content aggregation systems becomes the property of {{SITE_NAME}}. {{SITE_NAME}} reserves the right to alter, remove, re-post, re-purpose, market, or trade any such content.
Our Rights to Remove or Reproduce any User-Generated Material
For the purposes of this condition, the term “user-generated material” shall refer to any information, content, or any other media uploaded, posted, emailed, submitted, or otherwise communicated to {{SITE_NAME}} via any method at any page on {{SITE_URL}} or any other content communication or submission medium or forum.
By sharing any contribution or user-generated content (including any text, photographs, graphics, video, audio or any other type of media or content) with {{SITE_NAME}} ({{SITE_URL}}) you agree to grant us, free of charge, permission to use the material in any way we deem fit (including the modification, reproduction, repurposing, or deletion of it). You hereby confirm that your contribution is your own original work, is not defamatory and does not infringe upon any laws of the country from which you are utilizing this site, nor the laws of Canada or The United States of America, and that you have the full rights to accept this condition.
Site content (quality, accuracy and use)
Visitors who use this website and rely on any information do so at their own risk.
This Web site and the attached documents are provided “as is” without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Information found at {{SITE_URL}} will not always be up to date and cannot necessarily be relied upon.
The information is intended solely for entertainment purposes and may not be used as a substitute for professional advice and/or information, as circumstances will vary from person to person. You should not act or rely upon this information without seeking professional advice. Do not attempt any of the suggested actions, solutions, remedies, or instructions found on this website without first consulting with a qualified professional. They are not intended to be nor do they constitute actionable professional advice. Transmission of this information is not intended to create a professional-client relationship between {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) and you.
The owners, editors, contributors, administrators, and other staff of {{SITE_NAME}} (a {{ORG_NAME}} web property) are not qualified professionals, and are simply aggregating information found online for entertainment purposes only.
By using this website, you hereby forfeit any and all claims, past, present, and future, against the owners, editors, contributors, administrators, and other staff of {{SITE_NAME}} (a {{ORG_NAME}} web property).
Restrictions on who can use the website
If you are under 18, please get a parent’s or guardian’s permission before taking part in any {{SITE_NAME}} community. Never reveal any personal information about yourself or anyone else (for example, school, telephone number, your full name, home address or email address).
By visiting any page at {{SITE_URL}} you understand that “adult” content may be encountered that is not suitable for children. You must be at least 18 years of age or have a parent/guardian present while viewing any page or other correspondence or content from the {{SITE_NAME}} website, (which includes all content and code from any page hosted at or within {{SITE_URL}}, or any content or code relating to or from this site that was transmitted via email or other means). {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) can not be held responsible for any harm that is experienced, real or perceived, from viewing, following, or contributing, of any sort of content on this site.
External links – limiting liability for links to other web sites
We are not responsible for the contents or reliability of any other websites to which we provide a link, and we do not, expressly or otherwise, endorse the views and/or content expressed within those sites.
The Actions and Opinions of Other Users
You must not use this website in any way which is unlawful, illegal, fraudulent or harmful, or in connection with any unlawful, illegal, fraudulent or harmful purpose or activity. Some content found on the pages of {{SITE_NAME}} within {{SITE_URL}} and its subdirectories is created by members of the public. The views expressed are theirs and unless specifically stated are not those of {{SITE_NAME}} (or it’s parent, {{ORG_NAME}}). We accept no responsibility for any loss or harm incurred from the use of this website or any of it’s information or content.
Viruses, Damage and Availability
{{SITE_NAME}} (or it’s parent, {{ORG_NAME}}) makes no warranty or claim that functions available on this website will be uninterrupted or error free, that defects will be corrected, or that the server that makes it available, nor the content itself is and/or will be free of viruses, bugs, or other malicious code. You acknowledge that it is your responsibility to implement sufficient procedures and virus checks (including anti-virus and other security checks) to satisfy your particular requirements for the accuracy of data input and output, and for the security of yourself and the device used by you to view any content from this website.
Legal jurisdiction
The Federal laws of Canada and the Provincial laws of Nova Scotia shall otherwise govern your use of the site where these terms and conditions are not clear or incomplete and you hereby agree to submit to the exclusive jurisdiction of the Canadian Federal and Provincial court system.
Limited Liability
{{SITE_NAME}}, (and it’s parent, {{ORG_NAME}}) and its officers, employees, contractors or content providers shall not be liable for any loss or damage arising from or otherwise in connection with your use of any content, information, function, or service of {{SITE_NAME}} at any location within {{SITE_URL}} or other related location (such as content feeds, links, emails, letters, documents, and other company products or correspondence).
Though we make a reasonable effort to maintain the resources of this website, they will, from time to time, become out of date, be incorrect, erroneous, or otherwise inappropriate. As noted above, by using this website you agree that you will not follow any instruction, suggestion, step, list, tutorial, or other content on this website or any of its content posted elsewhere untill you have appropriately consulted with a licensed professional who is unrelated to this site or it’s parent company in any way.
May 3rd, 2009 | Published in technology, Web Development | 2 Comments
If you are looking for a Cross Browser Compatible CSS Opacity code, you need look no further. The following provides 100% opacity (which is the same as 0% transparency.)
1 2 3 4 5 6 7 8 9 10 | Body { ...your body css... -moz-opacity: 1.0 !important; -webkit-opacity: 1.0!important; -ms-filter:"progid:DXImageTransform.Microsoft.Alpha(Opacity=100)" !important; filter: alpha(opacity=100) !important; opacity: 1.0 !important; } |
The key is ensuring that the order of the opacity entries are kept in this format.
The -webkit- opacity handles chrome, the -mox- handles FF, Netscape, Mozilla, the -ms- handles older IE versions, like 5 and 6.
April 20th, 2009 | Published in technology
Groove is a component of Microsoft Office enterprize 2007.
If you don’t use the groove service, you can uninstall it.
This should work for removing groovemonitor.exe from your system. (You want to do this because it runs at atartup and persists even after you term the process, which is annoying.)
This article pertains to the following queries. If you searched any of the following phrases pertaining to the way to delete groove you will be interested in this page:
April 12th, 2009 | Published in Internet, Internet Marketing, SEO
Can I place adsense for search units on a 404 not found page? Can I place adsense text ad units on that same 404 not found page? This is a group of questions that comes up a great deal. There are also a lot of mixed answers out there.
If you have a plain, uncustomized 404 page, with no content, you can not use either of these. It is against their terms of service. However, if your 404 has a little bit of “we’re sorry, blah blah…” content, and perhaps a few other helpful content items, then you can safely place the adsense units on it.
Hi [protected],
Thanks for your email. I apologize for the confusion and will be more than happy to clarify.
After looking up ticket #[protected], I noticed that your questions were about placing Google ads on customized error pages that contain sufficient text-based content. For this type of pages, you’re welcome to place Google ads on them, as our crawlers will be able to serve relevant ads.
However, regarding your question in ticket #[protected], it sounded like the 404 error pages you’ve mentioned were the default error pages with no content. According to our program policies (https://www.google.com/adsense/policies), no Google ad may be placed on any non-content-based pages.
Therefore, if you’re able to customize your error pages by adding enough content, you’re more than welcome to place Google ads on them.
I hope this information clarifies your concerns.
For additional questions, we encourage you to visit the AdSense Help Center ([]google.com/adsense_help), our complete resource center for all AdSense topics. Alternatively, feel free to post your question on the forum just for AdSense publishers: the AdSense Help Group ([]groups.google.com/group/adsense-help).
Sincerely,
Nicole
The Google AdSense Team
Hope this helps, and as always, before you believe what you read on the net (including this) be sure to have a good and clear understanding of the actual adsense program policies AND the terms of service AND the webmaster guidelines.
April 10th, 2009 | Published in Programming, technology
This is a simple VBS VBScript that I use to delete all files in a given folder on a machine. It is particularly useful to delete internet cache files or cookies. You can set a scheduled job actually, to perform this task nightly. This script could be easily modified to, say, clear out your temporary internet files from the folder used by internet explorer. This example is a vbs vbscript to delete files in a temporary folder called “downloads” contained within my “My Documents” folder.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 | ' VB Script Document, VBS, WSH, wscript ' Deletes files in a specified folder, for example, a temp downloads folder. ' By GR, February 27, 2009. ' robarspages.ca 'Declare variables Dim strCacheFile Dim strComputer Dim strAppData Dim strUserProfile Dim strErrorfile Dim objWMIService Dim objShell Dim objFSO Dim objFolder StrcacheFile = "\downloads\" strComputer = "." 'leave alone if running script on same maching Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set objShell = CreateObject( "WScript.Shell" ) '---path to the application data folder. not used in this example. strAppData = objShell.ExpandEnvironmentStrings("%APPDATA%") '---path to the user folder (if multiple users) strUserProfile = objShell.ExpandEnvironmentStrings("%USERPROFILE%") Set objFSO = CreateObject("Scripting.FileSystemObject") ' get the folder that contains the folder you want to empty. Set objFolder = objFSO.GetFolder(strUserProfile & "\My Documents") If objFSO.FolderExists(objFolder & StrcacheFile) Then objFSO.DeleteFile(objFolder & StrcacheFile & "*"), True WScript.Echo "Folder """ & objFolder & StrcacheFile & """ was emptied successfully" else WScript.Echo "ERROR: I could not find the folder, please check the path..." End If ' Clean up objects Set objWMIService = Nothing Set objShell = Nothing Set objFSO = Nothing Set objFolder = Nothing |
April 10th, 2009 | Published in Programming, technology, Web Development
I needed a quick vbscript to terminate a specific windows process that seemed to hang. This is the script that will do it. It uses SQL to lookup the process name from the win32_process list, then uses the terminate function to close it.
NOTE: this vbs to terminate a windows process was only tested on Windows XP professional edition.
Just leave strComputer variable as-is if you are using it on the same machine as the process you want terminated. Replace the ENTER_PROCESS_NAME_HERE portion of the code with your process name. (to find a windows process name, just go to the windows task manager, click “processes” and the name that appears in the “process name” column is the string you should enter.)
1 2 3 4 5 6 7 8 9 | strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colProcessList = objWMIService.ExecQuery _ ("SELECT * FROM Win32_Process WHERE Name = 'ENTER_PROCESS_NAME_HERE'") For Each objProcess in colProcessList objProcess.Terminate() Next |
The for loop ensures that if there are multiple processes open that match your query, all of them get terminated. If you are looking to terminate a specific process, make sure you enter it’s full name, and make sure you research other processes so that you don’t terminate other processes that you didn’t intend to.
If you want to terminate multiple, but similar processes, you can use wildcard, just like in any sql statement.
1 | SELECT * FROM Win32_Process WHERE Name LIKE 'm%' |
This code will select all processes beginning with the letter M, for example.
Hope this helps. Comments welcome.
View older articles:
I am trying to find the group/entity/company behind the ezooms.bot (ezooms.bot@gmail.com) User agents: Mozilla/5.0 (compatible; Ezooms/1.0; ezooms.bot@gmail.com) Some IP: 220.181.108.79 If you know any more info on this spider/bot/crawler/probe, please post below.
Here is some code to do a full outer join on three tables. In the example, the three full outer joins are done on two columns , but it works just the same if you only have a single join column. CREATE TABLE ZA (T CHAR(1), O CHAR(1)) CREATE TABLE ZB (T CHAR(1), O CHAR(1)) […]
Here is an OLD article I had about data caching in classic asp using the application object. When it comes to application performance on your web servers, ever little bit counts. Howto build a database caching system Introduction In this tutorial I will teach you how to build a simple database caching system to improve […]
Comparing OLE DB and ODBC This document compares the basic features of OLE DB to the basic features of ODBC (Open Database Connectivity). It is intended to help clarify when to use one over the other. Introduction OLE DB vs ODBC OLE DB and ODBC are both specifications created by Microsoft to address universal data access. […]
Here is how to Export Windows Scheduled Task Information to File with Command Line: schtasks /query /fo CSV /v >> scheduled_task_metadata.csv This will dump a list of scheduled tasks and their advanced settings to a CSV file called “scheduled_task_metadata.cs” to whichever location you run the command prompt from. If you don’t want the windows scheduled […]
MYSQL Statements and clauses ALTER DATABASE ALTER TABLE ALTER VIEW ANALYZE TABLE BACKUP TABLE CACHE INDEX CHANGE MASTER TO CHECK TABLE CHECKSUM TABLE COMMIT CREATE DATABASE CREATE INDEX CREATE TABLE CREATE VIEW DELETE DESCRIBE DO DROP DATABASE DROP INDEX DROP TABLE DROP USER DROP VIEW EXPLAIN FLUSH GRANT HANDLER INSERT JOIN KILL LOAD DATA FROM […]
A technology blog about classic ASP and vbScript from the east coast
