running 6.0 here. I questioned my yesterday's sanity and tried it all again
today, same thing happened.
I'm not sure why there are hesitant to put 6.1 on here, but I did a workaround
by replacing the breaks with <BR>'s in the main query, so the QofQ won't strip
anything. Then because I'm doing pdf generation, I'm going to just replace
them back. Annoying but works, so at least I can move on.
Thanks again
-seth
-----Original Message-----
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:40 AM
To: CF-Talk
Subject: RE: query of query trimming?
On cf5 and cfmx 6.1 the string lengths are the same from a direct call and a
qoq call.
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]
