# Parsing data trouble

**URL:** <https://www.ruby-forum.com/t/parsing-data-trouble/82411>\
**Category:** Ruby\
**Created:** [January 19, 2007, 4:30pm UTC](https://www.ruby-forum.com/t/parsing-data-trouble/82411 "2007-01-19T16:30:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [January 19, 2007, 4:30pm UTC](https://www.ruby-forum.com/t/parsing-data-trouble/82411/1 "2007-01-19T16:30:15Z")

</div>

Late in the day and I’ve hit a wall. Any help is appreciated.

Heres what I have:

\<%  
dbh =  
DBI.connect(“dbi:blank:dbname=products;host=blank;blank”,“blank”,“blank”)

sth = dbh.execute(“SELECT \* FROM products”)

while row = sth.fetch\_array do  
puts “  
”  
puts “Column Name : #{sth.column\_names[0]}”  
puts “Column Name : #{sth.column\_names[1]}”  
puts “Column Name : #{sth.column\_names[2]}”  
puts “  
”

%\>

Now, as long as I use puts “Column Name : #{sth.column\_names[0]}” and  
increment column\_names by hand I get my data.

EX.  
Array\_Grid\_Header =[“Column Name : #{sth.column\_names[0]}” ,  
“Column Name : #{sth.column\_names[1]}”  
,  
“Column Name : #{sth.column\_names[2]}”  
,  
“Column Name : #{sth.column\_names[3]}”  
,  
“Column Name : #{sth.column\_names[4]}”  
];

Problem is, I need this to be dynamic so I can insert it into my array.  
I am a C++ programmer and cannot figure out how to do this in RUBY.

Also, this is embedded Ruby code into JavaScript

what I need is something like this:

```
     for(var nCount = 0; nCount < <%=sth.column_names.size%>;

```

nCount++)  
{  
Array\_Grid\_Header +=  
["\<%=sth.column\_names[nCount].upcase%\>"];

```
     }

```

This would give me the Array in need, but it doesn’t like nCount.

See…\<%=sth.column\_names.size%\> in my f’or loop’ produces 15.  
I need fill Array\_Grid\_Header with the column names .

Thank you in advance.

---

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [January 19, 2007, 4:30pm UTC](https://www.ruby-forum.com/t/parsing-data-trouble/82411/2 "2007-01-19T16:30:16Z")

</div>

> what I need is something like this:
> 
> ```
> for(var nCount = 0; nCount < <%=sth.column_names.size%>;
> 
> ```
> 
> nCount++)  
> {  
> Array\_Grid\_Header +=  
> ["\<%=sth.column\_names[nCount].upcase%\>"];
> 
> ```
> }
> 
> ```

try:  
Array\_Grid\_Header += sth.column\_names.collect{|c| c.upcase}

---

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [January 19, 2007, 4:57pm UTC](https://www.ruby-forum.com/t/parsing-data-trouble/82411/3 "2007-01-19T16:57:08Z")

</div>

Matt Gillooly wrote:

> try:  
> Array\_Grid\_Header += sth.column\_names.collect{|c| c.upcase}

Hey man. That was what I needed. I still don’t have the data parsed  
correctly yet but I did a  
alert(Array\_Grid\_Header); and can now see how the data is sitting.

Kudos dude!

---

<div class="post-metadata">

**Author:** ![unknown](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/u/4bbf92/32.png) [@unknown](https://www.ruby-forum.com/u/unknown)\
**Post date:** [September 25, 2007, 10:33pm UTC](https://www.ruby-forum.com/t/parsing-data-trouble/82411/4 "2007-09-25T22:33:55Z")

</div>

Matt Gillooly wrote:

> try:  
> Array\_Grid\_Header += sth.column\_names.collect{|c| c.upcase}

Hey man. That was what I needed. I still don’t have the data parsed  
correctly yet but I did a  
alert(Array\_Grid\_Header); and can now see how the data is sitting.

Kudos dude!