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: Sat, 31 May 2003 14:38:41 +0100
From: Art Isbell <email@hidden>
To: email@hidden
Subject: Re: From OpenBase To MSSQLServer2000 (EOModeller)
Date: Fri, 30 May 2003 08:43:21 -1000
On Friday, May 30, 2003, at 07:02 AM, Jonathan Fleming wrote:
JDBCAdaptorException: EvaluateExpression failed:
<MicrosoftPlugIn$MicrosoftExpression: "SELECT (SELECT COUNT(*) FROM
TB_JOB_PICTURE WHERE TB_JOB_PICTURE.TB_JOB_ID = TB_JOB.TB_JOB_ID),
t0.DATA_DIR_JOB, t0.JOB_REF_NO, t0.LOCATION, t0.TB_CLIENT_ID,
t0.TB_JOB_ID, t0.TEXT_ABOUT_JOB FROM TB_JOB t0">:
Next exception:SQL State:HY000 -- error code: 107 -- msg:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The column prefix
'TB_JOB' does not match with a table name or alias name used in the query.
First I'd ask myself whether I wanted the fetch of every TB_JOB object to
include the count because I'd wonder how expensive calculating this count
might be. If I decided that I really needed this count for every TB_JOB
object, I'd examine the error message. Based on that message, I'd try
making the derived SQL into a proper join statement by adding ", TB_JOB" to
the "FROM" clause.
this is a derived column to avoid fetching all the TB_JOB objects. Using a
derived column is supposed to do that directly given the correct SQL. what I
want to know is the proper SQL the would work with MSSQLServer2000's
adaptor, ie, the SQL I need to put in the Attribute Inspector's Derived
option and the Advanced Attribute Inspector's Custom Formatting Read option,
the other options here are read only and allow null values which are both
checked.
If that's not right then Ravi Mendis book WebObjects Developer's Guide page
182 - 184 which suggests doing this to avoid excatly what you are saying is
totally wrong.
Any suggestions?
Jonathan :^/
Aloha,
Art
_______________________________________________
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.
_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess
_______________________________________________
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.