Bugger. I've been using the following construct with ODBC SQL dbs for years... There's also matching examples in the Gadfly documentation, but Gadfly through Zope doesn't seem to like it:

:select *

:from A, B

:where A.recNum = B.recNum

And both recNum fields are of the same type. Simple you say? I thought so. Except it's coming back as blank and if I change the = to a <> all rows and columns are returned - including those which an eyeball search says have matching recNum values. Which makes one wonder if I'm missing something significant.

It's almost 3am and I've been on this particular problem for a few hours now... Has anyone had a similar experience? Is there a difference in bahavior in Gadfly under Zope that could effect it?

Sean.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= _ /\=
 ___   Sean McGerty aka DrBob    C++::Java::Delphi::Web Developer /    \
<*,-> mailto:DrBob@speednet.com.au m+61-412336990 Sydney Australia\_- _*
[`-'] new address "Democracy: Four wolves and a lamb voting on lunch" v.
-"-"-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-