What do you think...? MySQL Toad

Posted At : February 25, 2009 7:30 PM | Posted By : Ernst van der Linden
Related Categories: Software,Server Side

Please let me know if you think it's worth a try and if it's a good replacement for MySQL WorkBench (which contains more bugs after every update!)

Comments (6) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 1671 Views

WHOIS your Daddy?

Posted At : February 8, 2009 5:46 PM | Posted By : Ernst van der Linden
Related Categories: Coldfusion,Server Side

I was playing around with querying a whois server. Actually I didn't know it was that easy...

Here's the code:

<cffunction name="getWhoisData" access="public" returntype="string" hint="I return data from a whois server">
    <cfargument name="whoisQuery" type="string" required="true" hint="e.g. 'domain microsoft' or '?' to show whois server help-commands">
    <cfargument name="whoisServer" type="string" required="false" hint="e.g. whois.ripe.net. Default server is whois.internic.net">

    <cfscript>
        var whoisData = '';
        var whoisClient = createObject("java","org.apache.commons.net.WhoisClient");

        // use default whois server?
        if ( not isDefined("arguments.whoisServer") ){
            arguments.whoisServer = whoisClient.DEFAULT_HOST;
        }

        try {
            whoisClient.connect(arguments.whoisServer);
            whoisData = whoisClient.query(arguments.whoisQuery);
            whoisClient.disconnect();
        } catch (Any exception) {
            whoisData = exception.message;
        }

        return whoisData;
    </cfscript>
</cffunction>

Some examples:

<cfoutput>
    <h1>? [whois.internic.net]</h1>
    <pre>#getWhoisData('?')#</pre>
    <h1>domain microsoft.com [whois.internic.net]</h1>
    <pre>#getWhoisData('domain microsoft.com')#</pre>
    <h1>=microsoft.com [whois.internic.net]</h1>
    <pre>#getWhoisData('=microsoft.com')#</pre>
    <h1>registrar TUCOWS INC. [whois.internic.net]</h1>
    <pre>#getWhoisData('registrar TUCOWS INC.')#</pre>
    <h1>-G -B 192.113.224.88 [whois.ripe.net]</h1>
    <pre>#getWhoisData('-G -B 192.113.224.88','whois.ripe.net')#</pre>
</cfoutput>

Comments (2) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 899 Views

Ant + Subversion - How to list revision numbers

Posted At : September 22, 2008 10:52 PM | Posted By : Ernst van der Linden
Related Categories: Server Side

Today I needed a way to list all revision numbers of a repository.

I came up with the following solution:

Notes:
- svnant required;
- subversion called from command line.

<project name="buildexample" basedir="." default="svn.revisions">

    
    <import file="svnant.xml"/>

    
    <property name="tempDir" value="C:\\DATA\\TEMP\\${ant.project.name}" />

    
    <property name="svn.url" value="YOUR REPO URL HERE" />

    <target name="prepare">
        
<mkdir dir="${tempDir}" />
    </target>

    
    <target name="svn.revisions" description="Sets property: svn.revisions" depends="prepare">

        
        <exec executable="svn" outputproperty="svnlog.out" output="${tempDir}\\log.xml" >
            <arg line="log --xml -v ${svn.url}" />
        </exec>
        <xmlproperty file="${tempDir}\\log.xml" collapseattributes="true" />

        <property name="svn.revisions" value="${log.logentry.revision}" />

        <echo>${svn.revisions}</echo>

        <input message="Select Start Revision" validargs="${svn.revisions}" addproperty="svn.startRevision" />
        <input message="Select End Revision" validargs="${svn.revisions}" addproperty="svn.endRevision" />

    </target>

</project>

Please let me know if you think there's better way to list revision numbers.

Comments (0) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 724 Views