Ruby

collection_select with :selected option

Please support our Ruby advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2006

Posts: 44

Reputation: amithasija is an unknown quantity at this point

Solved Threads: 0

amithasija amithasija is offline

Offline

Light Poster

collection_select with :selected option

Apr 10th, 2007

can we use collection_select with :selected option if yes ,plz let me know.if not than plz tell me how to use select instead of collection_select and where to write query in select if i dont want to find all records.

thnx in advance.

•

Join Date: Oct 2005

Posts: 523

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: collection_select with :selected option

Apr 12th, 2007

•

Originally Posted by amithasija

can we use collection_select with :selected option if yes ,plz let me know.if not than plz tell me how to use select instead of collection_select and where to write query in select if i dont want to find all records.

thnx in advance.

You need to give more information. What do you want to be selected and when?

If you want a default value put

 Help with Code Tags 
 Ruby Syntax (Toggle Plain Text) 
t.column :favourite_colour_id, :integer, :default => 1
t.column :favourite_colour_id, :integer, :default => 1

in your migration.

If you are loading an existing record (for editing) the correct value should already be selected in the select box.

If you are still stuck please paste your controller and view code.

Note to self... pocket cup

•

Join Date: Nov 2006

Posts: 44

Reputation: amithasija is an unknown quantity at this point

Solved Threads: 0

amithasija amithasija is offline

Offline

Light Poster

Re: collection_select with :selected option

Apr 13th, 2007

thanx buddy for quick reply,

now i am explaning you the whole scenario.what i have done is ,i have a sample form with collection_select on it with multiple true(suppose five values).on submit selected values goes into database(suppose two) coreesponding to particular id.now when i again open the page i want the values from database comes as selected(two values that are coming from database as highlighted or selected).and thanx for all your help till now and in future.

•

Join Date: Oct 2005

Posts: 523

Reputation: pty is on a distinguished road

Solved Threads: 37

pty

Offline

Posting Pro

Re: collection_select with :selected option

Apr 14th, 2007

•

Originally Posted by amithasija

thanx buddy for quick reply,

now i am explaning you the whole scenario.what i have done is ,i have a sample form with collection_select on it with multiple true(suppose five values).on submit selected values goes into database(suppose two) coreesponding to particular id.now when i again open the page i want the values from database comes as selected(two values that are coming from database as highlighted or selected).and thanx for all your help till now and in future.

Ah - I see what you mean now.

Try something like this (for this i'm assuming a person has many jobs):

 Help with Code Tags 
 Ruby Syntax (Toggle Plain Text) 
<%= collection_select 
	:person, 
	:job_ids,
	Job.find(:all),
	:id, 
	:description,
	{},
	:multiple => true,
	:name => 'person[job_ids][]' 
%>
<%= collection_select 
	:person, 
	:job_ids,
	Job.find(:all),
	:id, 
	:description,
	{},
	:multiple => true,
	:name => 'person[job_ids][]' 
%>