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

Reply via email to