Using 1 instead of Yes throws an error if I remember correctly because that
was one of my first guesses as well. I am going to try some of these ideas
this afternoon once I have access to it again(work got canceled due to
hurricane Ike).
On Fri, Sep 12, 2008 at 8:27 AM, Mark Kruger <[EMAIL PROTECTED]> wrote:
>
> My guess would be the bit column... Use a 0 or 1....
>
>
> UPDATE FAILUREREPORT
> SET STR_DISPOSITION = 'SCRAP'
> WHERE STR_DISPOSITION IS NULL
> AND INT_PARTRETURNED = 1
> AND DT_PARTRETURNED IS NOT NULL
> AND DATEDIFF("d", DT_PARTRETURNED, NOW()) > 30
>
> You might also try "= NULL" instead of "IS NULL". The driver is being
> particular.
>
>
>
> -Mark
>
>
>
> Mark A. Kruger, CFG, MCSE
> (402) 408-3733 ext 105
> www.cfwebtools.com
> www.coldfusionmuse.com
> www.necfug.com
>
> -----Original Message-----
> From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Thursday, September 11, 2008 10:09 PM
> To: CF-Talk
> Subject: Re: CF and Access
>
> Yeah, the function is an Access function, just has the same name as CF. I
> thought maybe the Yes/No column was throwing it off initially and tried a
> cfqueryparam on that one but it helped none. I did not play with the date
> though and will see if maybe that is the root of it.
>
> On Thu, Sep 11, 2008 at 7:35 PM, Matt Quackenbush
> <[EMAIL PROTECTED]>wrote:
>
> > No problem with using DateDiff() as he is using it, since it is not
> > surrounded by #. It has been a bazillion years since I've used
> > Access, but as I recall, that particular error message has something
> > to do with a lack of quotes (e.g. 'foo') on a field that the driver
> > wants them on. Maybe the date field? Can't remember for sure.
> >
> >
> > On Thu, Sep 11, 2008 at 7:28 PM, Mike Little wrote:
> >
> > > at a rough guess, i suspect that you cannot use an explicit cf
> > > function such as datediff in the query.
> > >
> >
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
