I say you save the presentation until next month when I can make it...Just a suggestion...hahah
I am out of town :-( -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Patrick Steil Sent: Monday, September 13, 2004 3:44 PM To: [EMAIL PROTECTED] Subject: RE: SQL Server max row size? This is a SQL Server restriction... total length of all columns cannot exceed 8000 bytes... only it allows you to create them all day... For your particular problem, you probably want to convert to using TEXT fields instead of varchar(8000) fields... TEXT fields are actually stored apart from the data in the row so text fields don't hinder the 8000 byte limit or perhaps only eat up 16 bytes of it or something (just stores the pointer to the text, not the actual text in the row)... Patrick Steil CTO, InfraNET Enterprise Software Solutions � mailto:[EMAIL PROTECTED] - http://www.infranet.com voice://1-888-734-0949 x106 fax://972-692-7620 Enterprise Workflow Manager � Automate your Enterprise iiFramework � Secure Intranet Development Foundation -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matt Woodward Sent: Monday, September 13, 2004 8:03 AM To: [EMAIL PROTECTED] Subject: Re: SQL Server max row size? As far as I know this is either a SQL Server restriction or a restriction of the driver. I've also run into issues when you try to do ORDER BY in queries where the rows are larger than this roughly 8000 character limit. I'll be curious to see if there's any more information about this size restriction. Matt ----- Original Message ----- From: Kelly, Joe <[EMAIL PROTECTED]> Date: Fri, 10 Sep 2004 10:49:08 -0500 Subject: SQL Server max row size? To: [EMAIL PROTECTED] Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8816 which is greater than the allowable maximum of 8060. Does anybody know what to do about this error? I'm submitting one form with several text areas with lots of text into several varchar(8000) columns. Lessen the amount of text and it works OK. In the CF Administrator > Data Sources > Advanced Settings, I increased the Long Text Buffer from 64000 to 640000. Does CF need to be restarted for this to work? Any ideas? Thanks, Joe Kelly -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm ---------------------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
