Passing html params in Ruby


#1

I have an AJAX page that I built.
The user enters in some info.
I format a query string and want use it to query my DB.

something like this:

var query_string = "SELECT * FROM mydbtable;

<%
require ‘dbi’
require ‘cgi’
cgi = CGI.new
params = cgi.params

new_query_string = cgi.params[‘query_string’]

dbh =
DBI.connect(“dbi:Pg:dbname=blank;host=blank;port=blank”,“blank”,“blank”)

newsth = dbh.execute("#{new_query_string}")

rows = newsth.fetch_all

%>

the query_string variable is not passed in the ‘params’, so obviously
this code is never going to work.
How do I pass the formatted variable (query_string) into my embedded
ruby code so that I can query my DB?

Thank you in advance.