[thelist] denormalizing a result set in dreamweaver
r937
rudy at r937.com
Thu Feb 7 18:35:17 CST 2008
any dreamweaver gurus out there?
i'm doing some sql consulting for a client whose site is built with
dreamweaver
the sql query is designed to return multiple results, for example like this:
foo aa 9
foo bb 3
foo cc 7
bar xx 4
qux mm 5
qux nn 7
qux oo 8
however, he says he cannot handle this, even though it's a prefectly
decent-looking result set, no? very typical for a one-to-many relationship
he says he has to have it like this --
foo aa 9 bb 3 cc 7
bar xx 4
qux mm 5 nn 7 oo 8
he wants one line per thingy, with all the data in ~separately named
columns~
(you can imagine how awful this would be to produce with sql)
i can't believe there isn't some way for dreamweaver to handle the properly
normalized result set (multiple result rows per thingy)
is it called a repeat region? (a term i've heard used by dreamweaver users)
note: i don't do dreamweaver
rudy
http://r937.com/
More information about the thelist
mailing list