Kim,
I may have misunderstood your request. I assumed that you did not know how to
apply the != operator using Class::DBI.
Yes you need override the list subroutine for that table. Just comment out the
Pager code as below.
sub list : Exported {
my ( $self, $r ) = @_;
my $order = $self->order($r);
# $self = $self->do_pager($r); <--------- Remove this line
if ($order) {
$r->objects( [ $self->retrieve_all_sorted_by($order) ] );
}
else {
$r->objects( [ $self->retrieve_all ] );
}
}
Regards
Ian
>>> Kim Ryan <[EMAIL PROTECTED]> 23/02/06 11:11 AM >>>
Ian,
Not sure at what point I should apply the search_where method.
Do I need to define a subroutine to override the default list behavior
that would normally be applied to the table I want a custom query for?
Kim
Ian VanDerPoel wrote:
>Kim,
>
>Use something like this:
>
>$self->search_where( {code=>{'!='=>'1'}} )
>
>Overide the list and just return all the objects to the form.
>
>Hope this helps.
>
>Ian
>
>
>
>>>>Kim Ryan <[EMAIL PROTECTED]> 22/02/06 10:56 AM >>>
>>>>
>>>>
>Hi,
>
>I have an SQL query which uses operators such as != so I cannot
>compose a query using just the equality operators through a
>CGI request.
>
>Is there a way to display all the rows returned from an SQL
>statement? Can I could override the list method to do this?
>
>Regards,
>
>Kim
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
>for problems? Stop! Download the new AJAX search engine that makes
>searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
>http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
>_______________________________________________
>Maypole-users mailing list
>[email protected]
>https://lists.sourceforge.net/lists/listinfo/maypole-users
>
>
>
>This message (including any attachments) is intended solely for the addressee
>named and may contain confidential and privileged information. If you are not
>the intended recipient, please delete it and notify the sender.
>Views expressed in this message are those of the individual sender, and are
>not necessarily the views of the Independent Transport Safety and Reliability
>Regulator (ITSRR). Whole or parts of this e-mail may be subject to copyright
>of ITSRR or third parties. You should only re-transmit, distribute or use the
>material for commercial purposes if you are authorised to do so.
>
> Visit us at:
>
>www.transportregulator.nsw.gov.au or Telephone: (02) 8263 7100
>
>
>
>
>
This message (including any attachments) is intended solely for the addressee
named and may contain confidential and privileged information. If you are not
the intended recipient, please delete it and notify the sender.
Views expressed in this message are those of the individual sender, and are not
necessarily the views of the Independent Transport Safety and Reliability
Regulator (ITSRR). Whole or parts of this e-mail may be subject to copyright
of ITSRR or third parties. You should only re-transmit, distribute or use the
material for commercial purposes if you are authorised to do so.
Visit us at:
www.transportregulator.nsw.gov.au or Telephone: (02) 8263 7100
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid0944&bid$1720&dat1642
_______________________________________________
Maypole-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/maypole-users
