Copy TOAD's Schema comparison sync script

TOAD does not allow you to copy the sync scripts created by it's schema comparison tool unless you shell out for the DBA Modules add in. All you can do is print it to a stupid xps file.

In order to get around this I created a small autoit script to copy the output to your clipboard.

Here is the code

Opt("WinTitleMatchMode", 1)

WinActivate("Toad for Oracle")

$Text=ControlGetText("Toad for Oracle","","[CLASS:TAdvToadSyntaxMemo; INSTANCE:1]")

ClipPut($Text)

If $Text Then 

   MsgBox(0,"pwnt","Copied to clip board")

Else

   MsgBox(0,"uh oh","Couldn't copy text. Has the schema comparison been run?")

EndIf

If need be, I might upload the compiled exe file.

I just received my first Arduino through the post. I went with the Arduino Duemilanove ATmega 328 which I bought on eBay from the seller arduino.hk who I can highly recommend. Their feedback speaks for itself.

I haven't had a chance to properly play around with it yet due to a house move but I will post something later on about it.

URemoteDesktop skipping 2 tracks on Rhythmbox

I downloaded an Android App called URemoteDesktop and when trying to skip a track on rhythmbox it skipped 2 instead of 1.

To fix this (Not sure if it buggers up something else so do this at your own risk), comment out the following lines in vd.sh.

xte "key XF86Back"
xte "key XF86Forward"

I'm guessing these are put in the if statement for programs that don't use XF86AudioPrev & XF86AudioNext.

Streaming video from Ubuntu to Xbox 360 via BT Home Hub

Before my PS3 shit a brick and I replaced it with a Xbox 360, I tried to get Mediatomb streaming video from my Ubuntu machine to my PS3. Although it worked to some extent, there seemed to be a buffering issue. Videos would play for a few minutes then stop to load up more of the video.

While trying to set up uShare I came across the same problem. The obvious constant here was my router so while dicking around with the settings of my BT Home Hub I managed to solve the problem.

Here's what I did.

1. Open the home hub's web page. The ip address should be 192.168.1.254.
2. Click on Basic Config.
3. Click on Wireless.
4. Under "Wireless channel" change Channel selection to "Manual" and Channel to "11".

That's it. Give it a minute then crank up uShare.

Using awk as a floor function

I was searching the internet trying to find out if awk had a floor function when I realised awk IS a floor function.

graham@graham-laptop:~$ x=3.5
graham@graham-laptop:~$ echo $x | awk -F. '{print $1}'
3
graham@graham-laptop:~$

You could always change $1 for $2 and it becomes a mod function.

Selecting beginning of financial year in Oracle

I recently had to work out how to return the beginning of the financial year from an Oracle database. After trawling the internet, everything looked rather complicated for what I was after.

Below is what I came up with. It's pretty simple to change. If April is not the month you want to return, change the +4 at the end to the number of the month you want to return.

select trunc(add_months(sysdate, - (12 + to_char(sysdate,'MM'))+4),'MM')
from dual

OpenSSH for windows not recognising rsa authentication

It appears there is a bug in OpenSSH running on windows where it will not allow public key authentication.

To fix this simply edit sshd_config file in the /etc/ directory and change the strict modes line to show as

StrictModes no

Hopefully this saves some of you time.