2 Replies Latest reply on Oct 12, 2006 10:24 AM by shastamatt

    syntax error??

    shastamatt
      Hello All,

      I am sure one of you have had to run in to this before.

      I have a table which records contacts with clients...I currently have id's of users who recorded the contact, of course i need names. I am getting the following error..

      Error Executing Database Query.
      [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot create a row of size 8141 which is greater than the allowable maximum of 8060.


      Thanks for your help...
        • 1. Re: syntax error??
          paross1 Level 2
          Does this work any better?

          Set UserName='#getnames.firstname#'+' '+'#getnames.lastname#'

          Also, the maximum Bytes per row for SQL Server is 8060, so if the total number of bytes in all of the columns exceeds this value, you will get the error (excludes columns of text and image, etc.)

          Phil
          • 2. Re: syntax error??
            shastamatt Level 1
            Ah.....thanks Phil...

            The set issue will believe that the variables are numbers and throw an error, that one i already tried....but the juicy bit of info ont he max row will make me not allow users to be deleted but wil become inactive...