https://interactivetools.com/forum/forum-posts.php?Views-72651 Mon, 07 Sep 2026 14:48:05 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2211726#post2211726
Being database orientated myself I like that idea a lot. The trouble is setting up views in a user friendly fashion in the CMS Builder. In any case I'll add views to the feature request list.

Thanks,
Robin
]]> Thu, 09 Jun 2011 10:32:58 -0700 forum-posts.php?postNum=2211726#post2211726 https://interactivetools.com/forum/forum-posts.php?postNum=2211702#post2211702
I want to be able to have a view that selects data from 2 tables with same columns.

I actually managed to do this by first creating a section in CMS with the columns that I wanted, then with phpmyadmin, I dropped the table and created a view to replace the table.

Works great except that CMS complained that my view was not a table, line 213 of lib/database_functions.php, once I removed the die statement, everything worked fine.

mysql_query("ALTER TABLE `".mysql_escape($mysqlTableName)."` $addFieldSQL") or die("Error adding fields to '$mysqlTableName', the error was:\n\n". htmlspecialchars(mysql_error()));

Would be a nice feature for a future release.
]]> Wed, 08 Jun 2011 11:59:59 -0700 forum-posts.php?postNum=2211702#post2211702