Hello,
I've just started using Catalyst, and therefore DBIx::Class, and I am running
into a problem I hope someone can help me with.
I am connecting from an Ubuntu server (specs below) via unixODBC to a MSSQL
2000 database. Everything works fine until my comment field contains more than
80 (single byte) characters. I've defined the comment field as a varchar(255),
nvarchar(255), and text to no avail.
Right now, my __PACKAGE__->add_columns is just a list of the columns, but I've
tried specifying the data_type and size with no luck as well.
###
__PACKAGE__->add_columns(qw/commentid calendarid sectionid termid taskid
comment/);
###
Here is my result set search:
###
my $comment_rs = $c->model('MMSDData::Comments')->search({
calendarid => $calendarid,
sectionid => $sectionid,
termid => $termid,
taskid => $taskid,
});
###
DBIC_TRACE gives me:
###
SELECT [me].[commentid], [me].[calendarid], [me].[sectionid], [me].[termid],
[me].[taskid], [me].[comment] FROM [scoreCommenterComments] [me] WHERE (
[calendarid] = ? AND [sectionid] = ? AND [taskid] = ? AND [termid] = ? ):
'1677', '302098', '574', '1002'
Use of uninitialized value in join or string at
/usr/share/perl/5.8/Carp/Heavy.pm line 125.
###
... which is obviously not very helpful since Carp::Heavy is not happy with
whatever it got.
The query works fine through unixODBC's isql utility tool.
Specs:
Ubuntu 8.04
unixODBC 2.2.11
FreeTDS 0.82
Perl v5.8.8 built for i486-linux-gnu-thread-multi
Catalyst::Runtime 5.70
DBIx::Class 0.08010
DBIx::Class::Storage::DBI::ODBC::Microsoft_SQL_Server ... up to date
Microsoft SQL Server 2000
Thanks in advance!
Chris
Chris Burch
Data Analyst/Web Programmer
Planning/Research & Evaluation
Madison Metropolitan School District
(608) 663-1916
[email protected]
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
