Wassup Jose Weblog nonsense at its best!

Code WTF

Why use VBscript with ASP.NET? If that were not bad enough, check out the variable types. I like how the developer (I use the term very loosely) mixes Hungarian notation with Pascal Case. Also, this mess executes in the Page_Load event and is duplicated on all pages.

My favorite part is how the page communicates with the data store directly. Fat clients are here to stay. Design patterns, n-tier architectural patterns, and strong-typed languages are for losers! BTW, WordPress still cannot correctly render code snippets. Lame.

Dim UserName As String
Dim oConn As SqlConnection
Dim oCmd1 As SqlCommand
Dim oCmd2 As SqlCommand
Dim oCmd3 As SqlCommand
Dim aConfig As ConfigurationSettings
Dim strConn As String
Dim strSQL As String
Dim LastActivity As string
Dim MemberID As String = ""
Dim Inactive as Boolean

Private Sub Page_Load()
Dim dr As SqlDataReader

MemberID = Request.Cookies("Site")("MEMBERID")
strConn = ConfigurationManager.AppSettings("ConnectionString")
oConn = New SqlConnection(strConn)
Inactive = False

oConn.Open()
If trim(MemberID & "") <> "" Then
strSQL = "sp_Member @MODE='GETLASTACTIVITY',@MemberID=" & MemberID
oCmd1 = New SqlCommand(strSQL, oConn)
dr = oCmd1.ExecuteReader()
While dr.Read()
LastActivity = dr("LastActivity")
End While
dr.Close()
Inactive = DateDiff("n",LastActivity,Now()) > 30
End If
End Sub

Hitting The Pipe

Haha! Look what I found on Craigslist. Does the project background sound familiar? If this is the project I think it is, the problems are not going to be fixed anytime soon. Also, I assure you that the vendor is NOT going to find an architect-level consultant for $60 per hour.

Let me guess, the SQL architect will be billed at a $105 per hour CMAS rate and the vendor is paying only $60. I think I know who the cheap vendor is too!! Does the vendor name start with an "E", "K", "H", or "T"? Losers!

Search & Replace

I had a few minutes this evening, so I whipped up a handy-dandy code sample. The sample illustrates how to use enumerations, switch statement, and the Regex.Replace method. It is not much, but I wanted to share the love. Tell me what ya think! Bruahaha.

using System;
using System.Collections.Generic;
using System.Text.RegularExpressions;

public class Dinner
{
private enum AttendeeEnum
{
Gman,
Ninja,
Scooter
}
public static void Main()
{
Array attendees = Enum.GetValues(typeof(AttendeeEnum));
foreach(AttendeeEnum attendee in attendees)
{
Console.WriteLine("Attendee: " + getAttendeeName(attendee));
}
Console.ReadLine();
}

private static string getAttendeeName(AttendeeEnum attendeeName)
{
string name = string.Empty;
switch (attendeeName)
{
case AttendeeEnum.Gman:
case AttendeeEnum.Ninja:
{
name = attendeeName.ToString();
break;
}
case AttendeeEnum.Scooter:
{
name = Regex.Replace(attendeeName.ToString(), "coot", "tiff");
break;
}
default:
{
name = attendeeName.ToString();
break;
}
}
return name;
}
}

WTF Code Candidate

I just stumbled on another WTF code candidate, so I have to post it. Developers, grab some tissue, because it's going to bring tears to your eyes. Yup, it's crappy code but I have seen worse (unbelievable, but true). Btw, the WordPress code tag still sucks!

• Hard coded connection string [check].
• Embedded SQL (with *, no less) [check].
• Useless Try/Catch block [check].
• Redundant counters and iterators [check].
• Inconsistent naming scheme [check].
• Spelling errors [check].
• Logic errors [check].

Code Comments

This post is not about how important it is to comment your code. We all know the benefits of well written comments. Instead, I stumbled on this gem. I would post it here, but we all know the WordPress code tag sucks. Excerpt:

At this point, I'd like to take a moment to speak to you about the Adobe PSD format.
PSD is not a good format. PSD is not even a bad format. Calling it such would be an
insult to other bad formats, such as PCX or JPEG. No, PSD is an abysmal format.
Having worked on this code for several weeks now, my hate for PSD has grown to a raging fire that burns with the fierce passion of a million suns. [more]

BTW, there are many classic WTFs on Google Code. I think the best comments I have seen to date are from a consulting company out of Texas that cursed out the clients and other consultants. Morons, everyone and their mother can read your comments!

Max User Connections

I stopped by websiteoutlook.com to check the worth of wassupjose.com. Well, the website had other plans for me. I was greeted with the following error message:

Warning: mysql_connect() [function.mysql-connect]: User admin_wo already has more than 'max_user_connections' active connections in /home/admin/domains/websiteoutlook.com/public_html/sql.php on line 2

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/admin/domains/websiteoutlook.com/public_html/sql.php on line 5
can not connect to database

The interesting part of this post is that the "reported" number of online users was a nudge above 300. Uh, I think we have a problem here. I found this funny, because we had a similar problem on a past project. However, I think the system puked at 20 users. Ha!