Tech Sharing Blog

HeartRails Capture is a free web service tools for you to save and capture the web site as PDF. Just go to the HeartRails Capture web site and enter the URL address to capture. HeartRails Capture will auto capture the snapshot of the web site then generate the PDF for you.

PDF file created URL will be displayed for the tags to embed or blog.HeartRails Capture is a free web service tools for you to save and capture the web site as PDF. Just go to the HeartRails Capture web site and enter the URL address to capture. HeartRails Capture will auto capture the snapshot of the web site then generate the PDF for you.

PDF file created URL will be displayed for the tags to embed or blog.

Click here for sample TechSharing PDF
Click here to go to HeartRails Captures home page

Enter the web site URL to generate the snapshot

PDF generated from the URL anter

More From david_cheong

• PicReflect – Reflect your image online
• Primo Online – Free online PDF convertor
• Online PDF to Doc convertor

david_cheong Recommends

• Learn how to play Violin For Beginners  (Abba Piano Tuning)
• How to download files from web directly to your Dropbox | Computechgadgets.com  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

Tech.david-cheong.com is giving out the 10% dicount coupon for all the reader. You may redeem this discount coupon when you purchase any of the laptop sleeve from EC-Lifestyle.com

How to use this discount code:

1. Go to EC-Lifestyle
2. Select the product you wish to buy
3. Register and check out the product
4. Confirm your shipping address and enter the the following discount code: 38147e19d3
5. Select the payment type either using Paypal or local bank payment
6. Click continue to proceed and you will get you updated total amount to checkout
7. Confirm the total amount and proceed to the payment gateway for the payment
8. Get your confirmation after payment
9. The product will be ship on the next working day after the payment done 

Enter the discount code when come to the payment page and select the payment type

You will see the updated price on the next page after you enter the discount code

More From david_cheong

• PicReflect – Reflect your image online
• 500 Free Flash game for download
• Get the latest sport result for all the major league in the world.

david_cheong Recommends

• Get free 6 months license for Avira Premium Security Suite 10  (Sathiya seelan)
• Skype to acquire GroupMe for $85 million  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

I created a table to display a link which consist of a long verification code plus some variable to pass to the web site. There is no any space within the long url and query string. This is not the problem, the problem is on my table, because of the link is in one long string without any space, so when it display on the screen, the table is expanded.

I come across few solution, some people suggest that using the javascript to split the string in to 2 or more row when it excess the string lenght limit. I don’t think this is the best solution, and finally get the solution of control the table using the CSS.

WORD-BREAK:BREAK-ALL;

Syntax:

<table style=”word-wrap: break-word;” width=100>
     <tr>
          <td>long_long_long_long_long_long_long_long_long_long_long_long_long_long_long_long_string</td>
    </tr>
</table>

More From david_cheong

• PicReflect – Reflect your image online
• ISNULL, NULLIF MsSQL function
• Copy data and update table in MsSQL 2000

david_cheong Recommends

• Improved features in Windows 8 – Preview  (Sathiya seelan)
• Facebook adds more privacy and sharing related features  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

Picasa now allow you to upload the photo in the new way by using email. You may get your photo on your Picasa web album by just sending the photo to to a secret email address, especially useful when you try to upload the photo from your mobile device.

This allows you to stream and caption photos on-the-go.

To get started, follow these steps:

• Sign in to your Picasa account
• Click on the Settings link on the top-right corner
• On the General tabs, go to “Upload photos by email” section and check the “Allow me to upload photos by email.”
• Enter the “secret word” with lenght between 6-15 characters. As you enter  this word, an email address appears.
• Click the “Save Change” button
• Upload your email by attach them to an email message and send it to the newly-created address

Use the email ‘Subject‘ line to add captions or to include the photos in a specific album. If the email ‘Subject’ line matches an existing online album title, your photos will be uploaded to that album. Otherwise the ‘Subject’ line will instead be added as a caption and the photos will be placed in the Drop Box album.

Take note that you can only attach up to 20 MB of photos in JPG, GIF and PNG formats.

Enabled mail upload function in your Picasa Web Album settings

Try uploading the photo from email to Picasa web albumCheck out the newly uploaded photo using email post

Check out the newly uploaded photo using email post

More From david_cheong

• PicReflect – Reflect your image online
• Picasa Name Tag
• Add your location to your Gmail signature

david_cheong Recommends

• Learn how to play Violin For Beginners  (Abba Piano Tuning)
• Digital Piano Buyer’s Guide – How to Choose  (Abba Piano Tuning)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

Few days back, when I try to log into my Google Analytics to check my blog status, I’m suprise that my blog is not being tracking after I change to the new Masagana WP Theme. After try out few way including deactivate and activate back the analytics plugin, reinstall the plugin, but still no luck to make it work.

I try to google and finally found out that that’s not only my self have this problem, there are a lot of people who using the same blog with me also having the same problem.

I came across a post which highlights the solution to fix this issue.What has caused this issue is that a function has missing or left out from the theme which prevents WP Stats and Google Analytics from working. Apparently, the theme owner has forgotten to insert the function. To fix this issue, you need to edit the footer.php in your theme editor. From your WordPress’s admin panel, navigate to Design > Theme Editor > footer.php.

In the footer.php, just add the following code intot it, I believe the new downloaded Masagana WP Theme footer being encrypted, so just insert the code before the encrypted code to make it work.

<?php wp_footer(); ?>

Once done, update the file. WP Stats and Google Analytics should be working by now.

More From david_cheong

• Google Reader – Free online feed reader
• ChromePass – Recover Stored Password from Google Chrome
• Google search features in Gmail

david_cheong Recommends

• Jumping rope  (Sportize.me)
• Account Suspended  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don’t know what to do next. Or maybe you simply want to know of some design guidelines for solutions using SQL Server and designing Database Access Layers (DAL): this article is for you.

More From david_cheong

• Proxy Server and browser configuration
• Advance SQL Injection
• Import the server or CA certification in coldfusion server

david_cheong Recommends

• Digital Piano Buyer’s Guide – How to Choose  (Abba Piano Tuning)
• Stop dieting and start living  (Sportize.me)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

After few years of search engine being monopoly by Google, Microsoft has announced their new counter weapons toward Google – called Bing.com

This is just a begining for the search engine war. Now come to another part of the new search engine where all the webmaster or the blog owner should do – get your site to index by the new search engine and gain the traffic from Bing

Click here to submit your website to Bing and get’s index by Bing, so that your website can be found.

Besides that, Bing also has the webmaster tools like the Google webmaster tools. Click here to create a web master center account to submit your site and get index and explore to the search engine faster

Bing home page

More From david_cheong

• PicReflect – Reflect your image online
• 8 ways to help Google News to crawl your site better
• Convert web site to PDF

david_cheong Recommends

• How to customize your Google+ profile URL  (Sathiya seelan)
• How to extend your iPhone’s battery life  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 2% [?]

There are a lot of web site attacking method now a days, one of the most attacking method that we can easily found is the SQL Injection.

First of all, before you know about the SQL Injection, you may need to know what is SQL. Structured Query Language (‘SQL’) is a textual language used to interact with relational databases.

There are many varieties of SQL; most dialects that are in common use at the moment are loosely based around SQL-92, the most recent ANSI standard. The typical unit of execution of SQL is the ‘query’, which is a collection of statements that typically return a single ‘result set’. SQL statements can modify the structure of databases (using Data Definition Language statements, or ‘DDL’) and manipulate the contents of databases (using Data Manipulation Language statements, or ‘DML’). In this paper, we will be specifically discussing Transact-SQL, the dialect of SQL used by Microsoft SQL Server.

SQL Injection occurs when an attacker is able to insert a series of SQL statement into a ‘query’ by manipulating data input into an application.

The attacker may use the try and error method to study the database table structure and may inject the statement either to read, delete, edit your data in database or more  dangerous is they may take control ovre your database server.

The following PDF file explain the SQL injection in more detail, you may download, study and understanding the most common SQL Injection technique use by the attacker.

More From david_cheong

• Possible injection use keyword
• Insert multiple record into table
• T-SQL: Concatenate something + null=null

david_cheong Recommends

• How to extend your iPhone’s battery life  (Sathiya seelan)
• Facebook adds more privacy and sharing related features  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

Trim is a good features when you try to delete the space at the left most, right most or both the left most and right most of the string. The following trim function is ultilize the javascript Regular expression for the trim function

Left Trim

function ltrim(str){

    return str.replace(/^\s+/, ”);

}

Right Trim

function rtrim(str) {

    return str.replace(/\s+$/, ”);

}

All trim

function alltrim(str) {

    return str.replace(/^\s+|\s+$/g, ”);

}

More From david_cheong

• Home make iPad2 protector
• ISNULL, NULLIF MsSQL function
• Progress and Revolution

david_cheong Recommends

• Improved features in Windows 8 – Preview  (Sathiya seelan)
• How to fit more than a thousand words into a tweet  (Sathiya seelan)

Ask david_cheong To Recommend Your Posts

Popularity: 1% [?]

I try to google, call, msn my friend to find out the solution when I stay back in my office until late night yesterday. But still no luck after few hours of trying.

Thinking of gave up when back to office this morning, but one of my friend suddently send me the solution via MSN. That’s the best present I received by today. I’m not sure how many people will looking for this kind of solution, but any way, will post here to share with all and you may take it if you need it.

Basically the idea is that you put all your select, update or delete statment into the variable and use the execute command to execute the whole variable.

My problem:

I have a formula store in a table which is A+B*C+D. My A = 1, B=2, C=3, D=4.

I managed to replace all my variable with the integer using cursor (This maybe not a good solution, but this is not the main discussion in this post)

The finally answer I get is 1+2*3+4. But the bad thing is in the varchar datatype. I only manage to disply 1+2*3+4 but not the answer of 11.

The solution as below:

Declare @MathFomula Varchar(100)

Set @MathFormula = ’1+2*3+4′

Exec(‘SELECT ‘ + @MathFormula  + ‘ AS Result’

Output: 11

* Remember that * and / will calculate at first before + and -

More From david_cheong

• ISNULL, NULLIF MsSQL function
• ChromePass – Recover Stored Password from Google Chrome
• Google FAIL in math

david_cheong Recommends

• Facebook adds more privacy and sharing related features  (Sathiya seelan)
• Jumping rope  (Sportize.me)

Ask david_cheong To Recommend Your Posts

Popularity: 3% [?]