Problem selecting ID and name from SQLite database
#4

Quote:
Originally Posted by Misiur
Посмотреть сообщение
Change AND to comma.
You sure that just this will make it work? What about a loop? Is it not needed?

Quote:
Originally Posted by Dubya
Посмотреть сообщение
Not sure with SQLite, but I am 50% sure that that query is wrong.

"SELECT `ID` AND `NAME` FROM `PLAYERS`" isn't a complete query.

"SELECT `ID` AND `NAME` FROM `PLAYERS` WHERE 1" is a complete query.
What does that WHERE 1 do? As I know WHERE is a clause that is used to extract only those records that fulfill a specified criterion.
Reply


Messages In This Thread
Problem selecting ID and name from SQLite database - by Cypress - 13.08.2013, 15:45
Re: Problem selecting ID and name from SQLite database - by Misiur - 13.08.2013, 16:25
Re: Problem selecting ID and name from SQLite database - by Dubya - 13.08.2013, 16:29
Re: Problem selecting ID and name from SQLite database - by Cypress - 13.08.2013, 16:30
Re: Problem selecting ID and name from SQLite database - by Dubya - 13.08.2013, 16:33
Re: Problem selecting ID and name from SQLite database - by Misiur - 13.08.2013, 16:51

Forum Jump:


Users browsing this thread: 1 Guest(s)