heart dropped...

Think we all really need to sit down and discuss about this matter “Everybody busy”.

Actually I always think that we are helping each other. That’s why I never hesitate to request for your help.
Some more I was thinking to bring u into web biz; so I try to get more chances for u to get involved, to liaise with our clients.
Sorry that I didn’t realize that you are stuck with many tasks.
Just thinking abt the sales, and hope to invoice GP, and also clear PSNR earlier.

Frankly, this sentence “I got many many many technical jobs need to do” really stays in my heart since I received ur email, till now.
Just like when it is green light, but u forgot to let go the handbrake… everything halted… shocked & heart dropped…
he busy, u busy, me helpless during daytime… sigh :( oh~~ no~~

Anyway, if i m really bossy, I apologize.
Let’s look at the good side, and fight fight fight!!! We can make it!!!

Preserve Textarea Linebreak

Read in the forum regarding "how to preserve textarea linebreak" in PHP... I'm not a PHP programmer, I'm not sure. So.... searching online & found this method: nl2br()

I tried it out, and it is quite simple.

Have zipped it up for future reference~~ Might be useful.

oops...the previous script cannot handle DOUBLE QUOTE & SINGLE QUOTE.
Have added stripslashes() in order to cope for double quote & single quote.
Instead of nl2br(), we shd use nl2br(stripslashes($strText1)).

Auto iFrame Height

How can we detect the content (page) of iFrame, and set the height of the iFrame???
Take a look on this. It is pretty simple.

Anyway, few things to take note:
1. Parent page & child page must in from the same domain.
2. Must add the [class="autoHeight"] for the iFrame. *autoHeight.js will be checking on the existence of this class before resizing the height.

Already zip it here...

Backup/RestoreMySQL thru command

Below are mysqldump commands for backup and restore mysql database:

WINDOWS:
Backup:
C:\mysql\bin> mysqldump --opt --user=username --password database > dumbfile.sql

Restore:
C:\mysql\bin>mysql --user=username --password database < dumpfile.sql


UNIX / LINUX (never try this before...)
Backup:
mysqldump --opt --user=username --password database > dumbfile.sql

Restore:
mysqldump --opt --user=username --password database < dumbfile.sql

Notes:
- dumbfile.sql contains SQL command for creating tables and data. (CREATE,INSERT,DROP etc.)

Looking at this, you'll know we're much more...

What we're facing now... difficulties in works, family, money... are so minor comparing with them.

We have whatever we need, just fighting... struggling for something better & better... ashame when looking at this

Better html anchor, a jquery script to slide the scrollbar

Found a new feature for better html anchor link. Looks great!! Will try to try it out and apply in website in future...

Escape From <asp:image> Default CSS

How to get rid of ASP.NET default styling for asp:image??? Ppl says it is a [bug]... donno...
BTW, here is the workaround:

1. Create 2 classes

Public Class BorderlessImage
Inherits System.Web.UI.WebControls.Image
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property
End Class

Public Class BorderlessImageButton
Inherits System.Web.UI.WebControls.ImageButton
Public Overrides Property BorderWidth() As System.Web.UI.WebControls.Unit
Get
If MyBase.BorderWidth.IsEmpty Then
Return Unit.Pixel(0)
Else
Return MyBase.BorderWidth
End If
End Get
Set(ByVal value As System.Web.UI.WebControls.Unit)
MyBase.BorderWidth = value
End Set
End Property

2. Add into web.config

<system.web>
<pages>
<tagmapping>
<add mappedtagtype="BorderlessImage" tagtype="System.Web.UI.WebControls.Image">
<add mappedtagtype="BorderlessImageButton" tagtype="System.Web.UI.WebControls.ImageButton">
</pages>
</SYSTEM.WEB>

That's it. Done! Enjoy...

Oracle NVL Function

NVL function substitutes a value when a null value is encoutered.

Syntax	NVL( string1, replace_with )
string1	the string to test for a null value
replace_with	the value returned if string1 is null

Applies to: Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

Example #1:

select NVL(supplier_city, 'n/a')
from suppliers;

The SQL statement above would return 'n/a' if the supplier_city field contained a null value. Otherwise, it would return the supplier_city value.

Example #2:

select supplier_id,
NVL(supplier_desc, supplier_name)
from suppliers;

This SQL statement would return the supplier_name field if the supplier_desc contained a null value. Otherwise, it would return the supplier_desc.

Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats

just try to find a place to collect those downloads or tools that i found online... this is the first.