t: 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:
SELECT top 1 links2004
FROM judgeprofil
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:
SELECT top 1 links2004
FROM judgeprofiles
where links2004 is not null
#len(test.links2004)#
Got a CR
Got a LF
select * fro
If you're running 6.0, there are a lot of issues fixed in 6.1. This
could be one of them. Perhaps updating would fix it.
John
-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:28 AM
To: CF-Talk
Subject: RE: query of query tri
CFMX 6.0 on Win2k
Think moving it to Linux would change anything?
-seth
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:26 AM
To: CF-Talk
Subject: RE: query of query trimming?
Seth,
What version of CF?
Jerry Johnson
>>&g
Seth,
What version of CF?
Jerry Johnson
>>> [EMAIL PROTECTED] 03/16/04 05:35PM >>>
>Think anyone could give it a try for me? Just put some carriage returns at
>the start of a field, then have two queries, one pulling it out direct, then
>another a QofQ on that one.
[Todays Threads]
[This Mes
of a field, then have two queries, one pulling it out direct, then
another a QofQ on that one.
-seth
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 5:25 PM
To: CF-Talk
Subject: RE: query of query trimming?
What data-type is the object in yo
What data-type is the object in your db?
What is the len() of that field on your sample direct call record?
What is the len() of that field on your sample QofQ record?
Are you doing anything in your QofQ to change the data in the field itelf?
Are you sure the record you are getting back for the
Yeah, I grabbed the first, but it was different when I did a QofQ
Very annoying
-seth
-Original Message-
From: Burns, John D [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 5:06 PM
To: CF-Talk
Subject: RE: query of query trimming?
You can try looping over each character to see
2004 5:01 PM
To: CF-Talk
Subject: RE: query of query trimming?
Unfortunately yes, I'm sure. I did a QofQ then a direct query, and they
were different, the direct query returned 13, the QofQ returned like 83,
the ascii value of T(the first letter in the string)
-seth
-Original Message
I meant, I did an asc(first(myString)) and it returned those values
-Original Message-
From: Turetsky, Seth [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 5:01 PM
To: CF-Talk
Subject: RE: query of query trimming?
Unfortunately yes, I'm sure. I did a QofQ then a direct
esday, March 16, 2004 4:31 PM
To: CF-Talk
Subject: Re: query of query trimming?
Are you sure they have a chr(13) (Carriage Return).
It might have just a line feed (chr(10)).
Try replacing chr(10) instead.
Jerry Johnson
_
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubs
Are you sure they have a chr(13) (Carriage Return).
It might have just a line feed (chr(10)).
Try replacing chr(10) instead.
Jerry Johnson
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
Looks like when I run a query of query, it's stripping out some carriage
returns(which I need). Has anyone else seen this, known thing?
Example:
PASSWORD="#app_passwd#">
select text1
from myView
where key = 100
select text1
from mainQuery
where detail_key = 1
PASSWORD="#app_passwd#">
13 matches
Mail list logo
