Re: z mysql problem noted

Chuck Theobald <[email protected]> writes:
> ...
>     I ran into an odd issue with a z sql method, plone is claiming
>     duplicate column names, see image below.

I cannot see you image. Likely, you get an exception and
in all those cases, you should post the detailed error description
you find in your "error_log" object for that exception.


Not seeing your image, I can only guess:
the interface "Z SQL Method"s present towards the application
is name based -- i.e. the result fields have names.
The basic SQL interface is not name based but position based.
Auxiliary names are derived from column names or SQL expressions
*BUT* SQL does do not garantee that those names are unique.
It is quite possible that SQL assigned the same name to different
field positions in the result and than the "Z SQL Method" does
not know which value it should use for its single name -- and complains.
In those cases use the SQL "as" to garantee the associated field names
in the result become distinct.



------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/