The following module was proposed for inclusion in the Module List: modid: DBIx::Composer DSLIP: adpOp description: Composing and executing of SQL statements userid: PLISCO (Igor Plisco) chapterid: 7 (Database_Interfaces) communities:
similar: rationale: Module DBIx::Composer composes SQL statements from parts (table name, field list, 'where' clause etc.). Then it can execute these statements. It makes SQL command composing more clear and convenient for common cases. Name DBIx::Composer is appropriate because 1) it deals with database and SQL, so should be under DBIx namespace, 2) its main task is _composing_ SQL statements from parts. Usage of module is like following: $cmd = new DBIx::Composer; $cmd->table = 'table1'; $cmd->fields = 'field1, field2'; $cmd->where = 'where field3 > 0'; @out = $cmd->selectrow_array; enteredby: PLISCO (Igor Plisco) enteredon: Wed Oct 29 12:06:26 2003 GMT The resulting entry would be: DBIx:: ::Composer adpOp Composing and executing of SQL statements PLISCO Thanks for registering, -- The PAUSE PS: The following links are only valid for module list maintainers: Registration form with editing capabilities: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=10500000_f18f8419fa516ee6&SUBMIT_pause99_add_mod_preview=1 Immediate (one click) registration: https://pause.perl.org/pause/authenquery?ACTION=add_mod&USERID=10500000_f18f8419fa516ee6&SUBMIT_pause99_add_mod_insertit=1