fetchNum() method

[gholol]

Hi

It's not really an issue, just a simple question.
I'm little surprised that there's no fetchNum() method. Do you have any plans of implementing it?

[harikt]

You mean PDO::FETCH_NUM ?

[pmjones]

Not sure what you mean here @gholol -- can you expand a bit?

[gholol]

Well, sure guys.

Aura.Sql provides fetchAssoc() method.

We can use it like this

$result = $pdo->fetchAssoc($stm, $bind);

Now, this of course retrieves an ASSOCIATIVE array (where the key is the
first column, and the row arrays are keyed on the column names), and so, I cannot use it with list() function, because list() works only with numeric arrays.

I can do a workaround around this, and write something like:

$result = $pdo->fetchAssoc($stm, $bind);
list($value1, 
     $value2,
     $value3
) = array_keys($result);

But isn't it a bit impractical? Do you have any plans of implementing a function that returns a result as numeric array? (PDO:FETCH_NUM

[pmjones]

This particular case ...

$result = $pdo->fetchAssoc($stm, $bind);
list($value1, 
     $value2,
     $value3
) = array_keys($result);

... might be addressed by:

$values = $pdo->fetchCol($stm, $bind);

That will populate $values with the first column of all rows in the result set. (Note that fetchAssoc() uses the first column as the array key.)

Is that sufficient, or is there another case that needs to be addressed?

[pmjones]

@gholol Any further thoughts?

[gholol]

Hi!

Sorry for not responding, i was at work.

Your suggestion to use fetchCol() was right, it works perfectly ;) So i don't have anything else to rant about.

Have a nice day guys!