On 11/29/00, Michael She penned:
> >This is what happens when non programmers pick up programming .. we miss
>>some of the basics along the way. I'm try to run a conditional select
>>based on the age of the time the entry was made into the dB (posting_time)
>>.. specifically I plan to offer the user a form to select all entries made
>>after a chosen date (cut_off_time)
>>
>>something to the affect of
>>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>> <cfset cut_of_time = #DateFormat(Form.date_entered)#>
>>
>> <cfquery name="acme" datasource="main">
>> SELECT *
>> FROM table
> > WHERE posting_time > #cut_off_time#
> > </cfquery>
Try using #createodbcdate(cut_off_time)#
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
