Databases
StackOverflow2013
Postsdbo
POScan qr code, pass the qr content in to query and display the result on screen in android
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POScan qr code, pass the qr content in to query and display the result on screen in android
    primarykey
    data
    text
    <p>I am using zxing to scan qr code in android and getting the result. Now I want to pass the qr code content (which is always a number) into sqlite select query and display the result on to the screen. But when I pass the content into the query, i am getting Null pointer Exception. The code is </p> <pre><code> Intent intent = new Intent("com.google.zxing.client.android.SCAN"); intent.putExtra("SCAN_MODE", "QR_CODE_MODE"); startActivityForResult(intent, 0); protected void onActivityResult(int requestCode, int resultCode, Intent intent) { super.onActivityResult(requestCode, resultCode, intent); if (requestCode == 0) { if (resultCode == RESULT_OK) { String contentId = intent.getStringExtra("SCAN_RESULT"); String format = intent.getStringExtra("SCAN_RESULT_FORMAT"); Cursor cursorDetails = db.query("cd_details", new String[] {"location","latitude","longitude","photo"}, "id" + " = " + "'" + contentId + "'", null, null, null, null); cursorDetails.moveToFirst(); } else if (resultCode == RESULT_CANCELED) { Toast toast = Toast.makeText(this, "Scan was Cancelled!", Toast.LENGTH_LONG); toast.setGravity(Gravity.TOP, 25, 400); toast.show(); } } } </code></pre> <p>I am getting error in the query line. The error reads like this </p> <pre><code> java.lang.RuntimeException: Unable to resume activity {com.pixel.scanner/com.pixel.scanner.ScannerActivity}: java.lang.RuntimeException: Failure delivering result ResultInfo{who=null, request=0, result=-1, data=Intent { act=com.google.zxing.client.android.SCAN flg=0x80000 (has extras) }} to activity {com.pixel.scanner/com.pixel.scanner.ScannerActivity}: java.lang.NullPointerException at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2124) at android.app.ActivityThread.handleResumeActivity(ActivityThread.java:2139) at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1672) at android.app.ActivityThread.handleRelaunchActivity(ActivityThread.java:2836) at android.app.ActivityThread.access$1600(ActivityThread.java:117) at android.app.ActivityThread$H.handleMessage(ActivityThread.java:939) at android.os.Handler.dispatchMessage(Handler.java:99) at android.os.Looper.loop(Looper.java:130) at android.app.ActivityThread.main(ActivityThread.java:3687) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:507) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:867) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:625) at dalvik.system.NativeStart.main(Native Method) Caused by: java.lang.RuntimeException: Failure delivering result ResultInfo{who=null, request=0, result=-1, data=Intent { act=com.google.zxing.client.android.SCAN flg=0x80000 (has extras) }} to activity {com.pixel.scanner/com.pixel.scanner.ScannerActivity}: java.lang.NullPointerException at android.app.ActivityThread.deliverResults(ActivityThread.java:2536) at android.app.ActivityThread.performResumeActivity(ActivityThread.java:2111) ... 13 more Caused by: java.lang.NullPointerException at com.pixel.scanner.ScannerActivity.onActivityResult(ScannerActivity.java:70) at android.app.Activity.dispatchActivityResult(Activity.java:3908) at android.app.ActivityThread.deliverResults(ActivityThread.java:2532) ... 14 more </code></pre> <p>Line 70 in the above code is</p> <pre><code>Cursor cursorDetails = db.query("cd_details", new String[] {"location","latitude","longitude","photo"}, "id" + " = " + "'" + contentId + "'", null, null, null, null); </code></pre> <p>Any suggestions on this one will be a great help.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USShrikant
    1. USShrikant
    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. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POScan qr code, pass the qr content in to query and display the result on screen in android
      1. This table or related slice is empty.
      1. VTDownMod
    1. COAt ScannerActivity line 70, you have a null object.
      singulars
      1. POScan qr code, pass the qr content in to query and display the result on screen in android
      1. USbmavus
    2. CO@bmavus thanks for the reply. But I don't have any null objects there.
      singulars
      1. POScan qr code, pass the qr content in to query and display the result on screen in android
      1. USShrikant
    3. CO@bmavus check my edited question. I have mentioned line 70.
      singulars
      1. POScan qr code, pass the qr content in to query and display the result on screen in android
      1. USShrikant
 

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