That Gadfly adapter.... *grin*
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. -"-"-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Sean McGerty wrote:
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?
The version of gadfly that is used in our Zope ZGadflyDA is woefully out of date. It is only intended for demonstration purposes, so it has never been high enough on our priority list to update it, although we certainly want to. If someone would like to take this project over, I'd be happy to provide some pointers and advice. Maybe there should be a separate gadfly DA (or some smarts in the current one) to detect an existing gadfly installation and use it. Again, If someone wants to volunteer, I'd be happy to provide advice. Jim -- Jim Fulton mailto:jim@digicool.com Technical Director (540) 371-6909 Python Powered! Digital Creations http://www.digicool.com http://www.python.org Under US Code Title 47, Sec.227(b)(1)(C), Sec.227(a)(2)(B) This email address may not be added to any commercial mail list with out my permission. Violation of my privacy with advertising or SPAM will result in a suit for a MINIMUM of $500 damages/incident, $1500 for repeats.
participants (2)
-
Jim Fulton -
Sean McGerty