Method: FluidDb::TinyTds#queryForValue

Defined in:
lib/FluidDb/TinyTds.rb

#queryForValue(sql, params = []) ⇒ Object

Raises:



93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
 
# File 'lib/FluidDb/TinyTds.rb', line 93

def queryForValue( sql, params=[] )
    sql = self.format_to_sql( sql, params )
    results = @connection.execute(sql)

    count = 0
    value = ''
    results.each do |row|
        count = count + 1
        raise FluidDb::TooManyRowsError.new if count > 1

        value = row[results.fields[0]]
    end

    raise FluidDb::NoDataFoundError.new if count == 0

    return value
end