Instead of dateformat try createodbcdate(now()) Cutter
Scott Wilhelm wrote: >Can someone tell me what's wrong with this line: > > <CFQUERY name="PreviousDates" datasource="calendar"> > SELECT * FROM Events WHERE eDate < <CFQUERYPARAM >value=#formatdate(now(),"mm-dd-yy")#> > </CFQUERY> > >I can't figure out how to get a date query to work right... > >Thanks, > >Scott > > -----Original Message----- > From: Costas Piliotis > Sent: Mon 01/13/2003 01:01 PM > To: CF-Talk > Cc: > Subject: RE: ASP to ColdFusion > > > > Woo hoo... Another convert :-) > > A quick search on google gets some good introductury >tutorials... > > >http://hotwired.lycos.com/webmonkey/programming/coldfusion/tutorials/tut >oria > l2.html > http://www.macromedia.com/support/coldfusion/tutorial_index.html > http://kongtechnology.com/index.asp?im=cf1 > > > > -----Original Message----- > From: Scott Wilhelm [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 13, 2003 9:53 AM > To: CF-Talk > Subject: ASP to ColdFusion > > > I'm originally an ASP developer now working with >ColdFusion...Does anyone > know of any resources that would help in the conversion? >(ASP->CF > translations, tutorials, etc.) > > Thanks, > > Scott > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4