(example of where)
$resultset = $schema->resultset('Table')->search({ 'primary_key' =>
"value_you_want" }); <==== you can have any key .....
another...
$resultset = $schema->resultset('Table')->search(
{ 'column_name'=> "value_u_want" }, <------where
{
select => [ qw/columns,,,/ ] <display columns.....
}
);
then run a while loop on resultset to get actual data.
while ($record = $resultset->next ()){
$var1 = $record->get_column("column_name1");
$var2 = $record->get_column("column_name2");
};
----- Original Message -----
From: Mark Haney <ma...@abemblem.com>
To: dbi-users@perl.org
Cc:
Sent: Wednesday, February 8, 2012 9:56 AM
Subject: Using DBIx Resultset and queries
I'm not new to DB's or to building queries of all shapes and sizes. I'm
also pretty conversant in perl's basic database connectivity. However,
I'm trying to find a good tutorial (or something) on how to use queries
with DBIx.
I've inherited a database where the DBIx resultset is simply dumping the
entire contents of the table to html and I don't want that. The problem
is I can't find anything remotely useful to tell me how to get started
implementing SQL options (WHERE, GROUP BY, etc) in that structure. I've
read it can me done, but darned if I know how.
Can anyone throw me a bone?
