Wrong sort and distainct-values result in nested queryes - parameters passing problems
"Paul Veuve" <[email protected]> Wed, 28 Jun 2006 16:48:29 +0200
| Newsgroups | gmane.comp.web.query-languages |
|---|---|
| Message-ID | <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAApjCnyF7N0xG6TgBglxc1jcKAAAAQAAAAFDPWfEkLskCpzeJXt8AmEAEAAAAA@cdisa.ch> |
This is a multi-part message in MIME format.
------=_NextPart_000_008A_01C69AD2.AF29F510
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hello,
I have a problem with nested queryes, sort don't work in a function.
Something is wrong in the function call or parameters passing
Query 1 display a successful sort by @REF without procedure
Query 2 display a faulty sort in the procedure local:Order()
What is what is wrong in the sort procedure or procedure call ?
I receive the same result with xmlspy or stylus studio. Something is wrong
in the code
Thanks for your help.
Flat.xml CONTENT -----------------------
----------------------------------------
<x>
<y QTY="1" REF="_T111"/>
<y QTY="2" REF="_T1121"/>
<y QTY="6" REF="_T13"/>
<y QTY="6" REF="_T113"/>
<y QTY="3" REF="_T13"/>
</x>
This Query 1 display a successful sort by @REF without procedure
for $Flat in doc("/db/Flat.xml")/x/y
for $Ordered in $Flat
order by $Ordered/@REF
return $Ordered
QUERY 1 RESULT ----------------------- OK
-----------------------------------------
<y QTY="1" REF="_T111"/>
<y QTY="2" REF="_T1121"/>
<y QTY="6" REF="_T113"/>
<y QTY="6" REF="_T13"/>
<y QTY="3" REF="_T13"/>
Query 2 display a faulty sort in the procedure local:Order()
------------------------------------------------------------
declare function local:Order($CompIn as node()*) as node()*
{
for $x in $CompIn
order by $x/@REF
return $x
};
for $Flat in doc("/db/Flat.xml")/x/y
let $Ordered := local:Order($Flat)
return $Ordered
QUERY 2 RESULT ----------------------- SHOULD BY SORTED BY BREF BUT IS NOT
--------------------------------------------------------------------------
<y QTY="1" REF="_T111"/>
<y QTY="2" REF="_T1121"/>
<y QTY="6" REF="_T13"/>
<y QTY="6" REF="_T113"/>
<y QTY="3" REF="_T13"/>
Paul Veuve
<mailto:[email protected]> [email protected]
CDI CONSEILS ET DEVELOPPEMENTS
INDUSTRIELS SA
Chemin de la Justice 15
CH-2000 NEUCHATEL
http://www.cdisa.ch
Phone (+41 32) 733 31 31 or (+41 78) 600 31 31
Fax (+41 32) 733 31 32
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: 26.06.2006
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.9.5/377 - Release Date: 27.06.2006
------=_NextPart_000_008A_01C69AD2.AF29F510
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Lucida Console";
panose-1:2 11 6 9 4 5 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
span.c9y6tc1
{color:blue;}
span.c4zssg1
{color:purple;}
span.cluy21
{color:#EA8F0F;}
span.c18yc01
{color:#D00020;}
span.c5m9s01
{color:#000090;}
span.c50hz41
{color:teal;}
span.cn9ii1
{color:#EA8F10;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DFR link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>Hello,<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>I have a problem with nested queryes, =
sort
don’t work in a function. Something is wrong in the function call =
or
parameters passing<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>Query 1 display a successful sort by @REF =
without
procedure <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>Query 2 display a faulty sort in the procedure
local:Order()<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>What is what is wrong in the sort procedure or
procedure call ?<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>I receive the same result with xmlspy or =
stylus
studio. Something is wrong in the code<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'>Thanks for your =
help.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DFR-CH =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DFR-CH =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>Flat.xml
CONTENT ----------------------- <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>----------------------------------------<o:p></o:p>=
</span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'><x><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'> <y QTY=3D"1"
REF=3D"_T111"/><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'> <y QTY=3D"2"
REF=3D"_T1121"/><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'> <y QTY=3D"6"
REF=3D"_T13"/><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'> <y QTY=3D"6"
REF=3D"_T113"/><o:p></o:p></span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'> <y QTY=3D"3"
REF=3D"_T13"/> <o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'></x><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>This
Query 1 display a successful sort by @REF without procedure =
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'>for $Flat in =
doc("/db/Flat.xml")/x/y</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> for $Ordered in =
$Flat<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> =
order by $Ordered/@REF<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> =
return $Ordered<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'><o:p> </o:p></span></font></span></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>QUERY
1 RESULT ----------------------- OK</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>-----------------------------------------<o:p></o:p=
></span></font></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'><</span></font></span><span class=3Dcluy21><font =
size=3D2
color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'>y </span></font></span><span =
class=3Dc18yc01><font
size=3D2 color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;
font-family:"Lucida =
Console";color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>"1"</span></font></span><span
class=3Dc18yc01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida Console";color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>"_T111"</span></font></span><span
class=3Dc18yc01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>/</span></font></span><span
class=3Dc9y6tc1><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>></span></font></span><font
size=3D2 color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;
font-family:"Lucida Console";color:black'><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"2"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T1121"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"6"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T113"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"6"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T13"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"3"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T13"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span>
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DEN-US style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>Query
2 display a faulty sort in the procedure </span></font><font size=3D2
color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'>local:Order()<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>---------------------------------------------------=
---------</span></font><font
size=3D2 color=3Dblack face=3D"Lucida Console"><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:"Lucida =
Console";color:black'><o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'>declare function local:Order($CompIn as node()*) as =
node()*</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'>{<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> =
for $x in $CompIn<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> =
order by $x/@REF<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> =
return $x<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'>};<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'><o:p> </o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'>for $Flat in =
doc("/db/Flat.xml")/x/y<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> let $Ordered
:=3D =
local:Order($Flat)<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'> return =
$Ordered<o:p></o:p></span></font></span></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span lang=3DFR-CH =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'><o:p> </o:p></span></font></span></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>QUERY
2 RESULT ----------------------- SHOULD BY SORTED BY BREF BUT IS =
NOT</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
lang=3DFR-CH style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>---------------------------------------------------=
-----------------------<o:p></o:p></span></font></p>
<p class=3DMsoNormal><span class=3Dc9y6tc1><font size=3D2 color=3Dblack
face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:"Lucida Console";
color:black'><</span></font></span><span class=3Dcluy21><font =
size=3D2
color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;font-family:
"Lucida Console";color:black'>y </span></font></span><span =
class=3Dc18yc01><font
size=3D2 color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;
font-family:"Lucida =
Console";color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>"1"</span></font></span><span
class=3Dc18yc01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida Console";color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>"_T111"</span></font></span><span
class=3Dc18yc01><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>/</span></font></span><span
class=3Dc9y6tc1><font size=3D2 color=3Dblack face=3D"Lucida =
Console"><span
style=3D'font-size:10.0pt;font-family:"Lucida =
Console";color:black'>></span></font></span><font
size=3D2 color=3Dblack face=3D"Lucida Console"><span =
style=3D'font-size:10.0pt;
font-family:"Lucida Console";color:black'><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"2"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T1121"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"6"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T13"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"6"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T113"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span><br>
<span class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'><</span></font></span><span
class=3Dcluy21><font color=3Dblack><span style=3D'color:black'>y =
</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>QTY=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"3"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span style=3D'color:black'> =
REF=3D</span></font></span><span
class=3Dc5m9s01><font color=3Dblack><span =
style=3D'color:black'>"_T13"</span></font></span><span
class=3Dc18yc01><font color=3Dblack><span =
style=3D'color:black'>/</span></font></span><span
class=3Dc9y6tc1><font color=3Dblack><span =
style=3D'color:black'>></span></font></span>
<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DEN-US =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span lang=3DFR-CH =
style=3D'font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Paul
Veuve<br>
</span></font><a href=3D"mailto:[email protected]"><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>[email protected]</span></font></=
a><o:p></o:p></p>
<p><strong><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial'>CDI CONSEILS ET DEVELOPPEMENTS</span></font></b></strong><b><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;font-weight:
bold'><br>
<strong><b><font face=3DArial><span =
style=3D'font-family:Arial'>INDUSTRIELS =
SA</span></font></b></strong></span></font></b><font
size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'><br>
Chemin de la Justice 15<br>
<strong><b><font face=3DArial><span style=3D'font-family:Arial'>CH-2000 =
NEUCHATEL</span></font></b></strong></span></font><o:p></o:p></p>
<p><strong><b><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;font-weight:normal'>http://www.cdisa.ch</span></font></b></strong><=
b><span
style=3D'font-weight:bold'><o:p></o:p></span></b></p>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Phone
(+41 32) 733 31 31 or (+41 78) 600 31 31</span></font><o:p></o:p></p>
<p><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial'>Fax
(+41 32) 733 31 32</span></font><o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
lang=3DFR-CH
style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>
<BR>
<P><FONT SIZE=3D2>--<BR>
No virus found in this outgoing message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.1.394 / Virus Database: 268.9.5/376 - Release Date: =
26.06.2006<BR>
</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial"> </FONT> </P><BR>
<P><FONT SIZE=3D2>--<BR>
No virus found in this incoming message.<BR>
Checked by AVG Free Edition.<BR>
Version: 7.1.394 / Virus Database: 268.9.5/377 - Release Date: =
27.06.2006<BR>
</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial"> </FONT> </P>
------=_NextPart_000_008A_01C69AD2.AF29F510--