We Toddz

Javascript: Attach Functions to Events

Thu, 14 May 2009 07:05:00 +0000

This allows you to connect events in the browser to javascript functions.

window.attachEvent("onload", yourFunctionName(Var1, var2));

SQL Statement Cross Server Call

Tue, 25 Nov 2008 10:33:00 +0000

Declare @sqltxt nvarchar(500)
Set   @sqltxt = 'UPDATE
DatabaseName.dbo.Table
SET
Active = 0
WHERE
Active = 1

--print (@sqltxt )
exec Server.master.dbo.sp_executeSQL @sqltxt

Clear input element in Javascript

Fri, 21 Nov 2008 02:52:00 +0000

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<form action="">
<%
i=0
do while i<2
%>
<input type="file" name="MyImage<% = i %>">
<input name="button" type="button" style="width: 10.7em;"
onclick="
var z = this.form.MyImage<% = I %>;
var x = document.createElement('input');
x.type = 'file';
if (z.name) x.name = z.name;
if (z.id) x.id = z.id;
this.form.replaceChild(x,z);
" value="Clear filename" />
</p>
<p> </p>
<%
i = i + 1
loop%>
</form>
</body>
</html>

Disable a page or form

Wed, 05 Nov 2008 23:28:00 +0000

Code to disable a page or form

Jewish and Chinese Pilots

Mon, 25 Aug 2008 20:09:00 +0000

A plane leaves Los Angeles airport under the control of a Jewish captain. His copilot is Chinese. It's the first time they've flown together, and an awkward silence between the two seems to indicate a mutual dislike.

Once they reach cruising altitude, the Jewish captain activates the auto-pilot, leans back in his seat, and mutters, 'I don't like Chinese.'

'No rike Chinese?' asks the copilot, '....why not?'

'You people bombed Pearl Harbor, that's why !'

'No, no,' the co-pilot protests, 'Chinese not bomb Peahl Hahbah! That Japanese, not Chinese.'

'Japanese, Chinese, Vietnamese... doesn't matter, you're all alike!'

There's a few minutes of silence.

'I no rike Jews either!' the copilot suddenly announces.

'Oh yeah, why not?' asks the captain.

'Jews sink Titanic.'

'What? That's insane! Jews didn't sink the Titanic!' exclaims the captain, 'It was an iceberg!'

'Iceberg, Goldberg, Greenberg, Rosenberg ...no mattah... all same.'

BEE STINGS !

Mon, 11 Aug 2008 22:44:00 +0000

This information may be something to remember, as this season will soon be
here again...

It might be wise to carry a penny in your pocket while working in the
yard.......... BEE STINGS !

A couple of weeks ago, I was stung by both a bee and hornet while working in
the garden.

My arm swelled up, so I went to the doctor. The clinic gave me cream and an
antihistamine. The next day the swelling was getting progressively worse, so
I went to my regular doctor. The arm was Infected and needed an
antibiotic.The doctor told me - ' The next time you get stung, put a penny
on the bite for 15 minutes'.

That night, my niece was stung by two bees. I looked at the bite and it had
already started to swell. So, I taped a penny to her arm for 15 minutes. The
next morning, there was no sign of a bite. We decided that she just wasn't
allergic to the sting!

Soon, I was gardening outside. I got stung again, twice by a hornet on my
left hand. I thought, here I go again to the doctor for another antibiotic.

I promptly got my money out and taped two pennies to my bites, then sat and
sulked for 15 minutes. The penny took the sting out of the bite
immediately.

In the meantime the hornets were attacking, and my friend was stung on the
thumb. Again the penny. The next morning I could only see the spot where the
hornet had stung me. No redness, no swelling.
My friend's sting was the same; couldn't even tell where she had been stung.

She got stung again a few days later upon her back---cutting the grass! And
the penny worked once again.

Wanted to share this marvelous information in case you experience the same
problem. We need to keep a stock of pennies on hand ..

The doctor said that the copper in the penn y counteracts the bite. It
definitely works!
! Please remember and pass this information on to your friends, children,
grandchildren, etc.

Javascript Date Range Validation

Sat, 26 Jul 2008 15:30:00 +0000

Here is a Javascript function that will tell you if 2 dates make a valid date range.

Code:

function isValidDateRange( objstartMonth,objstartDay, objstartYear, objendMonth,objendDay, objendYear)
{
var startDate = new Date(objstartYear.options[objstartYear.selectedIndex].value,objstartMonth.options[objstartMonth.selectedIndex].value,objstartDay.options[objstartDay.selectedIndex].value);
var endDate = new Date(objendYear.options[objendYear.selectedIndex].value,objendMonth.options[objendMonth.selectedIndex].value,objendDay.options[objendDay.selectedIndex].value);
if

if (startDate>=endDate)
{
alert("Invaild Date Range");return false;

}

else

{
return true;
}

}

Problems with reading cookies between Classic ASP and ASP.net

Wed, 28 May 2008 04:03:00 +0000

The other day at work we started to have issues with sales tracking. After a little research I found that when you iterate through a user's cookies in .Net that some users started to show multiple instances of a cookie with all but one instance containing a blank value. After further researching this situation there appears to be issues with Classic Asp, and ASP.Net. The following code was written in ASP.Net 1.1 (VB.net) iterates through all the users cookies and returns the cookie if it exists and is not blank.

Code:

Public Shared Function getCookie(ByVal CookieName As String) As HttpCookie
        Dim val As HttpCookie = Nothing
        With HttpContext.Current
            For i As Integer = 0 To .Request.Cookies.Count - 1
                If .Request.Cookies.Item(i).Name.ToString.ToUpper = CookieName.ToUpper Then
                    If Not .Request.Cookies.Item(i).Value.ToString = "" Then
                        val = .Request.Cookies.Item(i)
                    End If
                End If
            Next
        End With
        Return val
    End Function

Serialization is the method of storing objects or instances of classes in to binary streams

Wed, 09 Apr 2008 17:25:00 +0000

Serialization is the method of storing objects or instances of classes in to binary streams so that they can be stored or transferred across a network to dependent applications. One security benefit commonly found with storing serialized objects is that they are unreadable by humans. This is a great security benefit in regards to the prevention of compromising data in comparison to storing data in a plain text file where everyone has the capability to read the data.

Serialization can also be called deflating or marshalling.
The opposite of serialization is deserialization. Deserialization basically creates a clone of the original object by inflating the serialized data.

Deserialization can also be called inflating or unmarshalling.

http://en.wikipedia.org/wiki/Serialization
http://www.codeproject.com/KB/cs/objserial.aspx

Constructors are methods or subroutines that are called when a new instance of a class is created as an object

Fri, 21 Mar 2008 18:48:00 +0000

Constructors are methods or subroutines that are called when a new instance of a class is created as an object. The constructor is called to initialize the values of the internal variables (data members) in the object and other advanced data types that form a Has-A relationship with the object. The constructor also has no return type.

Like all methods and functions in object oriented programming, the constructor can be overloaded to allow for initializing the class based on the data the creator of the object has at the time of the objects creation.

Example of an overloaded constructor:

//----------------------------------------------------------
public class Person {
     // instance variables:
     String name;
     String phoneNumber;

     // Constructor with name and number:
     public Person(String name, String phoneNumber){
         this.name=name;
         this.phoneNumber=phoneNumber;
     }

     // Alternative constructor without giving phone number.
     // This will set the phone number to "N/A" (for "not available")
     public Person(String name){
         this(name, "N/A");
     }
}
//----------------------------------------------------------

Code Example From: http://en.wikipedia.org/wiki/Method_overloading

The class Person has two constructors called Person, both can take the variable name but only the first method can take the phone number. To overload a method, you must create two or more methods with the same name but with different method signatures. The method signature is based on the types of parameters passed into the function, and the order in which they appear in the method’s definition.

Example of 2 unique signatures:

//----------------------------------------------------------
public Person(String name, String phoneNumber)
public Person(String name)
//----------------------------------------------------------

How to bust out of frames with ASP and JavaScript

Sun, 09 Mar 2008 18:32:00 +0000

Put this in the head of your page.

<%
myUA = Request.ServerVariables("HTTP_USER_AGENT")
    ua = lcase(myUA)

if instr(Ucase(uA), ucase("MSIE 7.0"))>0 then%>
     <script language="JavaScript">
  
  </script>
<%else%>
    <script language='JavaScript' type='text/javascript'>
  
</script>
    <%end if%>

Developing Good Networking Contacts

Sat, 08 Mar 2008 22:04:00 +0000

There are millions of was you can develop good networking contacts, but you must be open to meeting new people. In the information technology industry, everyone is a potential client. So any place you can meet people is a good place to develop good networking contacts.

Here are a few examples

Online Discussion Forums – Online forums are a great place to show your knowledge of a subject and allow you to meet people that share your same interests
Blog Networks – Allowing others to read your thoughts and comment on them. In addition, you can so the same on other blogs with in the network.
Networking Sites – Networking sites are a great way to find new contacts based on your current contacts because you can share common friends, and possibly common interests
Volunteering – Volunteering is a great way to meet new contacts, and you can help others at the same time
Civic Organizations – Participating in organizations or clubs like the Lions Club, Rotary Club, and religious affiliated organizations because you can meet people of all walks of life, and can share and contribute ideas for common goals
Chamber of Commerce – This is another great way to meet contacts especially if you are interested in starting your own business. The chamber is a great way to meet other business oriented people who are always looking to collaborate and improve their business.
Family and Friends – Family and friends are another excellent to meet new contacts, because they can always be on the lookout for opportunities for you. For example your brother hears that a friend of his needs a new website, so he gives him your number and highly recommends you. This is really good because the potential client is looking for the service you can perform, and you where already highly recommend.

All of the above options are available all over the country.

Sql Identity Returning Incorrect Data

Tue, 04 Mar 2008 15:31:00 +0000

INSERT INTO dbo.tbl_X (Storename) VALUES( 'test qae3')

Use:

select SCOPE_IDENTITY()
select IDENT_CURRENT('dbo.tbl_X') AS NewID

instead of this:

@@Identity

Biggest Advantages and Disadvantages of Applying Online For Jobs

Wed, 27 Feb 2008 01:31:00 +0000

Biggest advantages of applying online

Expanded Coverage Area
Cost Effective
Reduced Time and Increased Efficiency

With the ability to apply on online for jobs, potential employees can dramatically increase the scope of their job search because they are not really limited to their local area. Also, if they would like to relocate from their current location there is no need to move to their desired location before they find a new job. In addition they can look at several possible locations at once.

Appling online is very cost effective for both the applicant and the potential employer. For the applicant, he or she does not have to print out a copy of their resume, drive to the location, and fill out a job application. By allowing the applicant to submit an application online they can avoid costly expenditures.

A few examples of this are:

Ink & paper to print the resume
Gasoline
Ink to fill out the application
Time to actually complete the process

In addition business save money and time by allowing future employees to fill out applications online by not having to store the hard copy of the application. In addition, they need someone take time to receive the documents and process them. When an application is received via online the data is stored usually in a database and can be automatically sent to the proper people responsible for hiring. This saves the company money because it does not have to pay for someone’s time to receive and distribute the application. Not to mention paying to house the application until it is thrown out.

In business the saying “Time is money” is absolutely true especially in our fast paced society. This is proven by first defining what you think your time is worth. To make numbers easy, lets say I estimate my time to be worth $60 per hour. If you compare the total time it takes to actually go and fill out an application at a location in comparison to just sit at home and filling out an online application you will see that you are doing you and your family a financial disservice by wasting time driving to the location in addition to the other costs as specified above.

Example of time to go apply for job:

10 min - Prepare and print your resume
20 min - Adjust your appear to match the job
20 min - Drive to potential palace of employment
5 min - Inquire about job
15 min - Fill out job application
5 min to Submit job application
20 min - Drive home

Total time: 95 minutes = 1 hour 35 minutes
Total Cost $95.00

Example of time to go apply for job online:

10 min - Review job listing and potential employers website
20 min - Fill out online Form
1 min - Attach Resume

Total Time: 31 minutes
Total Cost $31.00

Total savings based on time allocated for applying online $95-$31 = $64
Now Multiply that for ten applications and the cost would be $640.

Biggest disadvantages of applying online

Potential for Errors
Potential for your information to be distributed with our your knowledge or permission
Loss of Human Experience

One big disadvantage of submitting your information online is the potential for errors in the application system. One example of this is the limitation of text fields where you enter your information. The system could be designed to only allow a certain number of characters, and you need more space. In addition, the application could send your information to the wrong people or not even store and send your information at all.

Another big disadvantage of submitting your application online is your privacy being violated. This is especially true for job sites like monster who use your information against you when they solicit based on their advertisers targeting you based on filtered criteria. Don’t we get enough spam already? Or your information could be potentially sold to marketing companies to be used again for various marketing cold call, junk mail or other various unsolicited advertising programs.

For me personally, the biggest disadvantage of applying online is the loss of the human experience. You can learn a lot about a company based on the people you interact with during the application process. This is also true for the overall company environment and atmosphere. This is helpful in determining if you actually would like to spend your time filling out the application because you can usually immediately tell if the work environment is what you are targeting.

There is not really much you can do in regards to errors in the application system, but it could be a sign of how they run there business. For example if you get a server error when you try and submit your application, you might think what kind of company is this. In addition, what kind of work environment do they encourage? Do the employees get away with sub par work, or is it a sign that the company is over worked and is desperate for help?

There is also not much you can do in regards to the distribution of your personal information. I can only recommend that someone submits applications to well known sites that have very good privacy polices. We all have to remember that once you submit the form with your information that a lot of people have access to it. I have heard of a few places where disgruntled employees have allegedly stolen data and used it for personal reasons.

One way you can combat the loss of the human experience is by researching information about the company and reviewing opinion sites about the company to find out more information in regards to how they operate, and how they treat there employees.

How to sync time on a windows PC

Sun, 24 Feb 2008 07:17:00 +0000

I had to use this today. One of our machines at work did not get the daylight savings time patch from Microsoft. So after I updated the PC, I ran this to make sure the time was synced with the active directory domain controler.

Here are the instructions from Microsoft.

To force a computer to synchronize its time with a specific computer, send the following command:

NET TIME \\<MACHINENAME> /SET /Y

-or-

NET TIME \\<IP Address> /SET /Y

On computers running Windows NT 4.0 with Service Pack 3 installed, an environment variable called LogonServer is set to the validating domain controller. The LogonServer variable can be used to load balance the time source responsibility by sending the following command:

NET TIME %LOGONSERVER% /SET /Y

http://support.microsoft.com/kb/193825

Modular programming is the method of programming small task or programs

Tue, 19 Feb 2008 21:22:00 +0000

Modular programming is the method of programming small task or programs that can be arranged in multiple variations to perform desired results. This method is great for preventing errors because each sub program does a specific task and can be debugged individually for that task or within a full program when combined with other small programs.

C# is a great example of modular programming because it allows for functions, methods, classes and objects to be use to create smaller sub programs. A program can be built from smaller pieces of code which saves development time and reduces the chance of errors because it is easier to test a small class or function for a simple solutions compared to testing a full program which has layers and layers of small programs working together.
Yes, it is possible to write the same program using modular and non modular programming, but I would not recommend it.

When you deal with non modular programs, they tend to contain a lot of spaghetti code which can be a pain to develop and not to mention debug especially if you did not write the code. In addition, in my experience they seem to have a lot more hidden bugs which waste debugging and development time.

I always use modular programming because programs designed and with this logic are easier to maintain and debug.

From the user’s view point, they cannot really tell if the code is modular or not with today’s computers.

http://www.eng.fsu.edu/~dommelen/courses/cpm/notes/progreq/node2.html

SQL Quick Reference

Sun, 10 Feb 2008 22:05:00 +0000

Great quick ref for sql.

update tableOne
set tableOne.field1=tableTwo.fieldX
from tableOne, tableTwo
where tableOne.commonID=tableTwo.commonID

http://www.cryer.co.uk/brian/sql/sql_crib_sheet.htm

Defrag SQL Table Indexes

Sat, 09 Feb 2008 08:25:00 +0000

Run this to defrag indexes on sql tables.

DBCC INDEXDEFRAG (database name, tablename, indexname)

IIS 6.0 Backup

Mon, 04 Feb 2008 12:28:00 +0000

Create bat file with the code below, and run periodicly to backup IIs 6.0

@echo off
cd c:\Windows\system32\
cscript iisback.vbs /backup /b IISBACKUP /v NEXT_VERSION
exit

Reindex SQL Table

Tue, 08 Jan 2008 13:10:00 +0000

DBCC DBREINDEX('TableName',' ',90)