<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title>
myOffice Email Message
</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="date" content="2002-11-01">
<style type="text/css">
</style>
</head>
<body>
<span style=
"color:#FF0000 "><b><span style=
"font-family:MS Sans Serif ">[Reply]</span></b></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">HI Jeremy,</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">First off, what are you really wanting? .... from what I can see the query is asking is if any of the content between START and END lies within the specified range ....22/2 - > 26/2.</span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"color:#000000 ">Viewing it pictorially .. x denotes the START END range</span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "> 20 21 </span></span></span><span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#FF0000 "><b>22 23 24 25 26</b></span><span style=
"color:#000000 "> 27</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> x x fail</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> </span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> x x x x accept</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> </span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> x x x accept</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> </span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> x x x x accept</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> </span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> x fail</span></span></span>
<p>
<span style=
"font-family:Courier,monospace "><span style=
"font-size:8pt; "><span style=
"color:#000000 "> </span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "> </span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">here goes:</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">select ...</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">where ( END>=#22 FEB 2010 00.00.00# and END <=#26 FEB 2010 00.00.00# )</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">or ( START>=#22 FEB 2010 00.00.00# and START<=#26 FEB 2010 00.00.00# )</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">Note this is untested, but should get you in the right direction.</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">HTH</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">Gary</span></span></span>
<p>
<span style=
"color:#000000 "><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; ">A</span></span></span><span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#FF0000 "><b>t 09:52 on 31/01/2010 you wrote </b></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>To : delphi@delphi.org.nz</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>CC : </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>From: Jeremy Coulter, jscoulter@gmail.com</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Content Type: text/html</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Attached: </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>This is a multipart message in MIME format.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Hi All.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>I am the stage with problem that SOMEONE who's a bit more lateral thinking</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>than me might be able to see the solution.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>I have the following data (just a snapshot).</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Item Start End</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>1 15 Feb 2010 26 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>2 22 Feb 2010 26 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>3 15 Feb 2010 29 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>4 24 Feb 2010 25 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>5 23 Feb 2010 25 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>6 24 Feb 2010 31 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>7 22 Feb 2010 26 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>8 23 Feb 2010 24 Feb 2010</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>What I am doing is TRYING to find all items that fall between a given date</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>range.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>In this case I am trying to find all the items between the 22 Feb and 26</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Feb.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>i.e. all of the items should be returned in the above snap shot.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>I am trying the following where clause (not real field names):-</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>WHERE (#22 FEB 2010 13.00.00# Between START And END)</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>AND (#26 FEB 2010 10.00.00# Between START And END)</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>However, that missed out Items 1,34,5,6 and I think 8.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>If I try:</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>WHERE START >=#22 FEB 2010 13.00.00# And ENDTIME <=#26 FEB 2010 10.00.00# </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>It misses out 1,3 and 6</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>I cant go</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>WHERE START >=#22 FEB 2010 13.00.00# or ENDTIME <=#26 FEB 2010 10.00.00# as</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>that returns to many records.</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Can anyone see what I am missing? I don't mind if I have to do it in</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>separate queries as I can just union them, but I have been looking at this</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>too long and I just cant figure it out, so I thought another set of eyes</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>might help J</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Thanks, Jeremy</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">> </span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">></span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>_______________________________________________</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>NZ Borland Developers Group - Delphi mailing list</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Post: delphi@delphi.org.nz</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Admin: http://delphi.org.nz/mailman/listinfo/delphi</span></span></span>
<p>
<span style=
"font-family:MS Sans Serif "><span style=
"font-size:10pt; "><span style=
"color:#008000 ">>Unsubscribe: send an email to delphi-request@delphi.org.nz with Subject: unsubscribe</span></span></span><p>
<font face=arial size = 1 color = Navy><font color=gray face = "helvetica,verdana,arial" size = 1><br>
<font size=2 color="black">Gary Benner </font><br>
Director <a HREF="http://www.semantic.co.nz" style="text-decoration:none; color:teal">Semantic Limited</a> - Software Development & Systems Design, Online Education, e-Commerce<br>
Director <a HREF="http://www.123.net.nz" style="text-decoration:none; color:blue">123 Internet Limited</a> - Managed Web Hosting, Virtualisation, High Availability Systems & Cluster Technologies<br>
<b>Mob:</b> 021 966 992<br>
<b>DDI:</b> +64 7 543 1206<br>
<b>Email:</b> <a href="mailto:gary@benner.co.nz" >gary@benner.co.nz</a><br>
<b>Skype:</b> garybenner<br>
</font><br>
<br>
Ref#: 41006<br>
<br>
</body>
</html>