Post: #10

I need a help about this problem, any one can help me? I do a little test with my script, and share the result (Dialog):

DB.Query "SELECT serial,nome,venda,valor From uo_person Where venda=1 and server='HellFire' Order by nome Limit <Eval (<cTag.Dialogindex>)>,<Eval (<cTag.Dialogindex>+19)>";
For index 0 18
Serv.Log = "Index: <Eval <local.index>> Nome: <db.row.<Eval (<local.index>)>.nome> Valor: <db.row.<Eval <local.index>>.valor> Venda: <db.row.<Eval <local.index>>.venda>"
EndFor

LOG on sphere:

17:25:(CashShop_MySQL.scp,254)Index: 0 Nome: A p o l l o Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 1 Nome: Abdenago Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 2 Nome: Abstration Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 3 Nome: AnDrE Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 4 Nome: Angelflames Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 5 Nome: Axelrud Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 6 Nome: BoO Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 7 Nome: ByRoN Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 8 Nome: CerberuS Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 9 Nome: Cyclone Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 10 Nome: Dare Devil Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 11 Nome: Diabinha Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 12 Nome: Filth Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 13 Nome: Hawk Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 14 Nome: Igor Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 15 Nome: Jujuba Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 16 Nome: Kubuntu Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 17 Nome: Lucjonny Valor: 0 Venda:
17:25:(CashShop_MySQL.scp,254)Index: 18 Nome: Papai Smurf Valor: 0 Venda:


The name of person is correct, but "valor" (expected value 1) and "venda" (expected values like 5000, 10000...) not. This columns are INT, im using the last Nightly Build.

The character set of my table is UTF8 and engine is MyISAM