FAQ

Search Discussions

17 discussions - 48 posts

  • Hi, I've seen examples of searching in a database using the LIKE operator like: $rs = $rs- search( { name = { -like = "%$name%" }, } ); It doesn't look to be very secure to quote the variable $name ...
    Octavian RasnitaOctavian Rasnita
    Oct 8, 2012 at 7:49 am
    Oct 9, 2012 at 8:04 am
  • I have a Postgres table with a timestamp field that defaults to the current time: CREATE TABLE "notes" ( "id" SERIAL PRIMARY KEY NOT NULL, "note" TEXT, "created" TIMESTAMP NOT NULL DEFAULT ...
    Robert RothenbergRobert Rothenberg
    Oct 30, 2012 at 12:47 pm
    Oct 30, 2012 at 1:06 pm
  • I'm running ActivePerl v5.16.1 on Win2008 R2 x64. Anyone see the below error message before? Running same script on x86 machine produces no such error. P:\test perl "test.pl" Can't locate object ...
    Paul RogersPaul Rogers
    Oct 10, 2012 at 3:26 am
    Oct 11, 2012 at 2:58 pm
  • I am only intending to update a column in a row based on 'item' value. Item value is unique constraint column. DBIx code: $schema- resultset('Itemlist')- update( { item = $item, item_comment = ...
    Rajeev PrasadRajeev Prasad
    Oct 4, 2012 at 12:22 am
    Oct 4, 2012 at 4:45 pm
  • Hi, yesterday I have released the initial version of DBIx::Table::TestDataGenerator, see http://search.cpan.org/~jds/DBIx-Table-TestDataGenerator-0.001/ Its goal is to support testing database ...
    José Diaz SengJosé Diaz Seng
    Oct 29, 2012 at 9:58 pm
    Oct 30, 2012 at 9:38 am
  • Dear DBIx-Class mailing list Hereby we'd like to inform you about a new package related to DBIx::Class. Its objective is to bring efficient and convenient methods for dealing with Lookup Tables. We ...
    Uro shimaUro shima
    Oct 18, 2012 at 8:35 am
    Oct 18, 2012 at 10:33 am
  • this straight lift from documentation is not working. what could i be doing wrong? my @all_artists = $schema- resultset('Artist')- search(undef, { columns = [qw/name artistid/], }); my query is: my ...
    Rajeev PrasadRajeev Prasad
    Oct 16, 2012 at 11:27 pm
    Oct 17, 2012 at 4:43 am
  • Hello All, I've just shipped a dev rel that fixes the menagerie of fun issues we got with the previous release and SQLite on various configurations. Assuming we don't get black smoke in the next day ...
    fREW SchmidtfREW Schmidt
    Oct 15, 2012 at 2:17 pm
    Oct 15, 2012 at 2:54 pm
  • Dear All, I have bit of SQL (mysql) which joins three tables to get all the records form the first table and sums from the 2 remaining tables. The SQL looks like: select t1.*, t2_total, t3_total from ...
    ScottScott
    Oct 5, 2012 at 10:02 am
    Oct 5, 2012 at 4:41 pm
  • Hi, I would like to inflate a column value from json to perl-Hash , but only if another column has a certain value. Do I have acces to the whole fetched row from within inflate_colum ? Rolf ...
    Rolf SchaufelbergerRolf Schaufelberger
    Oct 29, 2012 at 5:47 pm
    Oct 30, 2012 at 2:35 am
  • Greetings! We have found out that the number of CachedKids hash elements becomes too big during the life cycle of the DBIx::Class object. How can we limit it to avoid memory usage growth? Thank you! ...
    Dmitry BelyavskyDmitry Belyavsky
    Oct 26, 2012 at 7:26 am
    Oct 26, 2012 at 7:30 am
  • I have a legacy database that has Date type data in the local timezone rather than UTC. As such I have these statements in my class definitions: "creation_date", { data_type = "DATE", timezone = ...
    Neil.lunnNeil.lunn
    Oct 17, 2012 at 1:34 pm
    Oct 18, 2012 at 12:39 am
  • Hello, I guess a very basic question. In the following example: from http://search.cpan.org/~mstrout/DBIx-Class-0.08202/lib/DBIx/Class/ResultSet.pm my @cds = $cd_rs- search({ year = 2001 }); # ".. ...
    Rajeev PrasadRajeev Prasad
    Oct 9, 2012 at 2:57 pm
    Oct 9, 2012 at 3:13 pm
  • I've just released Search::Query::Dialect::DBIxClass to CPAN [1]. It uses Search::Query to parse a query string and transforms it into a hashref than can be passed to $rs- search(_rs). The ...
    Alexander HartmaierAlexander Hartmaier
    Oct 29, 2012 at 3:53 pm
    Oct 29, 2012 at 3:53 pm
  • Ok, this release has what 0.08202_01 had in it; so it should fix the SQLite connection regressions on all platforms. -- fREW A non-text attachment was scrubbed... Name: signature.asc Type ...
    fREW SchmidtfREW Schmidt
    Oct 18, 2012 at 6:33 pm
    Oct 18, 2012 at 6:33 pm
  • I fail to implement the following scenario properly with DBIC -) There are Users. -) A User has_many Tests. -) A Test has_many Steps. -) Steps have a 'type' attribute. -) A Step of type 'SubTest' ...
    David SchmidtDavid Schmidt
    Oct 16, 2012 at 6:37 pm
    Oct 16, 2012 at 6:37 pm
  • Hi all - I'm trying to install the latest version of DBIx::Class via cpanm. I'm running perl 5.14 under Ubuntu 12.04. The installation fails with: -- Working on DBIx::Class Fetching ...
    Alan HumphreyAlan Humphrey
    Oct 6, 2012 at 4:40 am
    Oct 6, 2012 at 4:40 am
Group Navigation
period‹ prev | Oct 2012 | next ›
Group Overview
groupdbix-class @
categoriesperl, catalyst
discussions17
posts48
users27
websitedbix-class.org
irc#dbix-class

27 users for October 2012

fREW Schmidt: 6 posts Alexander Hartmaier: 5 posts Rajeev Prasad: 5 posts José Diaz Seng: 4 posts Peter Rabbitson: 3 posts Octavian Rasnita: 2 posts Paul Rogers: 2 posts Robert Rothenberg: 2 posts Aaron Crane: 1 post Alan Humphrey: 1 post Bill Moseley: 1 post Bob MacCallum: 1 post Dave Howorth: 1 post David Schmidt: 1 post Dmitry Belyavsky: 1 post Drew Taylor: 1 post Hailin Hu: 1 post Ian Docherty: 1 post Neil.lunn: 1 post Octavian Rasnita: 1 post
show more
Archives