Post: #1

Hey fellas,
I've got an issue with SQL command.
Table: id(int,A_I, primary key), login(varchar(16)),heslo(varchar(16)),email(varchar(80)), and some 6 more columns... first name, last name, hash, date, approved, approved_client.

Quote:1, When I query this command "SELECT login FROM accounts WHERE approved='1'"
DB.ROW.NUMROWS = 1
DB.ROW.NUMCOLS = 1
DB.ROW.0.0 = :actual login name:
DB.ROW.0.login = :actual login name:
=> it works.

Quote:2, "SELECT login,heslo FROM accounts WHERE approved='1'"
DB.ROW.NUMROWS = 1
DB.ROW.NUMCOLS = 2
DB.ROW.0.0 = :actual login name:
DB.ROW.0.login = :actual login name:
DB.ROW.0.1 = :actual heslo:
DB.ROW.0.heslo = <--------------- returns nothing
=> it somehow works with indexes.

Quote:3, "SELECT login,heslo,email FROM accounts WHERE approved='1'"
DB.ROW.NUMROWS = 1
DB.ROW.NUMCOLS = 3
DB.ROW.0.0 = :actual login name:
DB.ROW.0.login = :actual login name:
DB.ROW.0.1 = :actual heslo:
DB.ROW.0.heslo = <--------------- returns nothing
DB.ROW.0.2 = <--------------- returns nothing
DB.ROW.0.email = <--------------- returns nothing
=> can't access data from more than 2 columns

Release 0.56c, 31. August
Ideas what might be the problem? When I use "SELECT *", it says it has 10 columns but I can access only the first column with index or name and the second only with index.

Post: #2

Why are you setting NUMROWS and NUMCOLS?
Remove those 2 lines and it should all work fine.

Post: #3

I don't set anything. It's the output. It was just information what it returns. Not declaration.

Real code:
output:

Post: #4

Maybe your language system is the problem... Or your table don't have the data.