On Fri, May 25, 2012 at 12:56 PM, Puneet Kishor <punk.kish@gmail.com> wrote:
On May 25, 2012, at 12:52 PM, <gizmomathboy@gmail.com> wrote:
On May 25, 2012 11:10 AM, Puneet Kishor <punk.kish@gmail.com> wrote: On May 25, 2012, at 10:02 AM, <gizmomathboy@gmail.com> wrote:
Is there a way to access multiple tables using SimpleCRUD without using foreign keys? I have a relatively small database with a 3 tables or so but I don't have foreign keys between the tables. Using Dancer::Plugin::SimpleCRUD there doesn't seem to be a way (from reading the documentation or search around for examples) to access more than 1 table in the simple_crud() call. It does look like you can use FKs to pull them into that 1 table.
What about using an SQL view to create a single virtual table to use with SimpleCRUD? http://www.w3schools.com/sql/sql_view.asp Chris