sybperl-l Archive

From: <MAILER-DAEMON at analog dot com>
Subject: Undeliverable Message
Date: Jan 31 1996 5:41PM

To:            
Cc:            
Subject:       Re: Problem with large text fields

Message not delivered to recipients below.  Press F1 for help with VNM
error codes.               

	VNM3043:  Brian Palazini@TECH_SVCS@CORP_IS


VNM3043 -- MAILBOX IS FULL

   The message cannot be delivered because the
   recipient's mailbox contains the maximum number of 
   messages, as set by the system administrator.  The
   recipient must delete some messages before any
   other messages can be delivered.
   
   The maximum message limit for a user's mailbox is 
   10,000.  The default message limit is 1000 messages.  
   Administrators can set message limits using the 
   Mailbox  Settings function available in the 
   Manage User menu  (MUSER). 

   When a user's mailbox reaches the limit, the 
   user must delete some of the messages before 
   the mailbox can accept any more incoming messages.

----------------------  Original Message Follows  ----------------------Did you set the @@textsize in SYBASE ?  The default is 32K only.

On Jan 31, 10:03am, Denis J. O'Connell wrote:
} Subject: Re: Problem with large text fields
} > The malformed command header certainly comes from a Sybase error
} > displayed using the message handler, but without the appropriate
} >  tags. The error is probably due to the routines you use to
} > store the text.
} >
} > Can you post the code that you use to store the text (only that
} > portion should be necessary)
} >
}
} I am definitely using a "text" datatype in my Sybase Table.  My queries
(with
} the large amounts of text) work if I build them and use them on
command-line
} in Sybase, so I am thinking that the limit is either on the Sybperl
side, or
} the HTML side.
}
} Below is the code that I used to build the save query, and then execute
the
} query.  I used the cgi-lib.pl Perl library to ReadParse the input from
HTML
} into asscociative arrays called %in.
}
} Thanks,
} Denis
}
} $build="insert into Errors values (\"$in{'email'}\", $in{'people_id'},
\
} "$date\", ";
} @order=('desc', 'version', 'module', 'behavior', 'errortext', 'brief',
} 'status', 'workaround', 'comments');
}
} foreach $i (@order) {
}     if ($i eq "comments") {
}           if($in{$i}eq'null'){
}               $build=$build." NULL";
}           }
}           else {
}               $build=$build." \"$in{$i}\""; }
}      }
}      elsif ($in{$i}eq'null') {
}        $build=$build." NULL,";
}      }
}      else {
}        $build=$build." \"$in{$i}\",";
}      }
} }
} $build=$build.")";
}
} &dbcmd($dbproc, "$build");
} &dbsqlexec($dbproc);
} &dbresults($dbproc);
}
}         Denis J. O'Connell       \_  \_  \_       denis@natural.com
}   Natural Intelligence, Inc.     \_\_\_  \_       tel (617) 876-7680
x1257
}                                  \_ \__  \_       fax (617) 492-7425
}                                  \_  \_  \_
}-- End of excerpt from Denis J. O'Connell



-- 
William  Lee
Sybase Database Administrator
Investment Research Dept, Goldman Sachs, New York
leew@rch.gs.com
1 (212) 902-8125 (desk)
1 (212) 902-3398 (fax)
1 (800) 509-0759 (pager)	
1 (800) 800-7759 (alpha pager)