2009年7月24日 星期五
Tabbed Remote Desktop
A tabbed viewer with RDP(Windows Remote Desktop), VNC, ...etc, like firefox to manager multiple remote desktop simultaneously.
Terminals
http://www.codeplex.com/Terminals/Release/ProjectReleases.aspx?ReleaseId=21809
http://www.howtogeek.com/howto/windows/tabbed-remote-desktop-vnc-client-for-windows/
XwRDP
http://xwega.com/tools/xwrdp/xwrdpimg.aspx
2009年7月23日 星期四
2009年7月21日 星期二
Retrieving Auto Generated Key from DB
Set oConn.Execute("INSERT INTO yourTable (field1, field2) VALUES ('Hello','World');")
Set oRs = oConn.Execute("SELECT @@IDENTITY FROM yourTable")
iAutoGeneratedID = oRs(0)
----
Set rs = dbCon.Execute(strSQL)
Dim newID
newID = rs.Fields("NewID").value
2009年7月20日 星期一
Java: How To Get Auto Increment Values After SQL Insert
//
// Insert one row that will generate an AUTO INCREMENT
// key in the primary key field
//
stmt.executeUpdate(
"INSERT INTO autoIncTest (comment) "
+ "values ('How can I get the auto increment field value?')",
Statement.RETURN_GENERATED_KEYS);
//
// Use Statement.getGeneratedKeys()
// to retrieve the value(s)
//
訂閱:
文章 (Atom)