[Dbix-class] Paging problem

e.post_weight, me.unit, me.pallet_id FROM barcoding:weights me WHERE ( ( sample_dt >= ? OR sample_dt <= ? ) ) '2012-02-28T10:04:00', '2012-02-29T10:04:00', '5', '15' As the bind parameters are in the wrong order the query fails. Has anyone else had thi

[Dbix-class] RE: Paging problem

parameters May I suggest having a special "projection_bind" that SkipFirst and FirstSkip push onto, and _assemble_binds looks at first? Kind regards, Paul Findlay DISCLAIMER This email contains information that is confidential and which may be legally privileged. If you have received thi

[Dbix-class] RE: Paging problem

Sorry, for the repeat self-replies, but it appears to already been fixed: https://github.com/dbsrgits/dbix-class/commit/8b31f62e2b395fba451c32e0bbfecbd3e0f673f8 Any idea when a new release will be out? Kind regards, Paul Findlay DISCLAIMER This email contains information that is confidential

RE: [Dbix-class] list 2 columns for all records in table not working

ed: foreach my $item (@items) { print $item->itemid, ' ', $item->artistid, "\n"; } Instead? This is documented in "Basic Usage" https://metacpan.org/module/DBIx::Class::Manual::Intro#Basic-usage (sorry about the HTML email everyone) Paul Findlay Proc

RE: [Dbix-class] how to build this query? col1 not like "%xx%" AND col1 like "%yy%"

Hi Rajeev, Not sure what you have tried, but this should work: my $rs_1 = $rs->search({ col1 => { -not_like => "%xx%", -like => "%yy%" } }); Then to do extra searches on the result set, just call search again. my $rs_2 = $rs_1->search({ col1 => { -not_like => '%zz%" }}); Documentation for

RE: [Dbix-class] how to empty a Table? when there is no primary key

> I tried to use delete_all, but there is no primary key in the table so it > failed. what else can i do? There is a discussion in the manual about this: https://metacpan.org/module/DBIx::Class::Manual::Intro#The-Significance-and-Importance-of-Primary-Keys But you could alternatively use $schema

RE: [Dbix-class] why is this returning an hash?

You will get back an array of Db::Schema::Result::Mytable items. So you could then do.. # if we have any items, output the status of the first one if (@item_array) { print $item_array[0]->item_status(), "\n"; } Kind regards, Paul Findlay DI

RE: [Dbix-class] How do I get DBIx::Class to quote User table and user collum in SQL Server ?

gt; .', LongTruncOk=>1, LongReadLen=>5000, on_connect_do => q{}, quote_char => [qw/[ ]/], name_sep => q{.}, } Kind regards, Paul Findlay DISCLAIMER This email contains information that is confidential and which may be leg

[Dbix-class] namespace::clean problems

Hi, I have started to see failed import errors after upgrading DBIx-Class to 0.08250: "-cleanee" is not exported by the namespace::clean module "DBIx::Class::Schema" is not exported by the namespace::clean module "carp" is not exported by the namespace::clean module "carp_once" is not exporte

RE: [Dbix-class] namespace::clean problems

Thanks Peter. After emailing the list I stumbled upon https://rt.cpan.org/Ticket/Display.html?id=86267 So added "use namespace::clean;" above the BEGIN block in DBIx::Class::Carp and the problem went away. Kind regards, Paul DISCLAIMER This email contains information that is confidential and

RE: [Dbix-class] namespace::clean problems

Great, thanks. Is the fix in git or available as a path? Kind regards, Paul DISCLAIMER This email contains information that is confidential and which may be legally privileged. If you have received this email in error, please notify the sender immediately and delete the email. This email is i

Re: [Dbix-class] DBIx JOIN issue in New version

Hi Sheeju, I believe you need to update the SQL::Abstract module as well. Kind regards, Paul Findlay From: Sheeju Alex [mailto:sheeju...@gmail.com] Sent: Wednesday, 12 February 2014 12:27 a.m. To: dbix-class@lists.scsys.co.uk Subject: [Dbix-class] DBIx JOIN issue in New version After