I decided to share this information on the web as I’ve visited many sources where the workaround for the conversation failed sql error is not entirely accurate.

If you receive this ASP error, it’s probably due to the fact that you are trying to return a list of results where the declared variable in your if statement = a certain interger value. Depending on who designed the table structure and relations in a SQL database, you cannot declare this statement if your data contains symbol(s) such as a comma (which was used to relate your record with other records).

To resolve this issue, simply use the SQL LIKE clause as well as including percentages %variablename% around the variable in cases where the identifier is greater than 2 digits in length (i.e. id=1,3,12,15,233). Now when you execute the sql statement, whatever value is in your variablename (example 15), only records will display that contain the number 15 (exactly 2 digits long). The commas used to seperate your related ID’s will be ignored in this case..

Good luck!

I found this funny..

So I saw an interesting Facebook advertisement that displayed a web site that will convert your pictures into cartoon images.

That does seem pretty cool, however I really do feel bad for those people who decided to actually download their toolbar. Read all of the bonus programs that come along with it! I can imagine all of the pop-ups shortly after installing this program..

I’m having difficulty trying to answer this question accurately. What do you think?

So it has been quite some time since I’ve posted a blog entry.. Sorry about that Been super busy with work and life.

These days I’ve been getting pretty sick of this rain here in New England. Actually, I can’t really complain much due to the fact that my electricity bill is not as high as last year. Last year we had some really hot days and I would crank the central air to 65-68 degrees. The past couple of months I’ve had the heat and central air off, so I’ve been saving quite a bit of $$$ I’ll be taking a cruise at the end of the month to Bermuda (finally nice weather) where I’ll be able to spend all that saved up $$$ on liquor and entertainment.

Anyhow, I’m back and will be posting more often.

-Jonathan

Just the other day my cousin Mike called and told me to install the new iTunes 8.0. After installing the new iTunes, I played around with a new function called Genius, which is indeed genius!

Here are a few observations as to why iTunes genius is smarter than you when it comes to picking songs and arranging them so that they play in a perfectly smooth sequence. I chose a song by David Gilmour, selected Genius, and the application picked the best songs to be played with “Out of the Blue”. From the list, it chose songs from Pink Floyd, Eagles, Jeff Beck, Steely Dan, and many other classics that flow as if it was all songs by the same artist.
I then chose some hard metal music “Dimmu Borgir”, and it properly chose Rammstein, Slipknot, Rob Zombie, CKY, and many others that I would have not think to add in a playlist together. The entire playlist ran and every song appeared to be in perfect order, not jumping from track to track that seem so different from one-another..as you may typically notice in self-made playlists..
I finally tested some hip hop by choosing “Check Yo Self by Ice Cube”. I’m telling ya, this mix was absolutely perfect as it added some Dr. Dre, Jay-Z, The Game, Rick Ross, and many others which all had similar beats and a smooth transition between each track.
I wish I had this for the house-warming party! I could of had some good mixes going, but instead we were stuck in having to hear Mike’s playlist which featured tracks that seemed to be in the wrong order or playlist.

This application is simply genius!

Maybe I’m out of touch with the news lately, but has anyone heard of the Earth Hour? This morning I had thought Google changed their home-page to adopt the Blackle idea, however that was not the case. Apparently there is a goal to have as many people as possible turn off their lights from 8:00PM-9:00PM in their local timezone to help raise awareness of worldwide energy conservation. I commend the idea and will do my part to support the awareness, however it may have been a better idea on Google’s part to have this message+countdown on their homepage earlier this week (so more people would be aware). I could be wrong.., but I feel there will be more people who will miss this message as it’s the weekend, not everyone may visit Google on a daily basis, and so on.

Anyhow, I support the idea and I do hope others will take part. When and if most people turn off the lights for 1 hour, I just hope it doesn’t have a significant impact (stress) on the powerplant when suddenly everything comes back on