Error Type: Server object, ASP 0177 (0×800401F3) Invalid class string

October 22nd, 2008

Error Type:
Server object, ASP 0177 (0×800401F3)
Invalid class string

Read the rest of this entry »

ADODB.Command

October 15th, 2008

Dim cmd
SET cmd = Server.CreateObject(”ADODB.command”)
WITH cmd
.CommandType = adCmdStoredProc
.CommandText = “”
.ActiveConnection = “”
.Parameters.Append .CreateParameter(”@bbID”,adSingle,adParamInput,3,)
.Parameters.Append .CreateParameter(”@raCode”,adVarChar,adParamOutput,,”")
.Execute, , adBinary

‘adOpenStatic,adLockBatchOptimistic
‘adOpenForwardOnly,adLockReadOnly
‘adOpenStatic,adLockReadOnly
‘adOpenDynamic,adLockOptimistic
END WITH

Set cmd = nothing

‘—- DataTypeEnum Values —-
Const adEmpty = 0
Const adTinyInt = 16
Const adSmallInt = 2
Const adInteger = 3
Const adBigInt = 20
Const adUnsignedTinyInt = 17
Const adUnsignedSmallInt = 18
Const adUnsignedInt = 19
Const adUnsignedBigInt = 21
Const adSingle = 4
Const adDouble = 5
Const adCurrency = 6
Const adDecimal = 14
Const adNumeric = 131
Const adBoolean = 11
Const adError = 10
Const adUserDefined = 132
Const adVariant = 12
Const adIDispatch = 9
Const adIUnknown = 13
Const adGUID = 72
Const adDate = 7
Const adDBDate = 133
Const adDBTime = 134
Const adDBTimeStamp = 135
Const adBSTR = 8
Const adChar = 129
Const adVarChar = 200
Const adLongVarChar = 201
Const adWChar = 130
Const adVarWChar = 202
Const adLongVarWChar = 203
Const adBinary = 128
Const adVarBinary = 204
Const adLongVarBinary = 205
Const adChapter = 136
Const adFileTime = 64
Const adPropVariant = 138
Const adVarNumeric = 139
Const adArray = &H2000

Ajax in classic ASP: Data Not Refreshed

October 12th, 2008

Add these line of codes to the page.

(http://www.aspkey.net/aspkey/_articles/asp/showarticle.asp)

<%@ LANGUAGE="VBSCRIPT" %>
<!--#Include virtual = "adovbs.inc"-->
<%
    Response.Buffer=true
    Response.AddHeader "cache-control", "private"
    Response.AddHeader "pragma", "no-cache"
    Response.ExpiresAbsolute = #January 1, 1990 00:00:01#
    Response.Expires=Now()-1
    Response.AddHeader "Cache-Control", "must-revalidate"
    Response.AddHeader "Cache-Control", "no-cache"
%>

Validate Phone Number

October 10th, 2008
  1. function isPhoneNumber(s)
  2. {
  3. // Check for correct phone number
  4. rePhoneNumber = new RegExp(/^\([1-9]\d{2}\)\s?\d{3}\-\d{4}$/);
  5. if (!rePhoneNumber.test(s)) {
  6. alert(Phone Number Must Be Entered As: (555) 555-1234″);
  7. return false;
  8. }
  9. return true;
  10. }

Hiding PHP file extension

September 30th, 2008

I was working on a (rather neglected, outdated) site I had previously done and decided it needed some (rather, a lot of) improvements. I was looking for a way to get rid of to clean up the URLs without having to remap my files. .htaccess to the rescue!

.htaccess files are a wonderful thing, and incredibly powerful, ignoring the bad experience I had with them on my current web host (fortunately, this project is hosted by another web host, and everything runs perfectly with them :)), and Apache’s mod_rewrite module does exactly what we need.

There are a bunch of reasons you’d want to do this, mainly:

  • it looks cleaner and easier to read and remember
  • by using search-engine–friendly URLs, you’re Google PageRank will increase and will increase your website’s findability
  • it makes your website environment-independent, so if you ever decide to change the technology your site uses, everything would appear seamless to your visitors.

In this case, we’re using PHP files, but you can change it to whatever type of file you’re using, be it .html, .asp, .cfm, or anything else, as long as they’re all the same type. (If you want to do this for multiple file types, just copy lines 2–4 and apply the same technique accordingly.)

Open your text editor and create a file called “.htaccess” with the following code in it, and upload it to your site’s root directory (Note: On Unix and unix-like operating systems, files that start with a dot are hidden files, so you may not be able to see the file after you save it. To get around this, omit the preceding dot when naming the file, and then rename the file back to “.htaccess” after you have uploaded it to your webserver):


RewriteEngine on
RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME}\.php -f
RewriteRule ^(.*)$ $1.php

(adapted from the Apache mailing list)

Using this code, instead of having to type in http://mysite.com/contact.php, you only need to enter http://mysite.com/contact to access that page. And the best part is, you can still access the page with .php on the end of it, so no old incoming links or bookmarks become orphaned as a result of this, and everyone is happy.

The 10 Worst Job Tips Ever

September 21st, 2008

You might have taken these ‘worst job-seeking advices’. Read the rest of this entry »

7 Exceptions to Job Search Rules

September 15th, 2008

Here are six common job search “rules” and when it might be acceptable to break them. Read the rest of this entry »

How To Write A Killer Resume

August 11th, 2008

If your résumé isn’t winning interviews for your dream job, it might be time for a rewrite. Read the rest of this entry »

10 Signs It’s Time to Quit

August 6th, 2008

“I like what I do. I just don’t like where I work.” Sound familiar?

From unbearable co-workers to depressing work environments, there things that can make even the best job a living hell. Here are some signs it’s time to look for a new job. Read the rest of this entry »

Eight Worst Things to Say in an Interview

July 28th, 2008

Interviews are nothing if not opportunities to drive yourself crazy. Just remind yourself to look good, appear confident, say all the right things and don’t say any of the wrong ones. It shouldn’t be so hard to follow these guidelines except you’ll be on the receiving end of an endless line of questions. Factor in your nerves and you’ll be lucky to remember your own name. Don’t fret. If you walk into the interview prepared, you can make sure you know what right things to say, and you can stop yourself from saying the following wrong things. Read the rest of this entry »