N
newtoxml
Please help!!!! I can't figure out how to read from xml.
I have my SQL in XML file like this:
<report>
....
.... more code
</report>
/* This is what I am trying to read */
<statements>
<sql name="MyDailyQuery">
SELECT title, count(id_number) as total
from table_title,
table_tickets
where table_title.id = table_tickets.id
and table_title.name = '<param name="project"/>')
</sql>
</statements>
I am trying to read the SQL from xml file, put the parameter value(from
the user input) in the attribute of the SQL (= '<param
name="project"/>') ) so that I can use executeQuery() to run the query
in the database.
And possible right the ResultSet value back to the xml file.
I have my SQL in XML file like this:
<report>
....
.... more code
</report>
/* This is what I am trying to read */
<statements>
<sql name="MyDailyQuery">
SELECT title, count(id_number) as total
from table_title,
table_tickets
where table_title.id = table_tickets.id
and table_title.name = '<param name="project"/>')
</sql>
</statements>
I am trying to read the SQL from xml file, put the parameter value(from
the user input) in the attribute of the SQL (= '<param
name="project"/>') ) so that I can use executeQuery() to run the query
in the database.
And possible right the ResultSet value back to the xml file.