MR GS REARDON <[EMAIL PROTECTED]> writes: > Hello: > > I'm looking for documentation and examples on user input prompts in > a sql query.
Not sure I grok what you're saying here? Do you want to write SQL which reads input from a terminal, or window? The conventional way of doing this (with JDBC) is read your input in Java and then use it to set parameters in a PreparedStatement (or construct a statement if that's more appropriate). E.g. something like PreparedStatememt ps = conn.prepareStatement("SELECT * FROM T where i = ?"); int i = readInput(); ps.setInt(1,i); ps.executeQuery(); ... >I'd appreciate someone telling me where I can find this > information. Google for Java and JDBC tutorials. -- dt