by Vahid
10. January 2009 09:15
Today I was tracing a defect happened in a stored procedure with paging functionality. After spending sometimes on it I came to know that sorting does not work properly. In the order by clause of the procedure we were using an input parameter which holds the column name based on which the result was to be sorted. But it seems that oracle and pl-sql does not support this feature and if we want to sort based on an input parameter we have to go for dynamic query which I don’t like at all.But it's funny that the feature is not there in oracle because the same thing can be done in ms sql server easily.Anyone got some idea about this, please let me know.
by Vahid
3. January 2009 05:36
hi,
as you may know c# is missing the nice and usfull IsNumeric function which is available in VB.net. but it is a trivial task to implement a generic equvelant function for it. look at the following code. it will return true if the value is numeric and false if the value is false.
static bool IsNumeric(object value)
{
double retNum;return Double.TryParse(Convert.ToString(value), System.Globalization.NumberStyles.Any, System.Globalization.NumberFormatInfo.InvariantInfo, out retNum);
}
by Vahid
25. December 2008 20:36
working extensively on XML these days, i was in need a good tool which has
the ability to evaluate XPath queries. i have been using XML Notepad for a long time
and really like the tool but there is not feature in the tool to evaluate Xpath
queries. searching around i found XML Explorer.
the tool supports so many functions and it is really fast. You need to work on
xml like me, take the tools from here
http://www.codeplex.com/xmlexplorer
http://www.codeplex.com/xmlnotepath
Subscribe