Told you its been a few years. Earlier post worked prior to Y2K lol
Just tried it and the following works:
select * from table1 where mydate >{^2001-09-01}
date inputs as {^yyyy-mm-dd}
If I remember correctly ctod may fail on a two digit year depending on the
settings in Foxpro.
----- Original Message -----
From: "Chris Sinkwitz" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, December 14, 2001 9:16 AM
Subject: RE: Querying FoxPro Date
> 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
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
