That works also. Thanks !
At 08:16 AM 12/14/2001 -0800, you wrote:
>No no FoxPro is all foxed up this is how you would have to query it.
>
> <cfquery name="getpo" datasource="PO">
> select ponumber, supplier,odr_date
> from purchase
> where odr_date > ctod('12/10/01')
> </cfquery>
>
>
>-----Original Message-----
>From: Don Vawter [mailto:[EMAIL PROTECTED]]
>Sent: Friday, December 14, 2001 9:13 AM
>To: CF-Talk
>Subject: Re: Querying FoxPro Date
>
>
>It's been a few years but I think this might work
>
> <cfquery name="getpo" datasource="PO">
> select ponumber, supplier,odr_date
> from purchase
> where odr_date > {12/10/2001}
> </cfquery>
>
>----- Original Message -----
>From: "Michael Haggerty" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Friday, December 14, 2001 8:34 AM
>Subject: RE: Querying FoxPro Date
>
>
> > Just a stab in the dark, is that the query you are actually running? The
> > double quotes before the date are actually a pair of single quotes.
> >
> > I have no experience with FoxPro, but the query you posted will not run
> > under SQL Server. Change the single quotes to read like this and you
>should
> > be alright:
> >
> > WHERE odr_date > '12/10/01'
> >
> > Mike
> >
> >
> > -----Original Message-----
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, December 13, 2001 4:35 PM
> > To: CF-Talk
> > Subject: Querying FoxPro Date
> >
> >
> > How can you select records for a FoxPro date by using date?
> >
> > The query:
> >
> > <cfquery name="getpo" datasource="PO">
> > select ponumber, supplier,odr_date
> > from purchase
> > where odr_date > ''12/10/01"
> > </cfquery>
> >
> >
> > It returns with the error:
> >
> > ODBC Error Code = 22005 (Error in assignment)
> > [Microsoft][ODBC Visual FoxPro Driver]Operator/operand type mismatch.
> >
> > In SQL, it works fine. But the DB will be in FoxPro
> >
> > When I select all and out the date, the date format is in yyyy-mm-dd. I
> > tried using that format, but no luch either.
> >
> > Any clues?
> >
> > Thanks
> > Jacob
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
