Oracle :time field issue

Rails
1

What field type should I use to store time in oracle? I tried :time but
that actually creates a date field that doesn’t work with time_select,
it gives me the error “1 error(s) on assignment of multiparameter
attributes”.

Thanks,

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/

2

Greg D. wrote:

What field type should I use to store time in oracle? I tried :time but
that actually creates a date field that doesn’t work with time_select,
it gives me the error “1 error(s) on assignment of multiparameter
attributes”.

Thanks,

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/

i hope someone answers…i’ve got my oracle birthdate column defined as
Date if that helps plus here something i’ve found…<%=
Time.now.to_s(:db) %> interesting that it adds a another parameter to
String class .to_s (to string method) using the :db (unknown?)…dave

3

On Mon, 1 Oct 2007, Dave R. wrote:

Greg D. wrote:

What field type should I use to store time in oracle? I tried :time but
that actually creates a date field that doesn’t work with time_select,
it gives me the error “1 error(s) on assignment of multiparameter
attributes”.

i hope someone answers…i’ve got my oracle birthdate column defined as
Date if that helps plus here something i’ve found…<%=
Time.now.to_s(:db) %> interesting that it adds a another parameter to
String class .to_s (to string method) using the :db (unknown?)…dave

I ended up using an oracle ‘date’ field even though I only need to store
a time, seems there’s really no other choice. You can’t use a string
type
if you want to use any rails helpers. And then even using the oracle
date
field the time_select helper won’t work with it. I’m having to use the
select_datetime helper for now.

The weird thing about the oracle date field is the oracle web interface
only shows me the date. I have to query using to_char( meds, ‘hh:mi’ )
to be able to see the time portion, the part I need to actually see.

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/

4

I ended up using an oracle ‘date’ field even though I only need to store
a time, seems there’s really no other choice. You can’t use a string
type
if you want to use any rails helpers. And then even using the oracle
date
field the time_select helper won’t work with it. I’m having to use the
select_datetime helper for now.

The weird thing about the oracle date field is the oracle web interface
only shows me the date. I have to query using to_char( meds, ‘hh:mi’ )
to be able to see the time portion, the part I need to actually see.

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/
…could you help me… i’m using this:

Birthdate: <%= date_select :spec, :birthdate, :start_year => Spec::START_YEAR, :end_year => Time.now.year, :include_blank => true, :order => [:year, :month, :day] %>
and i still am getting an active record error ActiveRecord::MultiparameterAssignmentErrors in SpecController#edit

1 error(s) on assignment of multiparameter attributes …dave

5

On Tue, 2 Oct 2007, Dave R. wrote:

ActiveRecord::MultiparameterAssignmentErrors in SpecController#edit

1 error(s) on assignment of multiparameter attributes …dave

You might try wrapping the options in {} so date_select doesn’t get
confused. Or maybe try using the form_for syntax.

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/

6

Greg D. wrote:

On Tue, 2 Oct 2007, Dave R. wrote:

ActiveRecord::MultiparameterAssignmentErrors in SpecController#edit

1 error(s) on assignment of multiparameter attributes …dave

You might try wrapping the options in {} so date_select doesn’t get
confused. Or maybe try using the form_for syntax.

–
Greg D.
Cyberfusion Consulting
http://cyberfusionconsulting.com/

how did you eliminate your time of day in your date_select form
helper?..dave