Hi,
Has anyone gotten DBIx::Class to work with an Ingres database using an ODBC
driver?
I get the following error on a simple search:
DBIx::Class::ResultSet::search(): DBI Exception: DBD::ODBC::db get_info
failed: [Ingres][Ingres ODBC Driver]Information type out of range
(SQL-HY096)
Class::DBI
Please connect to the database using plain DBI and give us the
output of:
$dbh-get_info(
$DBI::Const::GetInfoType::GetInfoType{SQL_DBMS_NAME}
);
Output is INGRES
--
View this message in context:
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577961.html
Sent
Can you please debug it and see why/how it fails (perhaps step through it
with the debugger or something). Then get us the actual info it
produces, and hopefully adding the extra informix driver won't be much
work.
Using the Perl debugger, it seems like the error begins at:
DBIC_TRACE=1 generates this:
Undefined subroutine Carp::longmess_heavy called at
/usr/lib/perl5/5.8.8/Carp.pm line 239.
In addition - what limit dialect does Ingress support? Is
it any of the already implemented ones [1] ? Note - we need limit *and*
offset support, limit alone won't cut it.
Yes, sorry about that. Ingres does support both OFFSET and LIMIT--Ingres'
equivalent for LIMIT is FIRST/NEXT, such as:
select * from table
offset 1
fetch first 10 rows only
--
View this message in context:
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577972.html
I appreciate the help up to this point, but still haven't got this working.
Any other ideas?
--
View this message in context:
http://dbix-class.35028.n2.nabble.com/DBIx-Class-with-ODBC-tp7577958p7577973.html
Sent from the DBIx-Class mailing list archive at Nabble.com.
Sorry Alex, I left out the '=' when I copied the query.
I tried the examples in the SQL::Abstract docs as well, but still in each
case, any multiple 'LOWER' functions gave an error.
I.E.: these work fine:
A) my @students = $schema-resultset( 'GraduateStudent' )-search(
Thanks for your help, Alex, but it didn't work.
I have a feeling it's related to the Ingres ODBC driver we're using. =(
--
View this message in context:
http://dbix-class.35028.n2.nabble.com/Best-practice-for-case-insensitive-searches-tp5963279p7578142.html
Sent from the DBIx-Class mailing
Hi everybody,
Does DBIx::Class allow relationships to be set up between two fields that
are two different sizes? We have a registration table and a class table
that are linked by term, course number, and section number. However, the
section number in one table has three digits, while the other