sybperl-l Archive

From: dho at milton dot sbi dot com (Derek Ho)
Subject: Re: Problem with large text fields
Date: Jan 31 1996 4:09PM

Hi William,

	Do you go to Newtown recently?

-Derek Ho ( 212-783-1857 )
> From owner-sybperl-l@trln.lib.unc.edu Wed Jan 31 10:51:37 1996
> X-Listname: SybPerl Discussion List 
> Warnings-To: <>
> From: leew@resport.rch.gs.com (William Lee)
> Date: Wed, 31 Jan 1996 10:18:40 -0500
> To: SYBPERL-L@trln.lib.unc.edu
> Subject: Re: Problem with large text fields
> Cc: leew@rch.gs.com
> Mime-Version: 1.0
> 
> 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)
>