There is no error it just hangs completely. If I do the exact same query in
RDS it brings back no records. I did find out what the problem is it's the
left() function. Description is a memo field if that even makes any
difference. Dave Watts, any suggestions?
Bob Everland
-----Original Message-----
From: pan [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 5:26 PM
To: CF-Talk
Subject: Re: Wierdest Access problem ever
From: "Robert Everland" <[EMAIL PROTECTED]>
> I am thinking MDAC. This is the original code that froze up CF. Could be
> MDAC or CF
>
I can't see anything immediate in the code ...
(might try adding a ; after the final </cfif>)
Might save some time if you deconstruct the query
section by section until you get to a part that works and
then build it back up until an error appears.
Just comment out clauses and keep moving the
<!---,--->.
I know that's a brute force method, but it is sure.
If it is a dataype matching problem, this method will
show it fairly quickly.
You loaded MDAC 2.6?
What is the exact error message?
pan
////////////////////////
<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>
/////////////////////////
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]