Rules to Better ..

I just found a cool link on Scott Guthrie's Blog. This link all about how you can improve your various skills like communication, marketing and technical skills. The articles on better software development and project management are cool. Check it out. Nice work by SSW.

Tags : Coding Standards, Project Management, Application Design, .NET

Blogger Blocked In India

Many Blogger/Blogspot users here in India are unable to log into thier blogs. Indian govt has issued a directive to ISPs in India to ban few websites including Blogger, TypePad, GeoCities. According to Hindustantimes, there are around 12 websites that have been listed. This directive has been issued after the mumbai blasts. Many bloggers have been left stranded. Some users have reportedly to easily log into dashboard and even wrote thiers blogs.

There can be a couple of alternatives to access the blogger here in India.

1) Use proxy server ( www.publicproxyservers.com ). Search the term on google for various proxy IP addresses. Hundreds of addresses are listed on these websites.

2) Use a Site Viewer to instantly view any webpage ( http://www.anybrowser.com/siteviewer.html )

Tags : blogger blocked, Indian ISP, blogger

RowID and ORA-00937: not a single-group group function

I have been facing this error for quite sometime now. No its not that I have not properly used group by function. My SQL reads something like this in error log file

Select nvl(max(id_no),0) id_no, Desig.ROWID from ......

But my actual SQL query in VB does not have a Desig.ROWID . Then from where did this ROWID got inserted ?
This is what actually happens :

When I looked into my VB code, I found while making a recordset, that the locktype used was adOptimistic. This mode is used when we need to read the data from database, modify it then again save it back to database. So he needs to know which row has to be updated which results in adding a rowid to query. So the solution to this problem is to use readonly mode.




Tags : RowID, Oracle, ORA-00937, single-group