permaculture playing cards*
The moose likes JDBC and the fly likes I am not getting a sum for report in java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I am not getting a sum for report in java" Watch "I am not getting a sum for report in java" New topic
Author

I am not getting a sum for report in java

owaisee Akbar
Greenhorn

Joined: Jun 18, 2004
Posts: 1
I am writing a query in access which is running in access but when i run that in java it returns null value.


I also have a problem that how can i implement between clause with date.

Another one is that when i ask for date it is in it is in yyyy-mm-dd format i set date in dd-mm-yy format and short. but when i call it it shows first year than month and than day
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

Owaisee,
Welcome to Javaranch!

I strongly advise using a prepared statement for this query. Among other things, it allows the driver to handle date format issues.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
 
subject: I am not getting a sum for report in java
 
Similar Threads
conversion of date
Reading date from Excel Spreadsheet
How to convert String to Date
how to change the date,Time format after accessing it from the database
Formatting Date with Microsoft Access