Re: From OpenBase To MSSQLServer2000 (EOModeller)
Re: From OpenBase To MSSQLServer2000 (EOModeller)
- Subject: Re: From OpenBase To MSSQLServer2000 (EOModeller)
- From: "Jonathan Fleming" <email@hidden>
- Date: Wed, 04 Jun 2003 06:49:44 +0100
From: Art Isbell <email@hidden>
To: Jonathan Fleming <email@hidden>
Subject: Re: From OpenBase To MSSQLServer2000 (EOModeller)
Date: Mon, 2 Jun 2003 08:50:35 -1000
On Sunday, June 1, 2003, at 09:14 AM, Jonathan Fleming wrote:
From: Art Isbell <email@hidden>
To: Jonathan Fleming <email@hidden>
Subject: Re: From OpenBase To MSSQLServer2000 (EOModeller)
Date: Sat, 31 May 2003 16:13:36 -1000
On Saturday, May 31, 2003, at 03:38 AM, Jonathan Fleming wrote:
From: Art Isbell <email@hidden>
I'd try making the derived SQL into a proper join statement by adding
", TB_JOB" to the "FROM" clause.
what I want to know is the proper SQL the would work with
MSSQLServer2000's adaptor,
Did you try what I suggested above?
Yes tried that an got the same exception message with
TB_JOB.TB_JOB_PICTURE added to the from clause
Did you misread what I suggested or is the above a misprint? The FROM
clause can only contain table names, not column names such as
TB_JOB.TB_JOB_PICTURE.
OK, Art
I went off and found out a little about SQL as I really knew nothing about
the code at all. It shocked me as to how simple a language it is to learn -
that was good no time lost there then..
Anyhow, i have now followed your suggestion and, of course, it worked as you
though it would, thus your frustration with me... sorry about that. But now
the result is giving me the same answer for every row and the count is more
than what each row should contain as a count and also the count is a larger
number than the true amount of records in the DB.
This is what I have now used:
(SELECT COUNT(*) FROM TB_JOB, TB_JOB_PICTURE WHERE TB_JOB_PICTURE.TB_JOB_ID
= TB_JOB.TB_JOB_ID)
I have tried all sorts of variations and I can not seem to get the count of
images for a job or more precisely count rows identified by the PK / FK
attributes of these tables.
So what am I still doing wrong?
Jonathan :^S
Aloha,
Art
_________________________________________________________________
On the move? Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.