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/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]
