Couple of things to try,
Access will accept "yes/no" or "1/0" depending on what you've selected
in the design of the DB.
default is "yes/no" (I think).
wrap up the now() in "CreateODBCDate()" and see if that clears it up.
It's been ages since I've touched Access.
Aaron Rouse wrote:
> 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:312425
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
