SphereCommunity
MYSQL - table in sphere memory - Printable Version

+- SphereCommunity (https://forum.spherecommunity.net)
+-- Forum: Sphere 0.56d (/Forum-Sphere-0-56d)
+--- Forum: General Help (/Forum-General-Help)
+--- Thread: MYSQL - table in sphere memory (/Thread-MYSQL-table-in-sphere-memory)

MYSQL - table in sphere memory - Alaric - 09-26-2014 07:14 PM

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.

RE: MYSQL - table in sphere memory - Ben - 09-27-2014 03:52 AM

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

RE: MYSQL - table in sphere memory - Alaric - 09-27-2014 05:19 AM

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

Real code:
Code:
DB.QUERY "SELECT id,login,heslo,email FROM `ucty_zadosti`"
IF <DB.ROW.NUMROWS>
   serv.b DEBUG: <DB.ROW.0.0>
   serv.b DEBUG: <DB.ROW.0.1>
   serv.b DEBUG: <DB.ROW.0.2>
   serv.b DEBUG: <DB.ROW.0.3>
   serv.b DEBUG: <DB.ROW.0.id>
   serv.b DEBUG: <DB.ROW.0.login>
   serv.b DEBUG: <DB.ROW.0.heslo>
   serv.b DEBUG: <DB.ROW.0.email>
ENDIF
output:
Code:
DEBUG: 115
DEBUG: Alaric
DEBUG:
DEBUG:
DEBUG: 115
DEBUG:
DEBUG:
DEBUG:


RE: MYSQL - table in sphere memory - Extreme - 09-27-2014 06:07 AM

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