[thelist] denormalizing a result set in dreamweaver

[Julian Rickards]

First of all, why don't you just create the proper SQL and add it to the
code or are you concerned that DW would try to play with it. I have done
some basic SQL (handcoded) in DW and never had a problem.

Secondly, it is my understanding that David Powers is a PHP/SQL/DW guru. You
might want to contact him but my copy of his book doesn't list his email
address. I can keep digging if you want.

Jules

On 07/02/2008, r937 <rudy at r937.com> wrote:
>
> 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/
>
>
> --
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>



-- 
Blog: http://pen-and-ink.ca
E-mail: julian dot rickards at gmail dot com