Keyser's Knowledge Base

find & unzip recursively

2010-06-19T18:49:00.000+03:00

find . -name "*.zip" -exec unzip '{}' \;

JQuery onchange event

2009-12-02T15:33:00.002+02:00

("#textAreaId").change(function() {
//....
});

The onchange event only triggers after the textArea loose its focus. The solution is to use keyup event.

("#textAreaId").keyup(function() {
//....
});

MySQL drop constraints

2009-11-28T22:44:00.001+02:00

To see all constraints, look in information_schema.table_constraints.

In MySQL constraints are stored using indexes.

To remove a contstraint:

alter table [table_name] drop index [constraint_name]

javax.transaction:jta:jar:1.0.1B is not available in maven repos

2009-11-08T12:19:00.001+02:00

Credits : http://stigebil.wordpress.com/2008/06/03/javaxtransactionjtajar101b/

Download from here.

Install:

mvn install:install-file -Dfile=./jta-1_0_1B-classes.zip -DgroupId=javax.transaction \
-DartifactId=jta -Dversion=1.0.1B -Dpackaging=jar

javascript clear all children for an element

2009-09-15T17:55:00.002+03:00

function removeAllChildren(elem) {

if (elem.hasChildNodes())
{
while (elem.childNodes.length >= 1)
{
elem.removeChild(elem.firstChild);
}
}
}

smplayer VDPAU extra options

2009-04-26T01:29:00.002+03:00

-vf-clr screenshot

sqlserver 2005 start/stop from commandline

2009-01-30T11:20:00.002+02:00

net start mssqlserver
net stop mssqlserver

Fix broken avi in linux

2008-12-16T23:21:00.003+02:00

Mencoder/MPlayer will fix the indexes on broken files.

mencoder damaged_file.avi -idx -oac copy -ovc copy -o fixed_file.avi

-idx tells it to fix and rewrite the index
-oac is the audio codec to use (in this case just copy it as-is)
-ovc is the video codec to use (in this case just copy it as-is)

Source:
http://ubuntuforums.org/showthread.php?t=520880

ext3 partition check with progress

2008-12-01T13:17:00.002+02:00

e2fsck -v -C 0 /dev/sdb12

java run add jar in classpath

2008-11-09T01:24:00.004+02:00

java -cp /path/to/some.jar:/path/to/classes/root/ com.mypackage.MyClass

java compile with jar in classpath

2008-11-09T01:20:00.005+02:00

javac -cp /path/to/some.jar path/to/src/*.java

zip add to archive a folder

2008-11-09T01:15:00.006+02:00

zip -r archive_name.zip folder

IE form.action bug

2008-08-08T15:38:00.006+03:00

IE form.action change fail if there is an existing input hidden with name action
Conclusion: Never name any html element action.

maven cargo tomcat

2007-07-09T23:31:00.001+03:00

There's a maven plugin which can be used to start/stop/deploy on tomcat(other servlet containers supported)

Here's an example configuration:

 <plugin>
       <groupId>org.codehaus.cargo</groupId>
       <artifactId>cargo-maven2-plugin</artifactId>
       <configuration>
       <container>
         <containerId>tomcat5x</containerId>
         <home>/home/keyser/java/apache-tomcat-5.5.23</home>
         <log>/home/keyser/java/apache-tomcat-5.5.23/logs/catalina.out</log>
         <output>/home/keyser/java/apache-tomcat-5.5.23/logs/catalina.out</output>
         <append>true</append>
       </container>
       <configuration>
         <type>existing</type>
         <home>/home/keyser/java/apache-tomcat-5.5.23</home>
         <properties>
           <cargo.logging>"high"</cargo.logging>
           <cargo.jvmargs>"-Xmx500m" "-XX:PermSize=128m" "-XX:MaxPermSize=256m"</cargo.jvmargs>
         </properties>
       </configuration>
   </configuration>
     </plugin>