Database SQLite issue in Android?

Question

I want delivery charge compared to subtotal and calculate delivery charges. I got the result successfully. I get query and I put in that code execute in Execute SQL. I got correct answer. But

I have some problem in retrieve data. I got result everytime first position value only .

Below I have mention my code.Give me solution.

String Query ="select ROUND(delivarycharge) from pincodedetails where ROUND(subtotal)
<= ( select ROUND(subtotal)  from pincodedetails where ROUND(subtotal) >= "+price+" 
and resturantID="+selArgs+" limit 1) and resturantID ="+selArgs+" and ROUND(subtotal) 
>= ( select ROUND(subtotal) from pincodedetails where ROUND(subtotal) <= "+price+" 
and resturantID="+selArgs+" limit 1)  order by ROUND(subtotal) LIMIT 1";

Database Helper Class:

double deliverycharge= 0;
if (mCursor.moveToFirst()) {
    // Got first result
    deliverycharge= mCursor.getDouble(0);
}
return deliverycharge;

score 1 · Accepted Answer · 2013-03-19 07:22:27Z

1

You should change your code to retrieve to something like:

Vector<String> temp = new Vector<String>;
cursor.moveToFirst();
do {

    deliverycharge= mCursor.getDouble(0);
    temp.add()                  
} while (cursor.moveToNext());
return temp;

So you will return a vetor containing all Strings.

edited Mar 19, 2013 at 7:22

answered Mar 19, 2013 at 7:15

user2185272

Sign up to request clarification or add additional context in comments.

10 Comments

Gomathi Over a year ago

i got only one result sunhari.No need list and all

user2185272 Over a year ago

If you need to retrieve all strings then how can you do without vector or list or String[]? @Gomathi

user2185272 Over a year ago

Because every time String will be overwritten @Gomathi

Gomathi Over a year ago

I don't need all string value just only one string For example 40 only

user2185272 Over a year ago

And how is that decided? I mean which String do you need? Is it always first column data? @Gomathi

|

Hoan Nguyen · Accepted Answer · 2013-03-19 07:26:30Z

0

Try this

String Query ="select ROUND(delivarycharge) as roundcharge from pincodedetails where ROUND(subtotal) <=( select ROUND(subtotal)  from pincodedetails where ROUND(subtotal)>="+price+" and resturantID="+selArgs+" limit 1) and resturantID="+selArgs+" and ROUND(subtotal) >=( select ROUND(subtotal) from pincodedetails where ROUND(subtotal)<="+price+" and resturantID="+selArgs+" limit 1)  order by ROUND(subtotal) LIMIT 1";

You need the as "whatever name you want"

answered Mar 19, 2013 at 7:26

Hoan Nguyen

18.2k3 gold badges52 silver badges56 bronze badges

Collectives™ on Stack Overflow

Database SQLite issue in Android?

2 Answers 2

10 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related