July Code Blog

Tuesday, April 12, 2011

Resize image without distorting it

Author: xiaoyu | Posted at: 11:08 AM | Filed Under: CSS, html

Has anyone come across a problem where image is being distorted on a webpage?

Here is the simple CSS solution to display images without distorted.

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
  <style type="text/css">
    .imgresize {
      width: 100px;
      height: 150px;
    }
    .imgresize img {
      width: 100px; // to fix images by width, or
      // height: 150px; // to fix images by height
    }

  </style>

</head>

<body>

  <form id="form1" runat="server">

  </div>

  </form>

</body>

</html>

Note: You need to remove the height and width attribute value from img tag itself.

Reference link http://forums.asp.net/p/1514562/3619288.aspx

Sunday, August 22, 2010

"Strict standards : Non-static methods called statically" Error after Joomla Installation

Author: xiaoyu | Posted at: 12:12 PM | Filed Under: PHP

Recently I'm merely setting up a test site on localhost to check out Joomla features. After the installation, there are tons of Strict standards errors appear on my screen when I browse to Joomla homepage. I tried to reinstall several times but it still gave me the same errors.

Finally, I found something useful on Joomla! Discussion Forums.

To solve this issue, simply change the following configuration in your php.ini file.

Change error_reporting = E_ALL | E_STRICT to error_reporting = E_ALL & ~E_STRICT
Change display_errors = On to display_errors = Off

Remember to restart your Apache server after the changes. You should be able to view to Joomla! homepage now.

Friday, July 30, 2010

Resize Textbox/Textarea based on content length

Author: xiaoyu | Posted at: 9:45 AM | Filed Under: .NET, javascript

I was asked to implement resizing textbox based on content length in one of my projects, to avoid having to deal with scroll bars.

And here is the code that works for me:

<html>
<head>
<script>
function textAreaResize(o) {
     o.style.height = "1px";
     o.style.height = (25+o.scrollHeight)+"px";
}
</script>
</head>
<body>
<textarea id="textArea1" onkeyup="textAreaResize(this)" style="overflow:hidden"></textarea>
<asp:textbox id="txt1" runat="server" Width="500px" Height="25px" TextMode="MultiLine" onkeyup="textAreaResize(this);"></asp:textbox>
</body>
</html>

Anyway, I found out that this method is works for me only when I type my text in the box.

It is not working when I having no focus on the textbox and call the textAreaResize method to resize it. Position the cursor at the end of the text will resolve the issue.

Try the following code to your page.

<html>
<head>
<script>
function textAreaResize(o) {
     SetCursorToTextEnd(o.id); 
     o.style.height = "1px";
     o.style.height = (25+o.scrollHeight)+"px";
}

function SetCursorToTextEnd(textControlID)
{
  var text = document.getElementById(textControlID);
  if (text != null && text.value.length > 0) {
    if (text.createTextRange) {
                      var FieldRange = text.createTextRange();
                     FieldRange.moveStart('character', text.value.length);
                     FieldRange.collapse();
                     FieldRange.select();
    }
  }
}
</script>
</head>
</html>

Call the textAreaResize method on your page load will do.

Hope it works for you too. =)

Wednesday, June 2, 2010

Update Query with a JOIN Statement

Author: xiaoyu | Posted at: 10:54 AM | Filed Under: sql server

I found something useful when I am trying to update columns in a master table (tbl1) from data in a temp table (tbl2). These updates can be done by making a query to update a table by doing INNER JOIN.

Below is the example of a joined update query:

UPDATE tbl1
SET field_name = B.field_name
FROM tbl1 A
INNER JOIN tbl2 B
ON A.ID = B.ID

Hope this helps.

Tuesday, December 29, 2009

Generate random rows with SQL

Author: xiaoyu | Posted at: 3:59 PM | Filed Under: ms access, my sql, oracle, sql server

The secret to retrieve random rows from database is really simple. Here are some example SQL statements that do not require additional application logic.

SQL Server:
SELECT TOP 1 *
FROM Users
ORDER BY NEWID()

MySQL:
SELECT * FROM Users
ORDER BY RAND()
LIMIT 1;

Oracle:
SELECT * FROM
(SELECT * FROM Users
ORDER BY dbms_random.value )
WHERE rownum = 1

PostgreSQL:
SELECT * FROM Users
ORDER BY RANDOM()
LIMIT 1

Access:
SELECT TOP 1 *
FROM Users
ORDER BY Rnd(UserID)

Cheers!

Friday, October 9, 2009

InvalidOperationException: Cross-thread operation not valid: Control ‘Form1’ accessed from a thread other than the thread it was created on.

Author: xiaoyu | Posted at: 10:40 AM | Filed Under: .NET

When I first time met with this error, it was caused by an update of a windows form control from a separate thread.

Here is the workaround.

// delegation to cross the thread boundary
private delegate void AddComboBoxItemDelegate(object item);

private void AddComboBoxItem(object item)
{
  if (this.comboBox1.InvokeRequired) {
    // Invoke delegate so that the main UI thread is able to update the controls in the form
this.comboBox1.Invoke(new AddComboBoxItemDelegate(this.AddComboBoxItem), item);
  }
  else {
    this.comboBox1.Items.Add(item);
  }
}

Hope this helps. Cheers!