Pause app downloads and updates on the iPod Touch

Posted on July 5th, 2011 by admin

Did you know you can pause any application download or update on the iPhone and iPod Touch? This is great when you’re in a bandwidth bind or have low bars of reception. * Pause the download/update by just tapping on the app’s icon while the download is going * You’ll know the download is paused [...]

Why does my CHM have a blank content pane?

Posted on July 2nd, 2011 by admin

This is a relatively old problem now, but one that keeps popping up. You open a CHM but you don’t see your content in the right-hand pane of the HH window. You see a cryptic browser message “Navigation to the webpage was canceled” or “Action canceled”. This is due again to Microsoft plugging security holes in [...]

Crystal Report Database Login (VB .Net)

Posted on July 2nd, 2011 by admin

Creating a project in VB .Net and used Crystal Reports for Visual Studio 2008 for reporting purpose. Setup of the project wa made. Running setup on the dev system, the reports run smoothly but when running it on another computer reports displays Databes Login Dialog Box and requires username and password, even if login information [...]

String concatenation with MySQL

Posted on June 17th, 2011 by admin

MySQL has a number of string handling functions including functions to concatenate text or database columns into a single column in the resultset. This function is CONCAT and not CONCATENATE. Example data The example table used in this post is called “users” and contains the following data: #====#============#==========# | id | firstname  | lastname | [...]

Importing large files into mysql with phpmyadmin

Posted on June 14th, 2011 by admin

When importing a large database database (.sql) file and phpMyAdmin just show you this message How to go about it? The phpmyadmin documentation offers very little solutions.  Here’s the easiest method to overcome this: Find the config.inc.php file located in the phpmyadmin directory. In my case it is located here: C:\phpMyAdmin Create a directory called [...]

Troubleshooting the “Outlook prompts for password”

Posted on April 22nd, 2011 by admin

Every time you open Outlook 2007 you are prompted to enter your domain credentials ,even though you know you have saved it? To solve it try that one: Open the following path: In Vista or Windows 7 C:\Users\YourUserName\AppData\Roaming\Microsoft Once open you will see numerous folders including a “protect” folder. Delete the “protect” folder When you [...]

Returning an array in a PHP function

Posted on October 19th, 2010 by admin

A PHP function can return simple types such string, integer, float, boolean, etc., or a complex type such as array or object. The following sample PHP function will return an array: function getList() { $list = array( ‘one’, ‘two’, ‘three’ ); return $list; } To call the function: $mylist = getList();

Select a random row in MySQL table

Posted on October 19th, 2010 by admin

To select a random record in a MySql table enter the following SQL command: SELECT column FROM table ORDER BY RAND() LIMIT 1

Making 301 Redirect (Moved Permanently) with PHP

Posted on September 30th, 2010 by admin

Sometimes you encountered the need to redirect some PHP page to another page for whatever reason. The way to do it with PHP is by using the header function. You might do it like this: <?php header( “HTTP/1.1 301 Moved Permanently” ); header( “Location: http://www.codetidbits.com/foo.htm” ); ?>

Double Underline Text with CSS

Posted on September 29th, 2010 by admin

Trying to figure out how to double underline text using CSS? Here it is: <html> <head> <title>Double Underlined Text Example</title> <style type=”text/css”> .double_underline { border-bottom: 3px double; } </style> </head> <body> <span>Code Tid Bits in Double Underline</span> </body> </html> .double_underline { border-bottom: 3px double; } Code Tid Bits in Double Underline