Myself and another person have given you very good explanations about how to do
this. Either you're ignoring those for some reason or this is really beyond
your capability. You should consider hiring a professional.
Sent from my iPad
> On Nov 3, 2015, at 11:43 PM, Bob M
If you're using JDBC, you would use a prepared statement. This isn't
exact, but something like:
PreparedStatement ps=conn.prepareStatement("select * from table where
field1=? and field2=?");
ps.setString(1,variable1);
ps.setString(2,variable2);
ResultSet rs=ps.executeQuery();
while
I am using the following code:-
rs = s.executeQuery("SELECT Field1, Field2, Field3, Field4 FROM XX "
+ "WHERE Field1 LIKE String1 AND Field2 LIKE String2 AND Field3 LIKE
String3 AND Field4 LIKE String4 "
+ "GROUP BY Field1, Field2, Field3, Field4");
XX - table name
Field1 thru
On 11/3/2015 3:35 PM, Bob M wrote:
I am using the following code:-
rs = s.executeQuery("SELECT Field1, Field2, Field3, Field4 FROM XX "
+ "WHERE Field1 LIKE String1 AND Field2 LIKE String2 AND Field3 LIKE
String3 AND Field4 LIKE String4 "
+ "GROUP BY Field1, Field2, Field3,
string1 thru string4 are VARCHAR variables
In my particular case each of the strings can be either"Up" or "Down" but
their values vary each time my program runs which is every 6
hours..
Sorry for being a bit slow, but I am still unclear as to how to ask for a
subset of the