Monday, September 27, 2004

Whats your goal?

Everybody has dreams, goals and aspirations... Whats yours?
Everyone has lots of stuff goin' thru their minds every second that he/she wants to achieve in life.
Ever thought about it in detail? Ever though of jotting it down? Ever thought of planning your 1 and only life? Wanna get a Ph.D before you hit 30? Masters? Wanna own a BMW 700 series? Perhaps a Bunglow?
Well, I know Ithink of it.... Always..... At this point in my life when i am 22, my head is filled with wants, aspirations, and goals that I want to achieve.
What should I do that might help me to plan? should I make a FREE Life Planner Software to help me and you to reach or atleast keep track of our goals and dreams?
As I recall, i wanted to be a scientist when i was a kid, wanted to build a laboratory next to a huge bungalow that would of-course be mine. Then I wanted to be a fighter pilot, then an IT Expert. Well.. I dont know where i am goin with this but... something needs to be done..(atleast for me) I want wake up and grab life by the throat and make it go the way I want it to go damn it!
Why do I have to follow what life leads me to do? Why doesn't it go the way I want it to go?
Perhaps a software to keep the important things that can help me to drive my life in view? maybe i will take some action for some of the goals?
I dunno...
But I know something needs to be done!
Why dont you gimme suggestion as to what should be done? Some software that can assist you to do something? Action-planning software to get control of life?

There's gotta be something.......

I need your 2 cents !

Thursday, September 23, 2004

Creating Controls, Datagrid, etc. on the fly

Finally i managed to create all the server controls in ASP.NET on the fly(with help from Ranjit). Everything... From something as simple as a textbox to the complecated datagrid. I am goin to write an article on it. So i will update the link for that article here later as soon as i get the article up on codeguru, programmersheaven and codeproject.Its great stuff.. i start with an EMPTY html page and the end result is a full fledge complecated ASPX page will all the controls create on the fly inlucding the databindings.Coming your way soon...

Wednesday, September 22, 2004

Delete frm Multiple Tables at once(SQL). Possible?

Taken from an article by Shelley Doll
Deleting from multiple tables at once
There is no standard solution provided within the SQL92 specification to accomplish this task.The DELETE statement cannot accept multiple tables as a parameter. As a destructive query, this ensures that there is no ambiguity where the commands are to be executed. Additionally, this limitation prevents the use of AND with multiple subqueries within a single statement. If you test the results of your SELECT statement to see what data set would be affected in a DELETE query, you’ll find that SELECT will return results for a list of multiple tables and against multiple subqueries where DELETE will not.There are a number of possible workarounds that may meet your needs, though, such as creating a field in your table that designates whether the entry is active or not. Alternatively, you can use a stored procedure in some databases to iterate through each required DELETE query.

Pet store example
To explain how to perform this type of row deletion, I’ll use the following tables in a sample database called PetStore that contains inventory information. In Table A, breed, I’m storing information about each breed of animal the pet store stocks. Table B, inventory, contains information about the specific animals they have in the store.

Table A
breed_id breed_name breed_descr
1 Poodle Dog
2 Shitzu Dog
3 Saint Bernard Dog
4 Siamese Cat
5 Fancy Rat

Table B
pet_id breed_id pet_name pet_gender pet_descr
100 1 Prince M Black
101 2 Toto F Tan
102 3 Spike M Tan
103 4 Marla F Seal tip
104 5 Narf M Grey
105 2 Fanny F Brown

For this example, let's assume the store has sold its entire litter of Shitzu puppies. I can use the breed_id field from the breed table to remove all Shitzu inventory entries like this:DELETE FROM inventory WHERE breed_id IN(SELECT breed_id FROM breed WHERE breed_name = ‘Shitzu’);
First, I specify the table from which to delete records, in this case, the inventory table. Then, I cross-check an identifying field, breed_id, against the results from a subselect clause. I know I’m looking for Shitzus, and I can remove them without having to look up the breed_id in a separate request.
I must warn you that using DELETE statements in this manner can be dangerous, and they should only be used if you're familiar with the database’s structure. The DELETE query will remove entire rows from the affected tables, and you should know what that means to the data you’re housing. It’s a good idea to test DELETE statements on subqueried results by replacing the keyword DELETE with the phrase SELECT * to ensure the results contain everything you want deleted, like this:SELECT * FROM inventory WHERE breed_id IN(SELECT breed_id FROM breed WHERE breed_name = ‘Shitzu’);
The mythic DELETE with JOIN
An alternate approach to this problem that a member specifically asked about was the use of JOIN clauses with DELETE statements. Not having used that solution before, I looked into it and found SQL Server documentation claiming this was supported, although not SQL92-compliant. Upon testing and consultation with gurus from various database platforms, I found that the use of DELETE with JOIN statements doesn't work on any of the platforms tested.

Another new start at Jadelite Technologies

It's good to be back...As I mentioned before, I was working in Accenture till now. I quit Accenture on 17th September 2004 and joined Jadelite Technologies on 20th September 2004. Well working in huge companies doesn't really mean you get to learn a lot. About why i couldn't blog for all this time, i couldn't access this website from Accenture because of the restrictions implemented in the network, the editting page wouldn't load.But in Jadelite everything in noramalI'm Back...

This page is powered by Blogger. Isn't yours?

© Copyright 2005, Rohan Thomas
This Blog contains findings that are self-explored and expressions that are self-evoked. They are by no meanss representions of my employer's view.