[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