Snippet Details

Snippet 49 of 58
Previous | 47 | 48 | 49 | 50 | 51 | Next
« Skip 5 | Skip 5 »

Snippets Exchange Home » ColdFusion » Search By Date

Submitted by :	Lawrence Cramer
WebSite:	Cartweaver - CF Cart Solution for Dreamweaver MX
Snippet Date:	26 December 2001
Version:	1.4
Total Downloads:	5474
Get it :
Tutorial/Information:	Not Available
Detailed Instructions:	View
Snippet problem?:	Send Report

Description:

Create a page that will search you database by date and return results in a table

Snippet Start:

Snippet End:

<CFIF IsDefined ("FORM.FRMYR") >

<CFQUERY NAME="rsByDate" DATASOURCE="**Your Datasource Name Here**">
	SELECT *
	FROM **Table To Search**
	WHERE Column To Search >= #CreateODBCDateTime(CreateDateTime(Form.frmYr, Form.frmMo, Form.frmDay, 0, 0, 0))#
	AND Column To Search <= #CreateODBCDateTime(CreateDateTime(Form.toYr, Form.toMo, Form.toDay, 23, 59, 59))#
	ORDER BY Column To Search
</CFQUERY>
</CFIF>

<table border="0" cellspacing="0" cellpadding="8" align="center" width="618">
  <form name="FORM" method="post" action="<cfoutput>#ThisPage#</cfoutput>">
    <tr> 
      <td height="48">         
        From
       <select name="frmMo">
          <option value="01" selected>Jan</option>
          <option value="02">Feb</option>
          <option value="03">Mar</option>
          <option value="04">Apr</option>
          <option value="05">May</option>
          <option value="06">Jun</option>
          <option value="07">Jul</option>
          <option value="08">Aug</option>
          <option value="09">Sep</option>
          <option value="10">Oct</option>
          <option value="11">Nov</option>
          <option value="12">Dec</option>
        </select>
          - 
        <select name="frmDay">
          <option value="01">01</option>
          <option value="02">02</option>
          <option value="03">03</option>
          <option value="04">04</option>
          <option value="05">05</option>
          <option value="06">06</option>
          <option value="07">07</option>
          <option value="08">08</option>
          <option value="09">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="25">24</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
          - 
        <select name="frmYr">
         <option value="2001" selected>2001</option>
          <option value="2002">2002</option>
          <option value="2003">2003</option>
        </select>

&nbsp; 
          
        <input type="hidden" name="frmHour" value="00">
        <input type="hidden" name="frmMinute" value="00">
        <input type="hidden" name="toSecond" value="00">
          &nbsp;&nbsp;to 
       <select name="toMo">
          <option value="01" selected>Jan</option>
          <option value="02">Feb</option>
          <option value="03">Mar</option>
          <option value="04">Apr</option>
          <option value="05">May</option>
          <option value="06">Jun</option>
          <option value="07">Jul</option>
          <option value="08">Aug</option>
          <option value="09">Sep</option>
          <option value="10">Oct</option>
          <option value="11">Nov</option>
          <option value="12">Dec</option>
        </select>
          - 
        <select name="toDay">
          <option value="01" selected>01</option>
          <option value="02">02</option>
          <option value="03">03</option>
          <option value="04">04</option>
          <option value="05">05</option>
          <option value="06">06</option>
          <option value="07">07</option>
          <option value="08">08</option>
          <option value="09">09</option>
          <option value="10">10</option>
          <option value="11">11</option>
          <option value="12">12</option>
          <option value="13">13</option>
          <option value="14">14</option>
          <option value="15">15</option>
          <option value="16">16</option>
          <option value="17">17</option>
          <option value="18">18</option>
          <option value="19">19</option>
          <option value="20">20</option>
          <option value="21">21</option>
          <option value="22">22</option>
          <option value="23">23</option>
          <option value="25">24</option>
          <option value="26">26</option>
          <option value="27">27</option>
          <option value="28">28</option>
          <option value="29">29</option>
          <option value="30">30</option>
          <option value="31">31</option>
        </select>
          - 
          
        <select name="toYr">
          <option value="2001" selected>2001</option>
          <option value="2002">2002</option>
          <option value="2003">2003</option>
        </select>
        <input type="hidden" name="toHour" value="23">
        <input type="hidden" name="toMinute" value="59">
        <input type="hidden" name="toSecond" value="59">
        <input type="submit" name="Submit" value="Get Records">
      </td>
    </tr>
  </form>
</table>

<CFIF IsDefined ("FORM.FRMYR") >
<table width="90%" border="0" cellspacing="0" cellpadding="2" align="center">
      
  <tr bgcolor="#003366" align="center"> 
    <td width="33%">Date</td>
    <td width="33%">Field Title</td>
    <td width="33%">Field Title 2
  </tr>

  <cfoutput query="rsByDate"> 
    <tr bgcolor="#IIF(CurrentRow MOD 2, DE('FFFFFF'), DE('CCCCCC'))#" align="center"> 
      <td width="33%"># LSDateFormat(rsByDate.Column To Search, 'MMMM DD, YYYY') #</td>
      <td width="33%">#rsByDate.**DB Field to display**#</td>
      <td width="33%">#rsByDate.**Second  DB Field to display**#
    </tr>
  </cfoutput> 
</table>
</CFIF>

::back to top::

Want to submit or track a Snippet?
Need an extension from the store?
Don't have a login?

Register Now!
Why register?

Cartweaver: E-Commerce Power for the ASP, ColdFusion, and PHP Developers

Cartweaver- Get your ASP, ColdFusion, or PHP store on the web faster than you thought possible!

::This page last modified 3/29/2013 at 14:12::

Copyright © 2001-2013 DreamweaverFAQ.com All Rights Reserved.
All brands, trademarks, tutorials, extensions, code, and articles are the property of their respective owners.
A production of Site Drive Inc.
Legal Notice | Privacy Policy | Disclaimer & Notice