MySQL Query Browser variable assignment problem solved!

If anyone out there is wondering why they’re getting NULL results when trying to set a variable using MySQL Query Browser, I think I’ve found the answer.
Let’s take the example statements below:

set @tmp=5;
select @tmp;

Query and result in query browser screenshot.
If you run them in the query browser, the second one (select @tmp;) will execute but will give you NULL as a result – whereas if you run that in the MySQL command prompt, you’ll get "5" returned as expected.
Query and result in MySQL command line screenshot.
The solution?  It’s a simple one – just click the start transaction button:
Start transaction button.
According to this post in the MySQL forum, it sounds like this is due to query browser closing the old connection and creating a new connection for each statement, thus erasing any variables set…

NetBeans web app deployment problem (to Apache Tomcat) solved!

If you get the following error in NetBeans when you try to deploy your web app to Apache Tomcat:
Access to Tomcat server has not been authorized. Set the correct username and password with the "manager" role in the Tomcat customizer in the Server Manager.
Try configuring the "tomcat-users.xml" file so the "manager" role is present – file should be in "%CATALINA_HOME%conf" (don’t forget to change the username and password!):

  <role rolename="manager"/>
  <role rolename="standard"/>
  <user username="mgr_usr" password="you_password_here" roles="standard,manager"/>

Then configure NetBeans to use the same credentials (Tools > Servers):
NetBeans Servers configuration dialogue
Then restart NetBeans and Tomcat – you should be good to go now!
It looks like the problem occurs if you install Tomcat separately from NetBeans.
Below is the article where I got the above from:
—- Update —-
2007-10-20 @ 07:35:
Article’s up on NetBeans Wiki:

Another Microsoft joke

Came across another Microsoft joke today while I was searching for if I should use "Log in" or "Log on" here:
Q: How many Microsoft techs does it take to change a light bulb?
A: None, they just make darkness an industry standard.

Evanescence – Good Enough (video)

If anyone’s interested, you can get the video to Evanescence’s new song "Good Enough" here:
The video looks quite good though I can’t say the same for the song…