[Zope] That Gadfly adapter.... *grin*
Sean McGerty
DrBob@speednet.com.au
Wed, 09 Jun 1999 02:57:34 +1000
--=====================_24514240==_.ALT
Content-Type: text/plain; charset="us-ascii"
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.
-"-"-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--=====================_24514240==_.ALT
Content-Type: text/html; charset="us-ascii"
<html><div>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:</div>
<div>:select *</div>
<div>:from A, B</div>
<div>:where A.recNum = B.recNum</div>
<br>
<div>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. </div>
<br>
<div>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?</div>
<br>
<div>Sean.</div>
<br>
<font face="Fixedsys" size=3 color="#C0C0C0"><div align="center">
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=</font><font face="Fixedsys" size=3 color="#800000">
</font><font face="Fixedsys" size=3 color="#008000">_
/\</font><font face="Fixedsys" size=3 color="#C0C0C0">= <br>
</font><font face="Fixedsys" size=3 color="#0000FF"> </font><font face="Fixedsys" size=3 color="#800000">___</font><font face="Fixedsys" size=3 color="#0000FF">
Sean McGerty</font><font face="Fixedsys" size=3 color="#C0C0C0"> aka
</font><font face="Fixedsys" size=3 color="#0000FF">DrBob</font><font face="Fixedsys" size=3 color="#C0C0C0">
</font><font face="Fixedsys" size=3 color="#800000">C++::Java::Delphi::Web
Developer
</font><font face="Fixedsys" size=3 color="#008000">/
\</font><font face="Fixedsys" size=3 color="#C0C0C0"> <br>
</font><font face="Fixedsys" size=3 color="#800000"><*,-></font><font face="Fixedsys" size=3 color="#C0C0C0">
</font><a href="mailto:DrBob@speednet.com.au" eudora="autourl"><font face="Fixedsys" size=3 color="#008000">mailto:DrBob@speednet.com.au</a></font><font face="Fixedsys" size=3 color="#C0C0C0">
m+61-412336990 Sydney
Australia</font><font face="Fixedsys" size=3 color="#008000">\_-
_</font><font face="Fixedsys" size=3 color="#FF0000">*</font><font face="Fixedsys" size=3 color="#C0C0C0">
<br>
</font><font face="Fixedsys" size=3 color="#800000">[`-']</font><font face="Fixedsys" size=3 color="#C0C0C0">
</font><font face="Fixedsys" size=3 color="#FF00FF">new
address</font><font face="Fixedsys" size=3 color="#C0C0C0">
"Democracy: Four wolves and a lamb voting on
lunch"</font><font face="Fixedsys" size=3 color="#808080">
</font><font face="Fixedsys" size=3 color="#008000">v</font><font face="Fixedsys" size=3 color="#C0C0C0">.
<br>
-</font><font face="Fixedsys" size=3 color="#800000">"</font><font face="Fixedsys" size=3 color="#C0C0C0">-</font><font face="Fixedsys" size=3 color="#800000">"</font><font face="Fixedsys" size=3 color="#C0C0C0">-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-<br>
</font></html>
--=====================_24514240==_.ALT--