InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors

Sascha

Thanks for providing the script. I just tried it out, along with the queries
that you sent in the previous mail and the one with the problem seemed to be
OK (at least, it printed out the value from Unit). Maybe I need to try this
out against your real database. Would it be possible to zip the database up
and email it to me (not the mailing list - direct to
peter.hearty@lutris.com). But only if it's not too large (<512K zipped).

Regards

Pete

--

Peter Hearty                         peter.hearty@lutris.com
Lutris Technologies (UK)        http://www.lutris.com
----- Original Message -----
From: "Sascha Matzke" <sascha@bespin.de>
To: <instantDB@enhydra.org>
Sent: Tuesday, October 03, 2000 3:36 PM
Subject: Re: InstantDB: select madness


> Hello,
>
> On Tue, Oct 03, 2000 at 03:19:27PM +0100, Peter Hearty wrote:
> > What version of InstantDB are you using?
>
> 3.21 but the database was created with 3.20beta2
>
> > > SELECT * FROM Unit WHERE Unit.id IN (SELECT DISTINCT unitId FROM
> > > UnitOptions WHERE fieldname="targetArea" AND value="Berlin")
> > >
> > > So... The above doesn't work...
>
> > Do you get an exception, or does it return the wrong data? If the
> > wrong data then too much or too little or just the wrong value?
>
> I get no exception... no data either..
>
> > A script that creates the two tables, adds some data to illustrate
> > the problem would really help.
>
> I attached a sample script...
>
> Sascha
> --
> .-> Sascha Matzke - sascha@bespin.de ------------------------.
> |   Eure Moral, Eure MGs werden nicht ewig regier'n...       |
> |                                         Anarchist Academy  |
> `-- On this earth for  24 years,  355 days  <----------------'
>
>

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.