This is the mail archive of the
xsl-list@mulberrytech.com
mailing list .
RE: Complex expression problem...
- To: "'xsl-list at mulberrytech dot com'" <xsl-list at mulberrytech dot com>
- Subject: RE: Complex expression problem...
- From: Jonathan Asbell <jonathana at raremedium dot com>
- Date: Fri, 24 Mar 2000 18:23:15 -0500
- Reply-To: xsl-list at mulberrytech dot com
My code is below and the parser says the result can not be converted to a
node set
<xsl:variable name="path" select="/customers/customer"/>
<xsl:for-each select="
$path/customer_id[contains(.,$_id)]
and
$path/company_name[contains(.,$_company)]
and
$path/contact_name[contains(.,$_contact)]
and
$path/contact_title[contains(.,$_title)]
and
$path/address[contains(.,$_address)]
and
$path/city[contains(.,$_city)]
and
$path/region[contains(.,$_region)]
and
$path/postal_code[contains(.,$_postal)]
and
$path/country[contains(.,$_country)]
and
$path/phone[contains(.,$_phone)]
and
$path/fax[contains(.,$_fax)]
">
-----Original Message-----
From: Steve Muench [mailto:smuench@us.oracle.com]
Sent: Friday, March 24, 2000 5:27 PM
To: xsl-list@mulberrytech.com
Subject: Re: Complex expression problem...
<xsl:for-each
select="/customers/customer[starts-with(name,'a')
and
starts-with(city,'b')
and
starts-with(zip,'9')]">
:
:
</xsl:for-each>
Although, if you'll be doing this over thousands of
customers *AND* you are already pulling the customer
information from a database, you might want to
push this query through and let your database filter
the rows *before* rendering the resulting matches
as XML to make things go a lot faster...Just a thought,
and might not apply to your situation, but seemed
like it was worth suggesting...
______________________________________________________________
Steve Muench, Lead XML Evangelist & Consulting Product Manager
Business Components for Java Dev't Team, Oracle Corporation
----- Original Message -----
From: "Jonathan Asbell" <jonathana@raremedium.com>
To: <xsl-list@mulberrytech.com>
Sent: Friday, March 24, 2000 2:12 PM
Subject: Complex expression problem...
| How do I say
|
| __________________________________
| for each customer where....
| the value of "name" begins with "a"
| and
| the value of "city" begins with "p"
| and
| the value of "zip" begins with "9"
| output their field values
| (that is for each one that matches the criteria, give me their records)
| __________________________________
|
|
| the xml is below.....
|
|
| <customers>
| <customer>
| <customer_id>ALFKI</customer_id>
| <company_name>Alfreds Futterkiste</company_name>
| <contact_name>Maria Anders</contact_name>
| <contact_title>Sales Representative</contact_title>
| <address>Obere Str. 57</address>
| <city>Berlin</city>
| <region></region>
| <postal_code>12209</postal_code>
| <country>Germany</country>
| <phone>030-0074321</phone>
| <fax>030-0076545</fax>
| </customer>
| <customer>
| <customer_id>AROUT</customer_id>
| <company_name>Around the Horn</company_name>
| <contact_name>Thomas Hardy</contact_name>
| <contact_title>Sales Representative</contact_title>
| <address>120 Hanover Sq.</address>
| <city>London</city>
| <region></region>
| <postal_code>WA1 1DP</postal_code>
| <country>UK</country>
| <phone>(171) 555-7788</phone>
| <fax>(171) 555-6750</fax>
| </customer>
|
| etc.......
|
| </customers>
|
|
| XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list