subject:"Coldfusion Intelligent Queries \?\?\?"

Re: Coldfusion & Intelligent Queries ???

2002-01-16 Thread Ian Vaughan

D/MM/') AND eventdate >= SysDate TIA Ian - Original Message - From: "Nick de Voil" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 12:04 PM Subject: Re: Coldfusion & Intelligent Queries ??? >

Re: Coldfusion & Intelligent Queries ???

2002-01-14 Thread Ian Vaughan

Hi Nick Thanks for that, it seems to be working! and yes it is an Oracle database , Thanks Ian - Original Message - From: "Nick de Voil" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 12:04 PM Subject: Re:

Re: Coldfusion & Intelligent Queries ???

2002-01-14 Thread Nick de Voil

Oracle, right? AND eventdate >= SysDate should do it Nick - Original Message - From: Ian Vaughan <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 11:48 AM Subject: Coldfusion & Intelligent Queries ??? > Hi > > How do I mo

Coldfusion & Intelligent Queries ???

2002-01-14 Thread Ian Vaughan

Hi How do I modify my query below, so that when an event date has passed it is no longer shown, so for example if an event was on January 12 2002, it would not show up in the results returned, it would only show the events happening from todays date i.e. January 14th. How could this feature b