Last time something like that happened to me I realized that in the stored
proc I put in the wrong number of characters id:
@MacroName VARCHAR(50) instead of @MacroName VARCHAR(500)
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 17, 2003 1:51 PM
To:
Are you using CFMX? I've had that problem using WDDX packets in client vars
that are stored in the DB because the Java type that CFMX uses is/was (fixed
yet? dunno) not large enough to handle the string. Perhaps you are having
the same issue.
+---+
John,
I have had this problem more than once.
Which DBMS are you using?
--
Jillian
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: June 17, 2003 12:33 PM
To: CF-Talk
Subject: RE: Data getting truncated on select
Yea I understand the problem you had
Using sql server 7.
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 20:14
To: CF-Talk
Subject: RE: Data getting truncated on select
John,
I have had this problem more than once.
Which DBMS are you using?
--
Jillian
-Original Message
File is averaging 264 k in size,
Using CFMX and ODBC.
-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 19:31
To: CF-Talk
Subject: RE: Data getting truncated on select
How big is this text object that is getting truncated? is it near 32K or 64K
in size
How big is this text object that is getting truncated? is it near 32K or 64K in size?
What version of CF?
What connectiontype are you using for that data source (ODBC or Native drivers)?
Jerry Johnson
[EMAIL PROTECTED] 06/17/03 02:22PM
Last time something like that happened to me I realized
Yea I understand the problem you had,
but I im not using VARCHAR, but TEXT which is fixed at 16
and has max characters of 2,147,483,647 characters.
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 19:23
To: CF-Talk
Subject: RE: Data getting truncated
Yep using CFMX,
the text strings are very big, pure html.
Perhaps you are having
the same issue.
How did you get round this Bryan?
-Original Message-
From: Bryan Love [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 19:56
To: CF-Talk
Subject: RE: Data getting truncated on select
Are you
Subject: RE: Data getting truncated on select
Using sql server 7.
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 20:14
To: CF-Talk
Subject: RE: Data getting truncated on select
John,
I have had this problem more than once.
Which
Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 20:42
To: CF-Talk
Subject: RE: Data getting truncated on select
I see that you may have an answer to your problem from another fellow, but a
few suggestions (my problems were with PostgreSQL and MySQL):
- Have you double checked
In CFMX.
--
Jillian
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]
Sent: June 17, 2003 1:53 PM
To: CF-Talk
Subject: RE: Data getting truncated on select
- Have you double checked that in the administrator you
have long text
return enabled? Without
Jillian Your a god damn star!!
Thank you. Problem is solved.
-Original Message-
From: Jillian Carroll [mailto:[EMAIL PROTECTED]
Sent: 17 June 2003 21:22
To: CF-Talk
Subject: RE: Data getting truncated on select
In CFMX.
--
Jillian
-Original Message-
From: John McCosker
12 matches
Mail list logo