[ic] Way to [query] tall instead of wide?

Paul Jordan paul at gishnetwork.com
Sun Sep 4 02:16:34 UTC 2011

Usually you can query select *, grab a bunch of fields, iterate over the 
results found. What if though, I wanted to a bunch of key-value pairs from a 
mess of rows?

As an example to grasp, let's say that all text on every page was editable. 
You're not going to make tables with a ton of awkward columns, you going to 
produce something like this (key omitted for brevity):

page_id     area_name      area_value
1                title                  My Designer Yoyo's
1                heading           Welcome to my......
1                email_link        Hit me up!
1                step_1_desc    To do step 1, just....
1                step 1_title       Do this first!
(Assume a multi-part uniqueness on page_id+area_name)

Is there some way to query this and still end up with: [sql-param title] 
[sql-param heading] and so on? The body would not loop of course.

I would have thought something like this would be common - does it exist? If 
not, what would you suggest... a new purpose-built query tag, and 
enhancement to [query], or something else?

I would think with something like this, with the correct query, one could 
not only easily make each page's text customizable (with generic fall back), 
but also build in a permission system with the addition to a user column. 
With just one efficient query, you end up with no need for either/or/if/else 
to achieve what I mentioned.

I am guessing something sort of similar is done with the [L] language stuff?

Thank you all for your thoughts.


More information about the interchange-users mailing list