2009/4/3 mohanprasad <mo...@thebizmo.com>: > > hello everybody, > > i am trying to provide a select box in a html form. > All the options should come database using DBIC. > I want to filter the database entries fetched using DBIC. > >From the documentation > >http://search.cpan.org/~cfranks/HTML-FormFu-Model-DBIC-0.03007/lib/HTML/FormFu/Model/DBIC.pm > > i got to know i can make use of condition attribute to filter the results > >fetched using DBIC. > Documentation is telling condition will work similar to 1st arguement in > search method on a result set. > my code is as follows: > > --- > action: > auto_fieldset: 1 > auto_id: '%f_%n' > elements: > - type: Select > name: media_type > label: 'select media type:* ' > model_config: > model: Database::mediatype > label_column: name > id_column: name > condition: > name: 'video' > constraints: > - Required > > The above one will get all entries from mediatype table where name = 'video'. > could anybody let me know if i want to provide not condition (ex: name != > 'video') or a simple where clause like(ex: (field1 = 'value1' OR filed2 != > 'value2') how should i do that?
Hi, This is core DBIx::Class stuff. You should find examples for both of these in the docs for SQL::Abstract Cheers, Carl _______________________________________________ HTML-FormFu mailing list HTML-FormFu@lists.scsys.co.uk http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu Hi Carl, Thank you so much for the response. I have gone through SQL::Abstract documentation. Figured it out how to do the stuff. I have updated the code as follows and IT WORKS - type: Select name: media_type label: 'select media type:* ' model_config: model: Database::mediatype label_column: name id_column: name condition: name: '!=': 'video' constraints: - Required Best Regards, Mohan -- View this message in context: http://n2.nabble.com/providing-condition-attributes-for-Select-box-while-using-DBIC-tp2580015p2580138.html Sent from the HTML-FormFu mailing list archive at Nabble.com. _______________________________________________ HTML-FormFu mailing list HTML-FormFu@lists.scsys.co.uk http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/html-formfu
