[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: Complex expression problem...
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@xxxxxxxxxxxxx] Sent: Friday, March 24, 2000 5:27 PM To: xsl-list@xxxxxxxxxxxxxxxx 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@xxxxxxxxxxxxxx> To: <xsl-list@xxxxxxxxxxxxxxxx> 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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|