Iterating through fields in a Nodejs MySQL result set
<p>I'm a relative node newbie (old school programmer)</p>

<p>I have working code to grab a result set and parse through rows.  I'm using felx's node-mysql driver.  It's not hard to specifically print out columns.</p>

<pre><code>connection.query('SELECT * FROM Company', function(err, rows, fields) {
    if (err) throw err;

    for (var i = 0; i &lt; rows.length; i++) {
        result = "";
       result = result + ('| ' + rows[i].name + ' | ' + rows[i].address_zip);
        theEmail = theEmail + result + "&lt;BR&gt;";
}
</code></pre>

<p>What I really want to do is loop through fields without having to name them ... my gut tells me it would be <code>rows[i].[j]</code> ... or something like that.</p>

<p>Is this possible?</p>