Very Weird Spinner Issue

insanomania911 · by **insanomania911** » Wed Jul 01, 2009 9:24 pm

Hello,
I am trying (as many are doing) to populate a 2nd spinner out of the
first spinner selected item like this:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

//populate first spinner 
 
            final Spinner s = (Spinner) findViewById(R.id.spinner); 
 
            ArrayAdapter adapter = ArrayAdapter.createFromResource( 
 
                    this, R.array.universities, 
 
android.R.layout.simple_spinner_item); 
 
            adapter.setDropDownViewResource 
 
(android.R.layout.simple_spinner_dropdown_item); 
 
            s.setAdapter(adapter); 
 
// Initialization of the 2nd spinner 
 
                   String[] array = {"Select Building Here"}; 
 
                   final Spinner s2 = (Spinner) findViewById(R.id.spinner2); 
 
                   ArrayAdapter<String> cadapter = new ArrayAdapter(this, 
 
android.R.layout.simple_spinner_item, array); 
 
                   cadapter.setDropDownViewResource 
 
(android.R.layout.simple_spinner_dropdown_item); 
 
                   s2.setAdapter(cadapter); 
 
                // When user selects a university 
 
                    s2.setOnItemSelectedListener(new OnItemSelectedListener() { 
 
                                @Override 
 
                                public void onItemSelected(AdapterView<?> arg0, View arg1, 
 
                                                int arg2, long arg3) { 
 
                                                 //Get the selected building 
 
                                           String selectedItemString = (String) s2.getSelectedItem(); 
 
                                           System.out.println 
 
("Building: !!!"+selectedItemString); 
 
                                } 
 
                                @Override 
 
                                public void onNothingSelected(AdapterView<?> arg0) { 
 
                                        // TODO Auto-generated method stub 
 
                                } 
 
               }); 
 
            // When user selects a university 
 
            s.setOnItemSelectedListener(new OnItemSelectedListener() { 
 
                        @Override 
 
                        public void onItemSelected(AdapterView<?> arg0, View arg1, 
 
                                        int arg2, long arg3) { 
 
                                  //Get the selected university 
 
                                   String selectedItemString = (String) s.getSelectedItem(); 
 
                                   System.out.println 
 
("Uni: !!!"+selectedItemString); 
 
                          if(selectedItemString .equals("")) 
 
                          { 
 
                                  // In case of an error so it won't crash 
 
                                  nospinner(); 
 
                          } 
 
                          else 
 
                          { 
 
                                  // Find the table of the selected University dynamically 
 
                                  finder(selectedItemString); 
 
                          } 
 
                        } 
 
                        @Override 
 
                        public void onNothingSelected(AdapterView<?> arg0) { 
 
                                // TODO Auto-generated method stub 
 
                        } 
 
       }); 
 
where finder() is 
 
protected void finder(String selectedItemString) { 
 
               final Dbadapter db = new Dbadapter(this);  // This creates an 
 
instance of the database in this class 
 
           final Spinner s2 = (Spinner) findViewById(R.id.spinner2); 
 
                   // Access Database 
 
                   db.open(); 
 
                   // Fix selected item to match the db 
 
                   selectedItemString = (selectedItemString).toLowerCase(); 
 
                   selectedItemString = selectedItemString.replaceAll(" ",""); 
 
                //   System.out.println("Uni: !!!!!!!!!!!! >>>>"+selectedItemString+"<<<<<<"); 
 
                   // Call a function to return the rows of that university 
 
                   final Cursor cur = db.getAllTitles(selectedItemString); 
 
           // Get Columns 
 
           String[] columns = new String[]{"building"}; 
 
                   SimpleCursorAdapter cadapter = new SimpleCursorAdapter(this, 
 
android.R.layout.simple_spinner_item, cur, 
 
                       columns, new int[] {android.R.id.text1}); 
 
                   // Spinner Layout and population 
 
                   cadapter.setDropDownViewResource 
 
(android.R.layout.simple_spinner_dropdown_item); 
 
                   s2.setAdapter(cadapter); 
 
                   db.close(); 
 
} 
Parsed in 0.046 seconds,  using GeSHi 1.0.8.4

whenever the user changes the selection of the first spinner it's
fine, whenever the changes are related to the 2nd spinner I get a
handler exception on this line:

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

String selectedItemString = (String) 
 
s2.getSelectedItem(); 
Parsed in 0.030 seconds,  using GeSHi 1.0.8.4

I could get an object on selected item but not the actual String
value.
anyone could help?
thanks a lot

nmc · by **nmc** » Wed Jul 01, 2009 11:21 pm

I get a handler exception on this line: String selectedItemString = (String)
s2.getSelectedItem();
I could get an object on selected item but not the actual String value.

My first guess: String selectedItemString = s2.getSelectedItem().toString();

insanomania911 · by **insanomania911** » Thu Jul 02, 2009 3:45 pm

but that doesn't give me the selected item, in fact it gives something like this:

android.database.sqlite.SQLCursor@43748790

nmc · by **nmc** » Thu Jul 02, 2009 6:56 pm

I have never used CursorAdapter myself, but i would assume that you could get the string from the SQLCursor.
If the list can do, you should be able to do it also

insanomania911 · by **insanomania911** » Thu Jul 02, 2009 7:52 pm

but I am already getting the values populated in the spinner. I just can't put the selected value inside a variable.

I can't figure out a way to extract the string out of: String selected = s2.getSelectedItem().toString();

nmc · by **nmc** » Thu Jul 02, 2009 8:18 pm

You said the object is of type android.database.sqlite.SQLiteCursor, so just visit the android reference to find out:

http://developer.android.com/reference

(see methods inherited from android.database.Cursor)

insanomania911 · by **insanomania911** » Mon Jul 06, 2009 4:10 pm

yes, i did and there's nothing concerning getting the actual value. There's getCount() , Index.. but not the actual string value

thanks

nmc · by **nmc** » Mon Jul 06, 2009 6:53 pm

I saw that "methods inherited from android.database.Cursor" including .getString(rowID), with this you should be able to get the needed data.

insanomania911 · by **insanomania911** » Mon Jul 06, 2009 6:57 pm

I am sorry but can you write out the whole line?

why does it work in the first spinner but not in the second one?

this worked in the first one: String selected = (String) s1.getSelectedItem();

do you think its a VIEW issue? both of them has this view

public void onItemSelected(AdapterView<?> arg0, View arg1, int arg2, long arg3) {

thank you,

nmc · by **nmc** » Mon Jul 06, 2009 7:28 pm

I am sorry but can you write out the whole line?

Would be something like

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

SQLCursor c = (SQLCursor)s2.getSelectedItem();
String str = c.getString(0);
 
Parsed in 0.033 seconds,  using GeSHi 1.0.8.4

why does it work in the first spinner but not in the second one?

Because the first adapter uses a string-array while the second one uses a database-cursor?

insanomania911 · by **insanomania911** » Mon Jul 06, 2009 7:46 pm

that returns the index only. for example it returned 3

thanks a lot for your fast replies

insanomania911 · by **insanomania911** » Mon Jul 06, 2009 7:50 pm

ah got it got it!!!

String selected = c.getString(2); worked for me // just realized the number inside was not the row but the column id

you're the best!!!!!!!!! that took me 3 weeks without solving!!!!

Very Weird Spinner Issue

Very Weird Spinner Issue

Who is online