This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Struts and the fly likes how to solve this Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "how to solve this" Watch "how to solve this" New topic
Author

how to solve this

Nujin jacob
Greenhorn

Joined: Nov 22, 2005
Posts: 2
test
contains
id, name,address,insertiondate.
1 aaa xxxxxx 01-11-2005
2 bbb xxxxxx 01-11-2005
3 ccc xxxxxx 02-11-2005
4 ddd xxxxxx 05-11-2005
5 eee xxxxxx 11-11-2005
6 ggg xxxxxx 15-11-2005
7 rrr xxxxxx 21-11-2005


in my jsp programm i wanted to list the records when the user entering the date range value
eg: when the user enter the date range is

DateFrom: 01-11-2005 DateTO: 20-11-2005

here i wanted to display these below records

1 aaa xxxxxx 01-11-2005
2 bbb xxxxxx 01-11-2005
3 ccc xxxxxx 02-11-2005
4 ddd xxxxxx 05-11-2005
5 eee xxxxxx 11-11-2005
6 ggg xxxxxx 15-11-2005

how can i write SQL query of this above?
please help me..........
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30138
    
150

Nujin,
Welcome to JavaRanch!

Using a prepared statement, you can do:


[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: how to solve this
 
Similar Threads
following::* doubt
How to split a string by the whitespace but ignoring '\n'?
Need help for using Iterator
Preceding siblings
Report in JSP