PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: leew at resport dot rch dot gs dot com (William Lee)
Subject: Re: Problem with large text fields
Date: Jan 31 1996 3:18PM

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)