RE: Data getting truncated on select

2003-06-17 Thread Janine Jakim
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:

RE: Data getting truncated on select

2003-06-17 Thread Bryan Love
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. +---+

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread Jerry Johnson
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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

RE: Data getting truncated on select

2003-06-17 Thread Jillian Carroll
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

RE: Data getting truncated on select

2003-06-17 Thread John McCosker
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