[tbs-dev] TbsSQL class - numerical array result ??

From : tom@... , the 5th October 2010 19:23

Hello Skrol29 I have found a situation while I was converting a form class from ezSQL to TbsSQL. The form class needs/expects the query result returned as a numerical array. Previously I was doing... $this->formData = $db->get_row("SELECT `$this->field` FROM `$this->tableName`  WHERE $this->pk = '$this->id'",ARRAY_N);   // this is the ezSQL class Now for TbsSQL I am doing... $this->formData = $Db->GetRow("SELECT `$this->field` FROM `$this->tableName`  WHERE $this->pk = '$this->id'");   // do this for TbsSQL class I found that I can work around this by doing... $this->formData = array_values($this->formData); If I an missing some capability in TbsSQL that will produce the result as a  numerical array, please advise me. Else, perhaps it is worth considering adding an additional row type... $Db->DefaultRowType(TBSSQL_NUMERIC); Sincere thanks for your consideration. And thanks for TBS every day, TomH