I tested against an ntext field, rather than a varchar2(4000)
My test:
<CFQUERY NAME="test" DATASOURCE="judgeprofiles">
SELECT top 1 links2004
FROM judgeprofiles
where links2004 is not null
</CFQUERY>
<cfoutput>#len(test.links2004)#<br>
<cfif test.links2004 contains chr(13)>Got a CR</cfif><br>
<cfif test.links2004 contains chr(10)>Got a LF</cfif><br>
</cfoutput>
<br>
<cfquery name="test2" dbtype="query">select * from test</cfquery>
<cfoutput>#len(test2.links2004)#<br>
<cfif test2.links2004 contains chr(13)>Got a CR</cfif><br>
<cfif test2.links2004 contains chr(10)>Got a LF</cfif><br>
</cfoutput>
The answer on cf5.0:
363
Got a CR
Got a LF
363
Got a CR
Got a LF
The answer on cfmx 6.1:
363
Got a CR
Got a LF
363
Got a CR
Got a LF
Sorry to not find the same answer.
Just a suggestion, have you installed the newest versions/patches of cfmx?
Jerry Johnson
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]