I am thinking MDAC. This is the original code that froze up CF. Could be
MDAC or CF
<cfquery name="SearchResult" datasource="Supports" dbtype="ODBC">
SELECT DISTINCT problemlog.TICKET AS ResultField1,
problemlog.DATE AS ResultField2,
problemlog.TIME AS ResultField3,
problemlog.REQNAME AS ResultField4,
left(problemlog.description,40) AS
ResultField5,
problemlog.TICKET AS ID_Field
FROM problemlog
Where 1=1
<CFIF not len(FORM.CRIT1_VALUE) EQ 0>
And problemlog.ticket = #Form.Crit1_Value#
</CFIF>
<CFIF not len(FORM.CRIT2_VALUE) EQ 0>
And problemlog.reqname like '%#Form.Crit2_Value#%'
</CFIF>
</cfquery>
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 4:53 PM
To: CF-Talk
Subject: Re: Wierdest Access problem ever
[aliasing left function call in select]
> In the real query I do this, it is access 97 with the latest CF and
lastest
> MDAC.
>
I just happen to have a box with Acc97 still on it and the code
works the same as with Acc2k.
Maybe something else in the "real query" ?
Post more code and I (or someone else) will look at it.
Are you thinking mdac?
pan
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]