public function testGettingAScalar()
{
$rs = $this->connection()->execute('SELECT name,value,active FROM user');
$this->assertEquals($rs->scalar(), 'Llama');
$this->assertEquals($rs->scalar(), 'Drama');
$this->assertSame($rs->scalar(), null);
// this should rewind and seek
$this->assertEquals($rs->seek(0)->scalar(1), 24);
$this->assertEquals($rs->seek(0)->scalar('name'), 'Llama');
}