CALLABLE STATEMENT

What's for u a callable statment ? do you mean prepared statment or stored procedure (macros,...)

For a prepared statment the syntax looks like what follows :

Connection connection;//For connection

String psQuery = "select from where Create_Time <? and Create_Time >?";

PreparedStatement ps = connection.prepareStatement(psQuery);

ps.setDate(1,mydate);

ps.setDate(2,mydate);

ps.execute();//I'm not sure for this last one but it might be around that

HTH

STF

LearningSTF at 2007-6-29 0:45:07 >