Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I declared the boolean array inside my custom adapter. Also I removed the if statement ie </p> <p><strong>if (convertView == null)</strong></p> <pre><code>public class Search_list extends Activity { static String str1 = "v1", str2 = "v2"; String s, item, idd; static int spnr, range1, range2; private CarHelper dbcarhelper = null; private Cursor ourCursor; CarHelper h = null; List&lt;String[]&gt; names2 = null; ListView LV; MyCustomAdapter dataAdapter = null; byte[] Image = null; Cursor c; Bitmap decodedByte; String c1_make = null, c1_model = null, c1_ver = null, c2_make = null, c2_model = null, c2_ver = null; int cntr = 0; Button b1; CheckBox cb; protected ProgressDialog dialog; List&lt;String[]&gt; mlist = new ArrayList&lt;String[]&gt;(); TextView tv1; ArrayList&lt;String&gt; stg1; ArrayList&lt;String&gt; arr_make = new ArrayList&lt;String&gt;(); ArrayList&lt;String&gt; arr_model = new ArrayList&lt;String&gt;(); ArrayList&lt;String&gt; arr_ver = new ArrayList&lt;String&gt;(); ArrayList&lt;Bitmap&gt; arr_img = new ArrayList&lt;Bitmap&gt;(); @Override protected void onCreate(Bundle savedInstanceState) { // TODO Auto-generated method stub super.onCreate(savedInstanceState); setContentView(R.layout.search_list); dialog = ProgressDialog.show(Search_list.this, "Loading", "Please Wait..."); LV = (ListView) findViewById(R.id.list); //------------------ Compare button onClick() ------------------------------ b1 = (Button) findViewById(R.id.btnCmp); b1.setOnClickListener(new Button.OnClickListener() { public void onClick(View arg0) { int count = 1; if (cntr == 1) { Toast.makeText(getApplicationContext(), "Please select atleast two cars!", Toast.LENGTH_LONG).show(); } else { for (int i = 0; i &lt; dataAdapter.status.size(); i++) { System.out.println("Compare click Position= " + i + " Status: " + dataAdapter.status.get(i)); // System.out.println(); if (dataAdapter.status.get(i)) { if (count == 2) { c2_make = arr_make.get(i); c2_model = arr_model.get(i); c2_ver = arr_ver.get(i); count++; } if (count == 1) { c1_make = arr_make.get(i); c1_model = arr_model.get(i); c1_ver = arr_ver.get(i); count++; } } else { } } Intent intent = new Intent(Search_list.this, DispComp.class); Bundle b = new Bundle(); b.putString("car1", c1_make); b.putString("carm1", c1_model); b.putString("carv1", c1_ver); b.putString("car2", c2_make); b.putString("carm2", c2_model); b.putString("carv2", c2_ver); intent.putExtras(b); startActivity(intent); } } }); //-------------------------------------------------------------------------- dbcarhelper = new CarHelper(this); dbcarhelper.createDatabase(); dbcarhelper.openDataBase(); if (s != null) { startManagingCursor(ourCursor); } if (spnr == 1) { byMakeModel(); } if (spnr == 2) { byBudgetFuel(); } fill_list(); System.out.println("Inside onCreate() ... status all null..! "); dialog.dismiss(); } public void SetId(String s1, String s2, int s) { System.out.println("SetMake spnr= |" + spnr + "|"); System.out.println("SetMake s= |" + s + "|"); str1 = s1; str2 = s2; spnr = s; System.out.println("SetMake aftr spnr= |" + spnr + "|"); } public void SetBudgetFuel(String s1, String s2, int s, int r1, int r2) { System.out.println("SetBudget spnr= |" + spnr + "|"); System.out.println("SetBudget s= |" + s + "|"); System.out.println("SetBudget r1= |" + r1 + "|"); System.out.println("SetBudget r2= |" + r2 + "|"); str1 = s1; str2 = s2; spnr = s; range1 = r1; range2 = r2; System.out.println("SetMake aftr spnr= |" + spnr + "|"); } // ------------------------------------------------------------------------- public void byMakeModel() { // make n model selected ******************************* if (str2.equalsIgnoreCase("(Select)")) { dbcarhelper.search_by_make(str1); } else { dbcarhelper.search_by_makemodel(str1, str2); } } // ------------------------------------------------------------------------- public void byBudgetFuel() { // budget or fuel selected // ************************************************ if (str1.equalsIgnoreCase("Any Budget")) { dbcarhelper.search_by_fuel(str2); } else if (str2.equalsIgnoreCase("All")) { dbcarhelper.search_by_budget(range1, range2); } else { dbcarhelper.search_by_budgetfuel(str2, range1, range2); } } // ------------------------------------------------------------------------- public void fill_list() { final CarHelper h = new CarHelper(getApplicationContext()); Toast.makeText(getApplicationContext(), "Inside if case", Toast.LENGTH_LONG).show(); mlist = h.selectAllb2(); stg1 = new ArrayList&lt;String&gt;(); int x = 0; String stg; for (String[] srch : mlist) { stg = "Make: " + srch[0] + "\nModel: " + srch[1] + " \nVersion: " + srch[2] + "\nPrice: Rs. " + srch[3]; stg1.add(stg); arr_make.add(srch[0]); arr_model.add(srch[1]); arr_ver.add(srch[2]); System.out.println("srch 0" + srch[0] + "\nsrch 1" + srch[1] + "\nsrch 2" + srch[2] + "\nsrch 3" + srch[3]); x++; } System.out.println("length--------------------- " + stg1.size()); // ----------------Image-------------------- int run = 0; c = dbcarhelper.fetchImgRow("1"); if (c.moveToFirst()) { do { Image = c.getBlob(c.getColumnIndex("img_str")); System.out.println("Image = " + Image); System.out.println("run = " + run); byte[] decodedString = Base64.decode(Image, Base64.DEFAULT); decodedByte = BitmapFactory.decodeByteArray(decodedString, 0, decodedString.length); arr_img.add(decodedByte); System.gc(); run++; } while (c.moveToNext()); } dbcarhelper.close(); // ----------------Image-------------------- System.out.println("run after close() = " + run); dataAdapter = new MyCustomAdapter(this, R.layout.new_search_adptr, stg1); LV.setAdapter(dataAdapter); int[] colors = { 0, 0xff00ffff, 0 }; LV.setDivider(new GradientDrawable(Orientation.RIGHT_LEFT, colors)); LV.setDividerHeight(4); LV.setOnItemClickListener(new OnItemClickListener() { @Override public void onItemClick(AdapterView&lt;?&gt; parent, View view, int position, long id) { New_Details det = new New_Details(); System.out.println("Inside Click !"); String car1 = h.srch_make.get(position); String carm1 = h.srch_model.get(position); String carv1 = h.srch_ver.get(position); det.setImg(arr_img.get(position)); Intent intent = new Intent(Search_list.this, New_Details.class); Bundle b = new Bundle(); b.putString("car1", car1); b.putString("carm1", carm1); b.putString("carv1", carv1); intent.putExtras(b); startActivity(intent); } }); } private class MyCustomAdapter extends ArrayAdapter&lt;String&gt; { private ArrayList&lt;Boolean&gt; status = new ArrayList&lt;Boolean&gt;(); public MyCustomAdapter(Context context, int textViewResourceId, ArrayList&lt;String&gt; sList) { super(context, textViewResourceId, sList); for (int i = 0; i &lt; arr_make.size(); i++) { status.add(false); } System.out.println("Inside My Custom Adapter.. status all null..! "); } private class ViewHolder { TextView text; CheckBox chkbox; ImageView imageview; } @Override public int getCount() { // TODO Auto-generated method stub return arr_make.size(); } @Override public long getItemId(int position) { // TODO Auto-generated method stub return position; } @Override public View getView(final int position, View convertView, ViewGroup parent) { ViewHolder holder = null; //Log.v("ConvertView", String.valueOf(position)); //if (convertView == null) { LayoutInflater vi = (LayoutInflater) getSystemService(Context.LAYOUT_INFLATER_SERVICE); convertView = vi.inflate(R.layout.new_search_adptr, null); holder = new ViewHolder(); holder.text = (TextView) convertView .findViewById(R.id.adapterText1); holder.chkbox = (CheckBox) convertView .findViewById(R.id.checkBox1); //---------- Setting the checkBoxes ------------------------ if (status.get(position)) { holder.chkbox.setChecked(true); } else { holder.chkbox.setChecked(false); } //---------------------------------------------------------- holder.imageview = (ImageView) convertView .findViewById(R.id.imageView1); convertView.setTag(holder); holder.chkbox.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { CheckBox cb = (CheckBox) v; if (cb.isChecked()) { // User checked (selected) a car // ********************************* if (cntr &gt; 1) { // More than two cars selected Toast.makeText(getApplicationContext(), "Please select only two cars!", Toast.LENGTH_LONG).show(); cb.setChecked(false); } else { // car selected status.set(position, true); cntr++; System.out.println("Chk List Position= " + position ); for (int i = 0; i &lt; status.size(); i++) { System.out.println("Chkbox chkd Position= " + i + " Status: " + status.get(i)); } } } else { // User Unchecked (de - selected) a car // ********************************* cntr--; status.set(position, false); System.out.println("Unchk List Position= " + position ); for (int i = 0; i &lt; status.size(); i++) { System.out.println("UnChkbox chkd Position= " + i + " Status: " + status.get(i)); } } } }); holder.text.setText(stg1.get(position).toString()); // setting image holder.imageview.setImageBitmap(arr_img.get(position)); return convertView; } } } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POList View custom adapter randomly checking values
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCarbon
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COwhy did you remove `converView==null`. oonly when your view is null you need to `findViewById`. do it for large list view items you will see the performance issues. i don't think what you are doing is right
      singulars
      1. PO
      1. USRaghunandan
    2. COyes you are right, but I wanted a quick fix to meet my deadline today.. I will still apply the other way later.
      singulars
      1. PO
      1. USCarbon
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload