<% request = Web::MODULE.request queries = request.query_fields.to_hash.reject{|key, val| val.empty?} require 'rdb' database_name = queries['database_name'] || 'IBLocal' @database = RDB::SESSION.databases.find{|i| i.database_name == database_name} || RDB::Database.new(database_name, 'SYSDBA', 'masterkey') =begin session_name = "RunTimeSession_#{RDB::SESSIONS.count}" RDB::SESSIONS.open_session(session_name) do |session| database_name = queries['database_name'] || 'IBLocal' p RDB::SESSIONS.session_names db = RDB::Database.new db.database_name = database_name db.params.add 'user name=SYSDBA' db.params.add 'password=masterkey' db.login_prompt = false db.session_name = session_name db.open @database = db =end @query = RDB::Query.new @database table = queries['table'] || 'customer' @query.sql.text = <

db erb

database_name
table
<% #begin @query.open %> <% @query.fields.each do |field| %> <% end %> <% @query.each do |fields| %> <% fields.each do |field| %> <% end %> <% end %>
<%= field.field_name %>
<%= s=field.value.to_s; s.empty? ? ' ' : s %>
<% @query.close #rescue # puts "error: #{html_escape($!.to_s)}(#{$!.type})" #end %> <% # end # of session GC.start %>