(Jan Križan) I like recursion! It is pure and formal. When you solve problems using recursion you code look cleaner & leaner & meaner! But problem with recursion is that it is hard to imagine it.
Other News
DropDownList in the GridView – Keeping asp.net forms control in GridView
(SheoNarayan) In this article, I have described the ways of keeping DropDownList in the GridView and binding the data by preserving the default SelectedValue. Apart from DropDownList, I have also shown how to keep CheckBox, RadioButtonList, TextBox in the GridView and preserving the default data.
inline SQL pL vs compiled SQL PL (Part1)
(Serge Rielau) Over the years DB2’s SQL Procedure Langiage (SQL PL) has taken on a more and more prominent role and those who know how to use it properly can do some amazing things.
Oracle Legacy Workaround
(Michael McLaughlin) We had a discussion today about how you can manage legacy code that you can’t change. For example, how do you access a PL/SQL function in PHP that returns a PL/SQL table of record structures? PL/SQL tables, index-by tables, or associate arrays are one in the same dependent on th
TechTip: JD Edwards Reporting Made Easy!
(Robert Andrews) In my last TechTip, "How’d You Get Your SQL Server Data in My IBM i DB2 Data!?!," I explained how we could integrate Microsoft SQL Server data into the drag-and-drop world of DB2 Web Query reporting. In this TechTip, I will discuss how to integrate data from Oracle’s JD Edwards line
SELECT Statement is Fast, INSERT INTO Using the SELECT Statement is Brutally Slow 1
(Charles Hooper) I am impressed with the responses that were received from the most recent set of blog articles. I recently encountered an interesting problem with an Oracle database that had the OPTIMIZER_FEATURES_ENABLE parameter set to 10.1.0.4 and the OPTIMIZER_MODE set to ALL_ROWS. A somewhat
Twitter like character counter – jQuery version
(Bipin Joshi) My recent article titled Displaying a Character Counter for Multiline Textboxes shows you how to create a character counter like Twitter for multiline textboxes. The articles does so using ASP.NET AJAX client behavior. Here is a jQuery version of the code that does similar job. Note, h
MySQL logon and logoff trigger for auditing
(Shinguz) A while ago I did some research about MySQL audit functionality and logon a and logoff triggers. MySQL and MariaDB provide a logon trigger in the form of the init_connect variable but no logoff trigger where most of the work for auditing would be done. When we would have a logoff trigger w
Discarding Dependencies
(Karl E. Peterson) The world’s gone mad, it seems sometimes, with security concerns. Every time you turn on the radio, look at a newspaper, or can’t avoid listening to a politician, you will to read or hear all about all the latest threat(s) you really ought to be scared of.
SQL SERVER – Server Side Paging in SQL Server 2011 – A Better Alternative
(Pinalkumar Dave) Ranking has improvement considerably from SQL Server 2000 to SQL Server 2005/2008 to SQL Server 2011.