https://interactivetools.com/forum/forum-search.php?k=user%3Amsoda Thu, 11 Jun 2026 20:34:43 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2194842#post2194842
I think that, for us, we will use CMS Builder for rapid client interface development and use some of the manual methods you suggest for displaying the public pages. We have nearly finished our first site so we have several query models to work with already.

We'll definitely be using CMS Builder again.
]]> Fri, 19 Dec 2008 04:27:32 -0800 forum-posts.php?postNum=2194842#post2194842 https://interactivetools.com/forum/forum-posts.php?postNum=2194750#post2194750
- Is it possible to SELECT limited columns from the DB instead of all ( * )?

- Typically we would want to use foreign keys and JOIN tables when setting a schema. Is it possible to use foreign keys without relying on the "editors" to manage it as new content is added?

- Can you run WHERE clauses on multiple tables (in effect creating a JOIN). Specifically we don't want to pull all data from the cms_uploads table when we just want images with 'order = "1"'.

- Is there any reason why bespoke code shouldn't be written for client-facing pages if the generated code doesn't do the job?

I realize these are general questions but hopefully they should give us a steer.

Thanks in advance.
Joe
]]> Tue, 16 Dec 2008 15:43:40 -0800 forum-posts.php?postNum=2194750#post2194750