From: Rcmn 73 <rcmn73@...>
Date: 2007-02-02T05:14:23+09:00
Subject: ruby sql-query good practice

what is the equivalent in ruby of that PHP code ?

<?
$sql = "select * from mytable";
        $result = mssql_query($sql);
        while($row = mssql_fetch_array($result)){
        $array[] = $row[0];
        }
?>



so far i have :

require 'dbi'
   db = DBI.connect("DBI:ADO:Provider=SQLOLEDB;Data
Source=myserver;Initial Catalog=mydb;User Id=myuser;Password=;")
   sql = db.prepare("select* from mytable")
   sql.execute

   while row=sql.fetch do

   p row
   end


I'm just interested in a good practice to store in an array from an SQL
query.

  sql.finish

-- 
Posted via http://www.ruby-forum.com/.