Re: Navigation question

JOG wrote:

> On Feb 18, 4:26 am, "dawn" <dawnwolth..._at_gmail.com> wrote:
> 

[snip]

>>>>Is the following pseudocode that includes navigation a poor way to
>>>>code this and, if so, why?
>>
>>>>select companyid c, companyName, emailAddress
>>>> from Company c, EmailAddr e
>>>> where c.companyid=e.companyid and tin='xyz';
>>>>thisCompanyid=companyid;
>>>>select classifier from CompanyClassifier where
>>>>companyid=thisCompanyid;
>>>>select orderid, orderPrice from Orders where companyid=thisCompanyid;
>>
>>>"poor" could be overly harsh - but, compared to a single query,
>>>it /does/ introduce some arbitrary ordering, inspired by how the coder
>>>thinks the data is to be located - which may or may not be the case or
>>>may change in the future.
>>
>>What kind of changes would be problematic?
>>
>>
>>>The single query would have no such dependency.
>>
>>How would you code the application, perhaps including a total line for
>>the total price after the list of orders presented to the user, if you
>>put this in a single SQL statement? It is certainly possible, but
>>ugh, that cross-product is not pretty.

Does everyone see how the self-aggrandizing ignorant loads questions? Cross-product? What fucking cross product? The moron hallucinates.

[further horseshit and reply snipped] Received on Sun Feb 18 2007 - 15:31:38 CET