Adventures of a Software Engineer

Month: April 2010

  • Quitsomething.com has been launched

    Finally I have launched quitsomething.com a website dedicated to helping quitting bad habits.

    The site is in its infancy stage so I assume there are bugs, also if you thing you like it please spread the word via Twitter, Facebook etc…

    Quitsomething.com Homepage
    Quitsomething.com Homepage

  • Show last executed query SQL Server – Disected

    I found this online, without explanation so I will dissect the query and explain what is happening.

    SELECT deqs.last_execution_time AS [Time], dest.TEXT AS [Query]
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

    This beautifully crafter query will show us last few queries executed on they db, very usefull for seeing what is Hibernate generating for us.

  • Including spaces/html entities in JSF component output.

    Rather a silly problem but a problem nevertheless, including html entities as spaces special charactes etc… causes them to be escaped by the jsf.

    So something like getSpacedName(){return "Hello   world";} will be outputed in the pages exactly as we have entered in out method above. On regulat h:outputText we can use ‘escape’ attribute and set it to false and get what we desire but with other components that output a dropdown or something where formating is in need thats not possible.

    Solution is to use the Unicode characters

    getSpacedName(){
  String space  = "\u00a0";
  return String.format("Hello%s%s%%sworld",space, space, space);
}

    I know that we should not be doing crazy things like this in our backingbeans but when you have to you have to.
    space_screen