Oracle Trunc Function
2008-11-24 Among various helpful functions provided by Oracle, Trunc function took my attention today because I had to fix a defect where some one has misunderstood and misused this function. As the name itself suggests, the trunc function is capable of truncating a value. This function can be used either on a date type value or a numeric value. Using trunc for numeric values When it comes to numbers, trunc function can return a number trunca...
How to Search for UnRead Emails On Gmail?
26-09-2012 How to find un-read emails that are hidden under stacks and stacks of read emails? Simple, just add is:unread to your search then Gmail will bring all unread emails relevant to your search. For example, if you want to see all unread emails from your Friends circle: Usually you would use circle:friends in the search box. To get the unread ones, add is:unread to it. circle:friends is:unread This will bring unread emails...
How to Get the Underlying DataRow of a DataGridViewRow
23-07-2012 How to get the underlying data row of the bound data table linked to a DataGridViewRow in a DataGridView? How to get the underlying DataRow of a DataGridView.Row? How to get the underlying DataRow matching to a Selected Row of a DataGridView? How to map the DataGridView row to the datasource? How to get back to the matching DataRow of the DataSource of a DataGridView Row? Answer: Use the DataBoundItem property of t...
How to use (escape) single quotation mark in sql statements
06-10-2011 // // We all get that day when we get an exception complaining about the single quotation or apostrophe that was in our SQL statement. The best advisable thing to do is to use stored procedures so that all data are passed as parameters. However there are situations we have to use in-line SQL statements and even there are situations where even SQL parameters cannot manage this issue. For example, if you use the exec method...
Using DispatcherTimer To Create A Timer In WPF
09-03-2012 // // WPF doesn't have a straightforward Timer control that you can drag and drop from the Toolbox. However, ther's still a straightforward easy way to implement this. You can use the provided System.Windows.Threading.DispatcherTimer class for this It's easy as abc. Steps: 1 Create an instance System.Windows.Threading.DispatcherTimer TimerName = new System.Windows.Threading.DispatcherTimer() ; 2 Create an ev...
What is Go in SQL Server and the Importance of Using Go
25-05-2012 Go is not a SQL or Transact SQL command. Go is a command recognized by sqlcmd and osql facilities provided by SQL server studio. Go specifies an end to a particular SQL batch. Once the parser interprets a Go, that block is considered completed and the following SQL are considered as new batch till the parser finds a new Go. For example, even though following code isn't syntactically wrong, it won't work because a create pr...
Failures are the Pillars of Success!
2008-12-01 Today I went to the embassy to get the response for the visa application I submitted about a month back. I had kept a lot of hopes on this. Today was like a junction in my life. If I get the permission to work, I would get a much better financial standing, more qualifications, more experience, etc. So I went and waited on the queue waiting for the officer to read my name. Mean while I remembered what my mother told me before I had to s...
/// Stops asp.net from encoding the source HTML string.
public static IHtmlString HTMLRaw(string source)
return new HtmlString(source);
call this function whenever you want asp.net NOT to encode the string.
Note: You can use <%= and %> tags to avoid encoding as well.
StackOverFlow has become a popular site over the years. This unfortunately has given wings to their owners and senior members who beleive they have an almighty power to control anything a junior/new member says.
StackOverFlow is utilizing an interesting strategy to maintain their site at ZERO cost. They have introduced a points system according to which people with more points get the almighty power.
And the most stupid thing is that they give “MORE” points when someone “EDIT” or “CRITICIZE” someone else s comment/opinion.
This has made a massive circle of so-called “senior” guys who will find something in a relatively “junior” persons post.
Basically, if you are new to the site, your post will be “EDITED” so many times since you publish it.
Don’t get me wrong this DOES NOT mean that those senior guys give you a solution. Oh No!
All they do is “EDIT” your post!
They will find something, a spelling mistake most of the time.
They are also good at finding a similar post and then criticize your post saying it’s a “DUPLICATE”
The most funny thing is that you cannot even complaint!
Because guess who edit complaint forum? Yeah the SAME SENIOR GUYS
read more about my experience below…
It is very unprofessional to go and edit someones’s post unless they have misused the site.
Every time I submit a question, the first thing that happen is some “superior” guy delete a word or two TO GET HIS/HER NAME IN THE POST.
IT’S VERY CLEAR THAT PEOPLE DO THIS TO GET THEIR NAME EVERYWHERE.
What’s wrong with saying thanks to other professionals for spending their time to consider my matter?
The usual answer for this is that deleting “Hi” and “Thanks” makes the question “Clear”
Seriously? How can deleting most human friendly one or two words from a post and adding a comment to justify that act can make the post “clearer”???
It only makes IT pros look like “geeks” I’m sorry but not all professionals are “geeks” there are people who knows how to have a balanced life.
Perhaps if you guys stop editing others “Thanks” out may be you can have one too.
Many thanks for your time.
p.s. Now, if you can, tell me how my first “Hello” and last “thanks” lines made this post “unclear”?
I CHALLENGE SUCH “SUPERIOR” EDITORS TO RESPECT MY OPINION AND ANSWER THIS RATHER THAN DELETING (OR TOUCHING) THIS POST
Thanks again. (“You can chose to be a geek but you were born human” – a quote)
How to avoid detecting substrings, how to check for perfect substrings, avoid detecting substrings, avoid detecting substrings when checked for substrings.
Today I needed to find if a string is contained within a string.
So I used the most straight forward method (I used SQL but this works for any language)
declare @msgsToSkip varchar(max) = ‘geoLocation,statusUpdateCheck,forceClose';
declare @msg varchar(max)= ‘statusUpdate’
if(charindex(@msg, @msgsToSkip) > 0)
print ‘not found’
Problem – as you can see, this code is written to messages with caption as either “geoLocation”, “statusUpdateCheck”, or “forcedClose”
But I also receive a message with caption “statusUpdate” this is different to “statusUpdateCheck” and must be allowed but obviously the code returns true for statusUpdate as it is a substring of statusUpdateCheck.
Simply make each word dirty by adding a character to it. It could be any character as long as you keep the code consistent. In more simple words, simply add a character to the string you are
Looking For and the string you are Searching In.
This is the fixed code
declare @msgsToSkip varchar(max) = ‘geoLocation-,statusUpdateCheck-,forceClose-‘; — <– Notice that a ‘-‘ is added to make each word dirty
declare @msg varchar(max)= ‘statusUpdate’
if(charindex(@msg + ‘-‘, @msgsToSkip) > 0) — <- Notice the + ‘-‘
print ‘not found’
This will not detect statusUpdate as statusUpdateCheck because at the checking time, the code sees statusUpdate as statusUpdate- and it is not a substring of statusUpdateCheck (note that statusUpdateCheck is now statusUpdateCheck- but it’s the ‘-‘ in the statusUpdate that does the trick.)