Let's Us Share What We Know


We are Happy Share Our Knowledge

Script to change case of mysql tables


Here is  an SQL script that renames all tables in a mysql schema schema to its lower case form.

select concat('rename table ', table_name, ' to  temp' , ';','rename table temp to  ',  lower(table_name), ';' ) from information_schema.tables where table_schema = 'your-schema';
The above script generates SQL statements (which you can copy-paste) that will help you to change case of table names to lower....

Bookmarklet to test your pages in different screen resolutions


Today, we are publishing few bookmarklets which will help you to test your pages in different screen resolutions from same browser window. Just drag the required links from below list to your browser toolbar and start testing. After opening the page, click on the required bookmarklet to open the page in a new window with the required dimensions.

Calling a COM component directly from C#


This post title could be using SMTPsvg.Mailer component in c# code too:-). Recently, we had to call a COM component from C# code. The COM component in question was SMTPsvg.Mailer. Sample code in classic ASP was available. The easiest way to do this method is using Interop. But we were not in a situation to generate interop libraries. We also learned this could have been easier had we used instead of c#. On further investigation we found two links that helped us to sol...

Customizing JOMRES Booking Component


We recently worked with JOMRES , a hotel booking component for Joomla. We implemented following major changes to the core set of features. Showing count of rooms by room type in Front End administration, especially in micro managed mode. This helped the client to easily add or remove number of rooms at will depending on demand. Customize “Form” Gateway, Modify available card types and add Luhn10 validation on credit card numbers Show room type names and count in gues...

White space is good!


The graphic design term whitespace (or negative space) literally refers to any area of a page that’s not covered by type or illustrations. While many novice web designers (and most clients) feel a need to fill every inch of a web page with photos, text, tables, and data, having empty space on a page is every bit as important as having content. Without carefully planned whitespace, a design will feel closed in, like a crowded room. Whitespace helps a design to “breathe” ...

JQuery Accordion refresh issue


If you have trouble viewing your jquery accordion menu, (some part not showing), ensure that you have set autoheight:true, while initializing the accordion. Example: jQuery(‘#menu’).accordion({ autoheight: false });...