July Code Blog

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!

Wednesday, September 16, 2009

Shrinking Transaction Log File in SQL SERVER

Author: xiaoyu | Posted at: 12:10 PM | Filed Under: sql server

Sometimes it is necessary to shrink a transaction log in a database manually if the log file grows unexpectedly in order to save some disk space.

Here are the steps use to truncate transaction log in a database:

BACKUP LOG <databasename> TO DISK = '<backupfile>'
DBCC SHRINKFILE (<filename>, <targetsize>) WITH NO_INFOMSGS

e.g.:

BACKUP LOG NORTHWND TO DISK = 'C:\NorthwindLog.bak'
DBCC SHRINKFILE (Northwind_log, 100) WITH NO_INFOMSGS

To check your logical file name of your log file, you can run the query as below to get the logical file name something like 'xxx_log':
sp_helpdb '<databasename>'

More information:
http://msdn.microsoft.com/en-us/library/ms189493.aspx
http://support.microsoft.com/kb/907511