Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dynamic xsl using oracle

Status
Not open for further replies.

lovinasd

Programmer
Jan 23, 2005
23
US
Hi,
can you generate a dynamic xsl using database?
I havde generated a report which is a dynamic xml populated from the database.IS it possible to link the xml element name with a database table and produce the dynamic xsl using database connection.
eg of xml.
<report>
<q_1_a>test1</q_1_a>
<q_1_b>test2</q_1_b>
<q_1_c>test3</q_1_c>
<q_1_d>test4</q_1_d>
</report>

I would like the xsl to pick the text from the database for the elemeent name i.e. <q_1_a>
Is it possible to generate a dynamic xsl than changing my xml which will make it lengthier.
Thanks,
 
Since there are procedural aspects to XSL, 'dynamic XSL behavior' is not only possible, but is often used.

However, for there to be any meaningful reply to your request, you will need to provide not only a sample input, but also one or more sample output documents.

Tom Morrison
 
The out put would be dynamic output from the database table which which ahve matching values for the element names.
like the table will have
column 1 column2
q_1_a Is this a test?
q_1_b Is this a test1?
q_1_c Is this a test2?
Tha values of column 2 can be something lengthier like 255 char.
in fder to avoid the dynamic xml to write the va;ue again and again i have given it names like q_1_a


the output would look like
column replace the elemnt tag
q_1_a
replaced
by the below content from database.

q_1_a q_1_b q_1_c
is this test? Is this test1? Is this text3?

note :here would be the value of this tags below
test1 test2 test3


Thanks,
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top