#!/usr/bin/env ruby require 'dbi' db = DBI.connect ("DBI:Pg:jim", "jim") sql = <<-SQL SELECT email FROM person, email WHERE person.personid = email.personid AND person.nick = ? ORDER BY nick, type SQL statement = db.prepare(sql) statement.execute(ARGV[0]) while row = statement.fetch puts row[0] if row end statement.finish db.disconnect |
[ Index ][ Table of Contents ] | Generated by [ source2html ] |