• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
select distinct error - model based fetch
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

select distinct error - model based fetch

  • Subject: select distinct error - model based fetch
  • From: "Jonathan Fleming" <email@hidden>
  • Date: Fri, 08 Aug 2003 12:22:34 +0100
It's probably a trivial error but I can not see why I am getting it.
In a model based fetch spec I am selecting the option distinct but I keep getting the errro below.
the model does these things
qualify = null
sortorder = country
pre fetch = null
raw fetch = country
options = perform deep inheritance (and if turned on DISTINCT creates the error)

Thanks
Jonathan :^)

Error: com.webobjects.jdbcadaptor.JDBCAdaptorException: EvaluateExpression failed: : Next exception:SQL State:HY000 -- error code: 145 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Next exception:SQL State:HY000 -- error code: 16945 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared. Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to TMI Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database context to 'TMI'. Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english.
Reason: EvaluateExpression failed: <com.webobjects.jdbcadaptor.MicrosoftPlugIn$MicrosoftExpression: "SELECT DISTINCT RTRIM(T1.COUNTRY), t0.TB_ADDRESS_ID FROM TB_ADDRESS_WORK t0, TB_ADDRESS T1 WHERE T1.ADDRESS_TYPE = ? AND t0.TB_ADDRESS_ID = T1.TB_ADDRESS_ID ORDER BY UPPER(T1.COUNTRY) ASC" withBindings: 1:2(addressType)>: Next exception:SQL State:HY000 -- error code: 145 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. Next exception:SQL State:HY000 -- error code: 16945 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The cursor was not declared. Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC]Database changed to TMI Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed database context to 'TMI'. Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC]Language changed to us_english Next exception:SQL Warning: -- error code: 0 -- msg: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Changed language setting to us_english.

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends http://www.msn.co.uk/messenger
_______________________________________________
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.
  • Prev by Date: Re: WOMultipartIterator
  • Next by Date: [WO5.2] JDBC Adaptor PlugIns
  • Previous by thread: Re: setting a browser window name in WebObjects
  • Next by thread: [WO5.2] JDBC Adaptor PlugIns
  • Index(es):
    • Date
    • Thread