home *** CD-ROM | disk | FTP | other *** search
/ io Programmo 68 / IOPROG_68.ISO / soft / Tools / rmtrackv1.0.2.exe / FilterWizard.asp < prev    next >
Encoding:
Text File  |  2003-01-12  |  16.0 KB  |  167 lines
  1. <%@ LANGUAGE = VBScript.Encode %>
  2. <HTML>
  3. <HEAD>
  4. <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
  5. <TITLE>Help</TITLE>
  6. <LINK rel="stylesheet" type="text/css" href="../../Styles.css">
  7. </HEAD>
  8. <BODY <%#@~^XQAAAA==~b0~"+$E+kYc}EDz?DDrUT`JgGSbx3kEbP{PrFEPO4x~IdwKxdncDrOPEK}Ktb]Vqg'!a6,]qVCPHzI!(g'!aaJ,qh0AAA==^#~@%>>
  9. <P>
  10. <TABLE border=0 cellPadding=2 cellSpacing=0 width="100%">
  11.   <TR>
  12.     <TD nowrap bgColor=#CEDBE7 colSpan=3><FONT class=menulink color=#ffffff 
  13.       size=4>Filter Details</FONT></TD>
  14.       <%#@~^MQAAAA==~b0~M+$E+kYc5EDz/DDrUT`JgGSbx3kEbP@!@*,JqJ~O4+UPhA8AAA==^#~@%>
  15.       <td align=right nowrap bgColor=#CEDBE7><FONT class=menulink color=#ffffff 
  16.       size=4><A class=menulink href='../Contents.asp?StartOn=User/FilterWizard.asp' style="text-decoration:underline">Contents</a>  <A class=menulink href='../About.asp' style="text-decoration:underline">About</a></FONT></TD>
  17.       <%#@~^CAAAAA==~x[,k6PZgIAAA==^#~@%>
  18.     </TR>
  19.   <TR vAlign=top>
  20.     <TD colSpan=3></TD></TR>
  21. </TABLE>
  22. </P>
  23. <P><FONT class=box size=2>To define your new filter first select a value from the "Field" drop down, 
  24. then select a condition ("contains", "between", etc.) and then select 
  25. a value. Finally click "Add to list" to add the new condition to the 
  26. criteria. A filter can contain multiple lines of selection criteria.
  27. </FONT></p>
  28. <P><FONT class=box size=2>To modify a line of the criteria, select the line in the list, click "Modify",
  29. then change the field, condition or value and when satisfied with your changes 
  30. click "Update".
  31. </FONT></p>
  32. <P><FONT class=box size=2>Any filters that you create are unique to your User id.</FONT></p>
  33. <P>
  34. <TABLE border=0 cellPadding=2 cellSpacing=0 width="100%">
  35.   <TR>
  36.     <TD nowrap bgColor=#CEDBE7 colSpan=3><FONT class=menulink color=#ffffff 
  37.       size=4>Advanced Filters</FONT></TD>
  38.     </TR>
  39.   <TR vAlign=top>
  40.     <TD colSpan=3></TD></TR>
  41. </TABLE>
  42. </P>
  43. <P><FONT class=box size=2>Advanced filters are defined as the "WHERE" component of a standard SQL statement.
  44. You need to be very familiar with SQL and selecting data to full utilize advanced filters. These books may be of some assistance <a class=box href='http://www.amazon.com/exec/obidos/ASIN/0201447878/qid=1011468757/sr=1-9/ref=sr_1_79_9/104-8435482-8234366'>The Practical Sql Handbook : Using Structured Query 
  45. Language</a> and <a class=box href='http://www.amazon.com/exec/obidos/ASIN/0201433362/qid=1011468757/sr=1-16/ref=sr_1_79_16/104-8435482-8234366'>SQL Queries 
  46. for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL</a>.</p>
  47.  
  48. <P><FONT class=box size=2>Note that dates are stored in the database as a date value and a time value combined. The time value is always set 
  49. to 00:00:00, as if everything takes place just after midnight. For example 
  50. "DateOpened = '10-Jan-2002'" will return all issues that where opened on the 
  51. 10th of January regardless the time of day. </FONT></P>
  52. <P><FONT class=box size=2> The "GetDate()" function always returns 
  53. the current date AND time. Compare the date opened against GetDate() will always 
  54. fail to match because of the time component. To use GetDate() it is best to use 
  55. the following expression 'convert(varchar(11), GetDate())'.</FONT><FONT class=box size=2>To filter all issues closed between today and two days 
  56. ago use this criteria: 'DateClosed between convert(varchar(11), GetDate()) and 
  57. convert(varchar(11), DateAdd(day, -2, GetDate()))'.</FONT></P>
  58.  
  59. <table border=0 width=100%>
  60. <tr>
  61. <TD nowrap bgColor=#CEDBE7 colSpan=4><FONT class=menulink color=#ffffff 
  62.       size=4>Common SQL Functions (click for documentation)</FONT></TD>
  63. </tr>
  64. <tr>
  65. <td valign=top>
  66. <table border=0 class=box>
  67. <tr><td class=FormLabels style="BORDER-BOTTOM: #6294cd 1px solid">Operators</td></tr>
  68. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_3vtw.asp'>and</a></td></tr>
  69. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_oa-oz_8hte.asp'>or</a></td></tr>
  70. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_nos-nz_3l10.asp'>not</a></td></tr>
  71. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_8him.asp'>in</a></td></tr>
  72. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_8him.asp'>not in</a></td></tr>
  73. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_7o6m.asp'>between</a></td></tr>
  74. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_9wfg.asp'>is null</a></td></tr>
  75. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_9wfg.asp'>is not null</a></td></tr>
  76. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_115x.asp'>like</a></td></tr>
  77. </table>
  78. <br>
  79. <table border=0 class=box>
  80. <tr><td class=FormLabels style="BORDER-BOTTOM: #6294cd 1px solid">Date Functions</td></tr>
  81. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_3vtw.asp'>dateadd()</a></td></tr>
  82. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_2mic.asp'>datepart()</a></td></tr>
  83. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_5vxi.asp'>datediff()</a></td></tr>
  84. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_1dph.asp'>datename()</a></td></tr>
  85. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_2oqh.asp'>day()</a></td></tr>
  86. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ga-gz_4z51.asp'>getdate()</a></td></tr>
  87. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ma-mz_0j8o.asp'>month()</a></td></tr>
  88. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ya-yz_0ab6.asp'>year()</a></td></tr>
  89. </table>
  90. </td>
  91.  
  92. <td valign=top>
  93. <table border=0 class=box>
  94. <tr><td class=FormLabels style="BORDER-BOTTOM: #6294cd 1px solid">String Functions</td></tr>
  95. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_6wfd.asp?frame=true'>ascii()</a></td></tr>
  96. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_6xte.asp?frame=true'>char()</a></td></tr>
  97. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_3ins.asp?frame=true'>charindex()</a></td></tr>
  98. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_8co5.asp?frame=true'>difference()</a></td></tr>
  99. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_left_7910.asp?frame=true'>left()</a></td></tr>
  100. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_3e7i.asp?frame=true'>len()</a></td></tr>
  101. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_1pki.asp?frame=true'>lower()</a></td></tr>
  102. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_9dbh.asp?frame=true'>ltrim()</a></td></tr>
  103. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_na-nop_25gy.asp?frame=true'>nchar()</a></td></tr>
  104. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pa-pz_28xk.asp?frame=true'>patindex()</a></td></tr>
  105. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_76lh.asp?frame=true'>replace()</a></td></tr>
  106. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_93ad.asp?frame=true'>replicate()</a></td></tr>
  107. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_6xid.asp?frame=true'>reverse()</a></td></tr>
  108. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_45tg.asp?frame=true'>right()</a></td></tr>
  109. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_6xm5.asp?frame=true'>rtrim()</a></td></tr>
  110. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_3o6w.asp?frame=true'>soundex()</a></td></tr>
  111. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_2jvp.asp?frame=true'>space()</a></td></tr>
  112. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_412q.asp?frame=true'>str()</a></td></tr>
  113. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_6sbq.asp?frame=true'>stuff()</a></td></tr>
  114. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_6btz.asp'>substring()</a></td></tr>
  115. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_7g11.asp?frame=true'>unicode()</a></td></tr>
  116. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ua-uz_325u.asp?frame=true'>upper()</a></td></tr>
  117. </table>
  118. </td>
  119.  
  120. <td valign=top>
  121. <table border=0 class=box>
  122. <tr><td class=FormLabels style="BORDER-BOTTOM: #6294cd 1px solid">Math Functions</td></tr>
  123. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_2far.asp?frame=true'>abs()</a></td></tr>
  124. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_5a5v.asp?frame=true'>acos()</a></td></tr>
  125. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_6ofi.asp?frame=true'>asin()</a></td></tr>
  126. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_6r72.asp?frame=true'>atan()</a></td></tr>
  127. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_aa-az_6rsi.asp?frame=true'>atn2()</a></td></tr>
  128. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_7ko7.asp?frame=true'>ceiling()</a></td></tr>
  129. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2m9f.asp?frame=true'>cos()</a></td></tr>
  130. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2m9g.asp?frame=true'>cot()</a></td></tr>
  131. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_8m2b.asp?frame=true'>degrees()</a></td></tr>
  132. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ea-ez_2t0w.asp?frame=true'>exp()</a></td></tr>
  133. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_6lo2.asp?frame=true'>floor()</a></td></tr>
  134. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_3ep3.asp?frame=true'>log()</a></td></tr>
  135. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_la-lz_08ds.asp?frame=true'>log10()</a></td></tr>
  136. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pa-pz_8hux.asp?frame=true'>pi()</a></td></tr>
  137. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_pa-pz_033m.asp?frame=true'>power()</a></td></tr>
  138. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_95rn.asp?frame=true'>radians()</a></td></tr>
  139. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_0mec.asp?frame=true'>rand()</a></td></tr>
  140. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_93z8.asp?frame=true'>round()</a></td></tr>
  141. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_6xm6.asp?frame=true'>sign()</a></td></tr>
  142. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_40j2.asp?frame=true'>sin()</a></td></tr>
  143. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_55k5.asp?frame=true'>square()</a></td></tr>
  144. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_7ng4.asp?frame=true'>sqrt()</a></td></tr>
  145. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ta-tz_43am.asp?frame=true'>tan()</a></td></tr>
  146. </table>
  147. </td>
  148.  
  149. <td valign=top>
  150. <table border=0 class=box>
  151. <tr><td class=FormLabels style="BORDER-BOTTOM: #6294cd 1px solid">Other functions</td></tr>
  152. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5t9v.asp?frame=true'>case</a></td></tr>
  153. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp?frame=true'>cast()</a></td></tr>
  154. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp?frame=true'>convert()</a></td></tr>
  155. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_9dph.asp?frame=true'>coalesce()</a></td></tr>
  156. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_9dph.asp?frame=true'>datalength()</a></td></tr>
  157. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_8ov9.asp?frame=true'>isdate()</a></td></tr>
  158. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_6mek.asp?frame=true'>isnull()</a></td></tr>
  159. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ia-iz_7pcz.asp?frame=true'>isnumeric()</a></td></tr>
  160. <tr><td><a class=box2 target='_blank' href='http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_nos-nz_3uhy.asp?frame=true'>nullif()</a></td></tr>
  161. </table>
  162. </td></FONT>
  163.     <P></P>
  164. <P></P></tr></table>
  165. </BODY>
  166. </HTML>
  167.