SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Move this topic

Forum :

Sub forum :

Contributed Library Questions

augustoest

SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

in Contributed Library Questions • 2 years ago

Hello,

I'm trying to read values from a field called event_id. Problem is, my query returns values from two tables. I've tried:

db.getInt("table_one.some_field")

But it doesn't work ( no column by the name of table_one.some_field). Any tips?

Replies(4)

PhiLho

Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

2 years ago

Can you be more precise? What is your query exactly?

augustoest

Re: Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

2 years ago

I have something like:

String from = "FROM table1, table2";
String where = "WHERE table1.event_id = table2.event_id AND table2.event_type=\"Something\"";
db.query("SELECT * " + from + " " + where);

Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

2 years ago

In general, advice is to avoid SELECT *, particularly if you need only a small subset of the columns: it is inefficient and leads to problems, as you saw.
Maybe you want something like:

db.query("SELECT table1.event_id " + from + " " + where);

but since the event_id values are the same, you don't care which table it comes from, no?

augustoest

Re: Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

2 years ago

Thanks a lot phil.lho :)

Statistics

4 Replies
951 Views
0 Followers

Actions

Permalink

sqlite & ArrayList 2.0 array ju...
How to prepare statements using the...
How to pass a String variable into ...
Oracle and Processing
importing libraries with windows 7

SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Replies(4)

Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Re: Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Re: Re: SQLibrary: How to use (e.g.) db.getInt("some_field") if your query returns two tables with the same field?

Statistics

Tags

Actions

Related Posts