require  'rubygems'
require  'mysql'
file=open('/home/pt/usastock/nasdaqcompanylist.csv','r')
dbh = Mysql.real_connect("localhost", "root", "******", "usastock")
sqlstr="insert into nasdaqname(name) values (?);"
st=dbh.prepare(sqlstr)
while line=file.gets
line=line.chomp.split("\"")
print line[3],"\n"
st.execute(#{line[3]})
end

i can get nothing whit that too.
-- 
Posted via http://www.ruby-forum.com/.