Hi all,
I have an Oracle table with 2 clob columns and I am trying to add a new record
in it, using:
my $row = $schema-resultset( 'TblName' )-create( {
question = 'This is the first question',
answer = 'Answer 1',
date_time_q = '2012-01-01 00:00:00',
date_time_a = '2012-01-01
Octavian Rasnita wrote:
Hi all,
I have an Oracle table with 2 clob columns and I am trying to add a new record
in it, using:
my $row = $schema-resultset( 'TblName' )-create( {
question = 'This is the first question',
answer = 'Answer 1',
date_time_q = '2012-01-01 00:00:00',
I have just learned, that the JOIN syntax was improved recently, so it
is possible to specify more than just the equality of column values, as
shown in the example from DBIx::Class::Relationship::Base:
My::Schema::Artist-has_many(
cds_80s = 'My::Schema::CD',
sub {
my $args = shift;
Am 29.01.2012 20:42, schrieb Bernhard Graf:
The example above still requires the bind values to be defined
statically in the schema. I couldn't find any examples, about how to
specify bind values at execution time - e.g. likes this:
My::Schema::Artist-has_many(
cds_era = 'My::Schema::CD',
sub
From: Peter Rabbitson rabbit+d...@rabbit.us
Octavian Rasnita wrote:
Hi all,
I have an Oracle table with 2 clob columns and I am trying to add a new
record in it, using:
my $row = $schema-resultset( 'TblName' )-create( {
question = 'This is the first question',
answer = 'Answer
Bernhard Graf wrote:
I have just learned, that the JOIN syntax was improved recently, so it
is possible to specify more than just the equality of column values, as
shown in the example from DBIx::Class::Relationship::Base:
My::Schema::Artist-has_many(
cds_80s = 'My::Schema::CD',
sub {
Bernhard Graf wrote:
Am 29.01.2012 20:42, schrieb Bernhard Graf:
The example above still requires the bind values to be defined
statically in the schema. I couldn't find any examples, about how to
specify bind values at execution time - e.g. likes this:
My::Schema::Artist-has_many(
cds_era =
Am 29.01.2012 21:52, schrieb Peter Rabbitson:
It is possible, but is not yet particularly pretty. The trick is
that the coderef in question is called every time the relationship
needs to be resolved. By referencing some external package-global
you can control what the coderef will return.
Correction:
$artist_rs-result_class-era_begin(1979);
$artist_rs-result_class-era_end(1990);
$artist_rs-search_related('cds_era')-next;
Bernhard
___
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN:
On Jan 29, 2012, at 11:42 AM, Peter Rabbitson wrote:
Crap! I would hazard a guess this is some subtle behavior change in
DBD::Oracle. In any case DBIC needs to move away from using the buggy
blob support in DBD::Oracle, and use the blob OCI calls directly.
I'll try to get on IRC tomorrow to
10 matches
Mail list logo