Dimdim, Online Web Meeting

Have you ever heard the free online web meeting? Dimdim is a good one. With Dimdim free version, you can hold web meeting with up to 20 people. You can control who to share their desktop to give presentations. It is very useful. And it is interactive.

Need to hold a webmeeting, give dimdim a try. DimDim, It saves money and time. It save energy and reduce CO2 emissions.

Discover Card Direct Pay

Just found out the Discover Credit card offers the DirectPay service. This is very good news. From my previous blog, CitiCard offers the similar service that will automatically withdraw the money from your banking account to pay your credit card balance. Now Discover card offer the same service too.

I like this kind of serviced offered by Credit Card company. You will never have to worry about remembering the due date. No more late fees, no more missed payments, no more emergent telephone payments.

From Discover Card website, it says:

"DirectPay takes care of your Discover Card statement on time every month automatically for free. No more having to remember your payment due date, no more late fees and no more missed payments."

For more informaiton, visit discover credit card website. http://www.discovercard.com/

How to delete duplicate record in SQL Database

After you identify duplicate records in a table in SQL database, the next step is how to remove duplicate records.

One way to do this is to copy unique records into temporary table, then delete the original table and then copy the temporary table back.

The below is a web link about how to delete duplicate record.

Deleting Duplicate Records

If you have other ways to remove duplicate records, please share it by leaving comments.

Duplicate Record in SQL

How do you find duplicate records in a table in SQL database, here is a script

Select First_Name, Last_Name, Email, Phone, count(*)
from Table_ABC
having count(*) > 1
group by First_Name, Last_Name, Email, Phone

How to update record in a table based on values in another table

Update Table_ABC
set First_Name = (select FIRSTNAME from Table_BCD where Table_ABC.Email = Table_BCD.Email)
where exists (select FIRSTNAME from Table_BCD where Table_ABC.Email = Table_BCD.Email)

If the table_BCD have duplicate emails, you can pick the first one by using the following script.

Update Table_ABC
set First_Name = (select top(1) FIRSTNAME from Table_BCD where Table_ABC.Email = Table_BCD.Email)
where exists (select top(1) FIRSTNAME from Table_BCD where Table_ABC.Email = Table_BCD.Email)

I found these scripts are very useful.

HTML text editor - FCKeditor

have you ever used the HTML text editor "FCKeditor".



FCKeditor has a lot of features. From its website, it lists:

• Multi browser compatibility
• Outputs XHTML 1.0
• CSS support for better integration with your web site
• Font formatting: type, size, color, style, bold, italic, etc
• Text formatting: alignment, indentation, bullets list, etc
• Cut, Paste, and Paste as Plain Text, Undo and Redo
• Paste from Word cleanup with auto detection
• Link and anchors support
• Image insertion, with upload and server browsing support
• Table creation and editing (add, delete rows, etc) - one of the best systems on the market.
• Table cells editing (size, colors, etc)
• Form fields
• Right click context menus support

• Complete toolbar customization
• Skins support
• Plugins support
• Spell checker
• Multi-language support with automatic user language detection. Including Right to Left scripting.
• Complete page editing or just contents.
• Lightweight and fast
• Automatic browser detection and customization
• Integration with ASP, ASP.NET, Java, ColdFusion, Perl, PHP, JavaScript and more.
• Image and file links upload and server repository browser.
• For web developers it is easy to install and customize
• For web users it's simple and easy to use!

Private Posts for Blog

How can I keep some post private in my blog. I have this question because I would like to keep some posting just for learning, or note purpose.

Hopefully the Blogspot has this option so that i can set up what posts to share and what posts to keep private.

Xcopy Command

Do you know what Xcopy does in dos command? It is more powerful than the copy command. If you would like to copy all the files and sub-folders from one drive to another, you may need xcopy command. Of course, you can use windows explorer interface to do it. But if you would like to write batch file, and run from DOS command, Xcopy is very useful.

The below is an example listed from MicroSoft website:
------------------------------------------------------------------------

Examples

To copy all the files and subdirectories (including any empty subdirectories) from drive A to drive B, type:

xcopy a: b: /s /e

To include any system or hidden files in the previous example, add the/h command-line option as follows:

xcopy a: b: /s /e /h

-----------------------------------------------------------------------------

More information can be found on this webpage from MicroSoft Website.