MY PhotoBlog!!

Finally had a little time to play around with PixelPost ! Yippee!

Share on Facebook

I am taking the course “Advanced Databases and Datawarehousing” this semester. As a part of the course, i am supposed to work with either oracle or MYSQL or any other equivalent db.

Instead of working in the labs at the campus ( well, i need to apply and get a valid login from the IT guy at UofL, then take time out of my 20 hours/week schedule, plus swimming , plus taking care of my new kitty, plus hello its snowing, how the deuce do you expect me to go to campus.. and yeah, did i mention i DONT have a car?), i would rather take time to install one that i like on my super hot laptop!

I need to post more pics of my laptop and my kitty .. uh well. so here the first step towards installation of MYSQL.

step1: Choose which db software you want to install. I chose MYSQL because, well i played with Oracle 7.3 when i was a kid(well, 4 years ago i was a kid).

Step2: google “MYSQL APACHE PHP all in one installation”. Well, what do you know, the first of the results leads to XAMPP. OFCOURSE!!

Step3: INSTALL XAMPP

Step4: Need to post more on followups!

ADIOS!

Share on Facebook

I love visual basic… yes its having the word basic..but its so much more than that now!!

Many times when you export data from internet or just plain copy-paste when nothing else works, most of the HTML carries itself with the data into excel. Heres some code to remove hyperlinks from a column in excel.

**************

Sub RemoveHyperlink()

Dim Cell As Range

For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)

On Error Resume Next

Cell.Hyperlinks.Delete

Next Cell

End Sub

**********************

All you gotta do you run the macro after selecting the range of cells with hyperlinks

Share on Facebook

Bubble Sort

This is probably the simplest way sort an array of objects. Not to ignore the fact that it is also the slowest way!

The goal is to compare two neighboring objects.

Step1:Swap them if they are in the wrong order.

Given an array a of numbers, with length n, here’s a snippet of C code for bubble sort:

for (i=0; i< a[j]) {  /* compare the two neighbors */
tmp = a[j];         /* swap a[j] and a[j+1]      */
a[j] = a[j+1];
a[j+1] = tmp;
}
}

Share on Facebook

COCO

powered by performancing firefox

Share on Facebook