Re: From OpenBase To MSSQLServer2000 (EOModeller)
Re: From OpenBase To MSSQLServer2000 (EOModeller)
- Subject: Re: From OpenBase To MSSQLServer2000 (EOModeller)
- From: Art Isbell <email@hidden>
- 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.
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.