Finding record between 2 dates

Vaibhav Deshpande wrote:

I am very new to ruby on rails programming,
I am using the oracle as my database,

In my project there r 2 text box fields and in first and second text
boxes i want the date field to be enter by the client and want to
display the record between those 2 dates how can i do the same, plz be
more specific

I'm not sure if this is an issue or not, but note that Oracle's DATE
field is also used for storing DATETIME. Maybe the Rails Oracle adaptor
handles this properly, but I just wanted to mention it in case you see
weird behavior.

I am using the oracle as my database,

P. S. I wish my application could use "The Oracle" as its database. It
would always get the correct response even if it doesn't know what to
ask. :wink:

http://www.imdb.com/character/ch0000765/

Robert Walker wrote:

Vaibhav Deshpande wrote:

I am very new to ruby on rails programming,
I am using the oracle as my database,

In my project there r 2 text box fields and in first and second text
boxes i want the date field to be enter by the client and want to
display the record between those 2 dates how can i do the same, plz be
more specific

I'm not sure if this is an issue or not, but note that Oracle's DATE
field is also used for storing DATETIME. Maybe the Rails Oracle adaptor
handles this properly, but I just wanted to mention it in case you see
weird behavior.

I am using the oracle as my database,

P. S. I wish my application could use "The Oracle" as its database. It
would always get the correct response even if it doesn't know what to
ask. :wink:

http://www.imdb.com/character/ch0000765/

I used @date2ss = Date2.find(:all, :conditions => "ID > '"+ @date1 +"'
and ID <'"+ @date2+"'") and it works..
thanks,
Vaibhavi

I used @date2ss = Date2.find(:all, :conditions => "ID > '"+ @date1 +"'
and ID <'"+ @date2+"'") and it works..
thanks,
Vaibhavi
--

You can also use
Model.find(:all, :conditions => {:date => date1..date2})

Andrew Timberlake
http://ramblingsonrails.com
http://www.linkedin.com/in/andrewtimberlake

"I have never let my schooling interfere with my education" - Mark Twain

Andrew Timberlake wrote:

I used @date2ss = Date2.find(:all, :conditions => "ID > '"+ @date1 +"'
and ID <'"+ @date2+"'") and it works..
thanks,
Vaibhavi
--

You can also use
Model.find(:all, :conditions => {:date => date1..date2})

Andrew Timberlake
http://ramblingsonrails.com
http://www.linkedin.com/in/andrewtimberlake

"I have never let my schooling interfere with my education" - Mark Twain

Thanks,