Programming Tips and Tricks

[chunliangchan-blog]

[chunliangchan-blog]

Quick method for converting rows into columns in MySQL

[chunliangchan-blog]

Reset MySQL password

http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html#resetting-permissions-generic

Remember to use mysqld_safe (and not mysqld) to start the mysql server with the --skip-grant-tables option.

[chunliangchan-blog]

Calculate Age in MySQL

Taken from here:

http://ma.tt/2003/12/calculate-age-in-mysql/

SELECT DATE_FORMAT(NOW(), '%Y') - DATE_FORMAT(dob, '%Y') - (DATE_FORMAT(NOW(), '00-%m-%d') < DATE_FORMAT(dob, '00-%m-%d')) AS ` age`

change NOW() to the start date at which we want to calculate the age from.

[chunliangchan-blog]

Number of displayed rows in spark DropDownList

The Flex Spark DropDownList component displays only 5 items before a scroll bar appears. To increase the default number of items that would be displayed without a scroll bar, do this:

  <s:DropDownList id="myDropDownList">         <s:layout>             <s:VerticalLayout gap="0"                     horizontalAlign="contentJustify"                     requestedRowCount="10" />         </s:layout> 

The key here is the requestedRowCount value. See this link for more details.

[chunliangchan-blog]

[chunliangchan-blog]

https for Flex and Zend_amf

Use on applicationComplete handler

protected function applicationCompleteHandler(event:FlexEvent):void

{

if(URLUtil.getServerName(root.loaderInfo.url) == "localhost"){

//if debugging on localhost, let the endpoint default to http

} else {

//when in production mode, manually set endpoint to secure https

myPhpService.endpoint = "https://blah.com/gateway.php"

}

}

[chunliangchan-blog]

Cantonese Fonts

http://cerg1.ugc.edu.hk/cergprod/static/download_font.jsp

(GRF Chinese Font)

or, if you have MS Office 2011 installed, could also use "MingLiU_HKSCS"

[chunliangchan-blog]

Using special characters in a label in Flex

http://blog.flexexamples.com/2007/08/02/using-special-characters-in-your-flex-applications/

<s:Label text="Hello #&0038; goodbye"/>

--> displays as "Hello & goodbye"

[chunliangchan-blog]

Generate Dummy Data

http://www.generatedata.com/#generator

[chunliangchan-blog]

Recover Data from Lost Partitions

http://sourceforge.net/projects/gparted/files/

[chunliangchan-blog]

DVD spanning

http://photography.sergeant.org/dvdspanner/

[chunliangchan-blog]

Auto Scroll in Flex

Auto Scrolling in Flex using the fractionOfElementInView property of a layout.

<?xml version="1.0" encoding="utf-8"?>

<!-- http://blog.flexexamples.com/2009/11/02/auto-scrolling-the-contents-of-a-vgroup-container-in-flex-4/ -->

<s:Application name="Spark_VerticalLayout_getScrollPositionDeltaToElement_test"

        xmlns:fx="http://ns.adobe.com/mxml/2009"

        xmlns:s="library://ns.adobe.com/flex/spark">

    <fx:Script>

        <![CDATA[

            import mx.core.IVisualElement;

            import spark.layouts.VerticalLayout;

            protected function textinput_focusInHandler(evt:FocusEvent):void {

                var idx:int = vg.getElementIndex(evt.currentTarget as IVisualElement);

                var lay:VerticalLayout = vg.layout as VerticalLayout;

                if (lay.fractionOfElementInView(idx) < 1) {

                    lay.verticalScrollPosition += lay.getScrollPositionDeltaToElement(idx).y;

                }

            }

        ]]>

    </fx:Script>

    <s:Scroller id="scrllr"

            focusEnabled="false"

            hasFocusableChildren="true"

            height="100"

            horizontalCenter="0" verticalCenter="0">

        <s:VGroup id="vg"

                paddingLeft="10" paddingRight="10" paddingTop="10" paddingBottom="10">

            <s:TextInput text="One" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Two" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Three" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Four" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Five" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Six" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Seven" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Eight" focusIn="textinput_focusInHandler(event);" />

            <s:TextInput text="Nine" focusIn="textinput_focusInHandler(event);" />

        </s:VGroup>

    </s:Scroller>

</s:Application>

[chunliangchan-blog]

Flex DropDownMenu without vertical scrollbar

If we want all items to pop open when a Flex drop down menu is activated, use a custom skin class that is a copy of the DropDownList component, and then remove the "maxHeight" property in modify line 114. 

Apply this custom skin to a drop down menus and it will force the menu to display all items when selected.

(ref: http://blog.flexexamples.com/2010/02/10/displaying-all-items-in-a-spark-dropdownlist-control-drop-down-menu-in-flex-4/)

[chunliangchan-blog]

NTFS-3G Write to Windows NTFS drive from Mac OSX

http://macntfs-3g.blogspot.com/2010/10/ntfs-3g-for-mac-os-x-2010102.html

[chunliangchan-blog]

Mysqldump with database with large number of tables

just add --skip-lock-tables to the mysqldump command.

(ref: http://bugs.mysql.com/bug.php?id=26026)

[chunliangchan-blog]

Configuring Time Capsule to work with Campus Network

http://www.utexas.edu/its/support/topics/timecapsule.php