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