Re:

["Steve Muench" <smuench@xxxxxxxxxxxxx>]

Let's say you have a "dept.xsql" page like:

 <?xml version="1.0"?>
 <?xml-stylesheet type="text/xsl" href="dept.xsl"?>
 <query>
   select deptno, dname from dept
 </query>

and an "emp.xsql" page like:

 <?xml version="1.0"?>
 <?xml-stylesheet type="text/xsl" href="e,dept.xsl"?>
 <query>
   select empno, ename, sal from emp
   where deptno = {@d}
 </query>

Then in your dept.xsl stylesheet, to create
a HREF what links to the emp.xsql page to
show the employees in that department you'd
put:

    <xsl:for-each select="ROWSET/ROW">
      <a href="emp.xsql?d={DEPTNO}">
        <xsl:value-of select="DEPTNO"/>
      </a>
    </xsl:for-each>

This will generate hyperlinks whose
text is the department number and
whose (relative URL) HREF will look
like (e.g. for department 10)...

  emp.xsql?d=10

clicking on that link will show the
XSLT formatted results for the employees
in department 10.

In the future, you might send XSQL-specific
questions to the Oracle XML Discussion Forum
on Oracle Technet (http://technet.oracle.com)

Thanks.

_________________________________________________________
Steve Muench, Consulting Product Manager & XML Evangelist
Business Components for Java Development Team
http://technet.oracle.com/tech/java
http://technet.oracle.com/tech/xml
----- Original Message -----
From: "Shanthi Rajaram" <shanthi@xxxxxxx>
To: <xsl-list@xxxxxxxxxxxxxxxx>
Sent: Thursday, December 16, 1999 4:25 PM


Hi,

I am a newbie wrt both XML and XSL + XSQL.

Now I have some simple problems, I will be very thankful if you can help me
out.

1) I have some fields which are there for select, based on only those fields
which are filled out, I want to form the select statement in the XSQL what
to do for the same

2) I have a list of records that are returned, I would like to href the
first field on the column so that on the click of that field I can go to a
detailed screen for that particular record.

If any body needs the code that I am using I can send it across, but I will
be happy if I can be helped at the earliest.

Thanking you,
Shanthi



 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list