Home. 
Search
.

transparent
transparent
transparent
  Library.Mailing List Archive

Altova Mailing List Archives


Re: conflicting operators

From: Sharon Steringa <esdeees@-------.--->
To: NULL
Date: 6/4/2004 1:02:00 AM
This is a multi-part message in MIME format

------=_NextPart_000_43017768
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit

Okay thanks, I had already tried that with the exclamation mark and the
equals sign in the right place (sorry I mistyped it :-)) but the
starts-with()function does not work for me with this select query, so I
have to type in the complete value to get the filtered records in my
table but I want it to work as well when I only type in the first few
characters of a value. How can I get the starts-with() function to work?
Thanks!

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

------=_NextPart_000_43017768
Content-Type: text/html; name="_alt.0"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment; filename="_alt.0"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4=2E0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html;=
 charset=3Diso-8859-1">
<META content=3D"MSHTML 6=2E00=2E2900=2E2096" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>It is possible abter all=
 :)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Following is the simplified example=
 that should 
give you an idea:</FONT></DIV><FONT size=3D2>
<DIV><FONT face=3DArial>
<HR>
</FONT></DIV>
<DIV><FONT face=3DArial>XSL:</FONT></DIV>
<DIV></FONT><FONT face=3DArial size=3D2>&lt;xsl:stylesheet 
version=3D"1=2E0"<BR>&nbsp;xmlns:xsl=3D"</FONT><A 
href=3D"http://www=2Ew3=2Eorg/1999/XSL/Transform"><FONT face=3DArial 
size=3D2>http://www=2Ew3=2Eorg/1999/XSL/Transform</FONT></A><FONT=
 face=3DArial 
size=3D2>"<BR>&nbsp;xmlns:msxsl=3D"urn:schemas-microsoft-com:xslt"<BR=
>&nbsp;exclude-result-prefixes=3D"msxsl"&gt;</FONT></DIV>
<DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2></FONT><FONT size=3D2></FONT><BR><FONT face=3DArial=
 
size=3D2>&lt;xsl:template 
match=3D"/root"&gt;<BR>&lt;root&gt;<BR>&nbsp;&lt;xsl:variable 
name=3D"trio"&gt;<BR>&nbsp;&nbsp;&lt;xsl:call-template 
name=3D"doA"&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;xsl:with-param=
 name=3D"this" select=3D"a[1]" 
/&gt;<BR>&nbsp;&nbsp;&nbsp;&lt;xsl:with-param name=3D"bCount"=
 select=3D"0" 
/&gt;<BR>&nbsp;&nbsp;&lt;/xsl:call-template&gt;<BR>&nbsp;&lt;/xsl=
:variable&gt;<BR>&nbsp;&lt;xsl:for-each 
select=3D"msxsl:node-set($trio)//trio"&gt;<BR>&nbsp;&nbsp;&lt;set&g=
t;<BR>&nbsp;&nbsp;&nbsp;&lt;xsl:copy-of 
select=3D"a"/&gt;<BR>&nbsp;&nbsp;&lt;/set&gt;<BR>&nbsp;&lt;/xsl:for=
-each&gt;<BR>&lt;/root&gt;<BR>&lt;/xsl:template&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&lt;xsl:template 
name=3D"doA"&gt;<BR>&nbsp;&lt;xsl:param name=3D"this"=
 /&gt;<BR>&nbsp;&lt;xsl:param 
name=3D"bCount" /&gt;<BR>&nbsp;&lt;xsl:if 
test=3D"$this"&gt;<BR>&nbsp;&nbsp;&lt;xsl:choose&gt;<BR>&nbsp;&nbsp=
;&nbsp;&lt;xsl:when 
test=3D"count($this/b) &amp;lt; 
$bCount"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:copy-of=
 select=3D"$this" 
/&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:call-template 
name=3D"doA"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:with-para=
m name=3D"this" 
select=3D"$this/following-sibling::a[1]" 
/&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:with-param=
 name=3D"bCount" 
select=3D"$bCount - count($this/b)" </FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial 
size=3D2>/&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/xsl:call-template&gt=
;<BR>&nbsp;&nbsp;&nbsp;&lt;/xsl:when&gt;<BR>&nbsp;&nbsp;&nbsp;&lt=
;xsl:otherwise&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;trio&gt;<BR>&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:call-template 
name=3D"doA"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:wit=
h-param 
name=3D"this" select=3D"$this" 
/&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;xsl:with-param=
 name=3D"bCount" 
select=3D"4" 
/&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/xsl:call-template&gt;=
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&lt;/trio&gt;<BR>&nbsp;&nbsp;&nbsp;&l=
t;/xsl:otherwise&gt;<BR>&nbsp;&nbsp;&lt;/xsl:choose&gt;<BR>&nbsp;=
&lt;/xsl:if&gt;<BR>&lt;/xsl:template&gt;<BR>&nbsp;&nbsp;<BR>&lt;/=
xsl:stylesheet&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<HR>
XML:</FONT></DIV>
<DIV>
<DIV><FONT face=3DArial><FONT 
size=3D2>&lt;root&gt;<BR>&lt;a&gt;<BR>&nbsp;&lt;b&gt;1&lt;/b&gt;<BR=
>&nbsp;&lt;b&gt;2&lt;/b&gt;<BR>&lt;/a&gt;<BR>&lt;a&gt;<BR>&nbsp;&=
lt;b&gt;3&lt;/b&gt;<BR>&nbsp;&lt;b&gt;4&lt;/b&gt;<BR>&lt;/a&gt;<B=
R>&lt;a&gt;<BR>&nbsp;&lt;b&gt;5&lt;/b&gt;<BR>&nbsp;&lt;b&gt;6&lt;=
/b&gt;<BR>&lt;/a&gt;<BR>&lt;a&gt;<BR>&nbsp;&lt;b&gt;7&lt;/b&gt;<B=
R>&lt;/a&gt;<BR>&lt;a&gt;<BR>&nbsp;&lt;b&gt;8&lt;/b&gt;<BR>&lt;/a=
&gt;<BR>&lt;/root&gt;<BR></FONT><FONT 
size=3D2>
<HR>
Output:</FONT></FONT></DIV>
<DIV><FONT size=3D2></FONT><FONT face=3DArial=
 size=3D2>&lt;root&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;1&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;2&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;/a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;/set&gt;</FONT></DIV>
<DIV><FONT face=3DArial=
 size=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&lt;set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;3&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;4&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;/a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;/set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;5&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;6&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;/a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;7&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;/a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;/set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; &lt;b&gt;8&lt;/b&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &nbsp;&nbsp;&nbsp; 
&lt;/a&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp;&nbsp;=
 &lt;/set&gt;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>&lt;/root&gt;<BR>
<HR>
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT size=3D2><FONT size=3D3>
<DIV><FONT face=3DArial size=3D2>You just need to change a to=
 Products/ProductsItem 
and b to Identifiers/Identifier</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Have 
fun!</FONT></DIV></FONT></DIV></FONT></DIV></DIV></BODY></HTML>


------=_NextPart_000_43017768--


transparent
Print
Mail
Like It
Disclaimer
.

These Archives are provided for informational purposes only and have been generated directly from the Altova mailing list archive system and are comprised of the lists set forth on www.altova.com/list/index.html. Therefore, Altova does not warrant or guarantee the accuracy, reliability, completeness, usefulness, non-infringement of intellectual property rights, or quality of any content on the Altova Mailing List Archive(s), regardless of who originates that content. You expressly understand and agree that you bear all risks associated with using or relying on that content. Altova will not be liable or responsible in any way for any content posted including, but not limited to, any errors or omissions in content, or for any losses or damage of any kind incurred as a result of the use of or reliance on any content. This disclaimer and limitation on liability is in addition to the disclaimers and limitations contained in the Website Terms of Use and elsewhere on the site.

.
.

transparent
transparent
 
Company | Legal | Press | Partners | Careers | Sitemap | Contact Us | Altova Blog | Mobile | Full Site
 
Use of this site is governed by our Terms & Conditions and Privacy Policy Copyright 2005-2012 Altova. All Rights Reserved.
transparentGSA