>SELECT * FROM dual WHERE user = request.getRemoteUser()
>
>If this is possible what is the correct syntax?
you create a prepared statement, then fill in the variables with
values gleaned from java calls.
// With PreparedStatement, you leave ? where you come back later to
fill in the data.
// Update vendortimestamp field if the new value is bigger.
// Demonstrates use of the GREATEST function.
PreparedStatement stmt = conn.prepareStatement( "UPDATE vendors SET
vendorTimestamp=GREATEST(vendorTimestamp, ?), WHERE vendorId=?" );
stmt.setLong( 1, aPossiblyBiggerTimestamp );
stmt.setInt( 2, desiredVendorId );
stmt.executeUpdate();

Signature
Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.