Hi there, I am fetching raw rows. Most time, it works well, but I have bumped into a pretty weird behaviour with a derived attribute. The attribute is defined like this:
=== { className = NSString; definition = "CAST(C_AUCTION_SEQ as VARCHAR(18))"; externalType = "CHAR VARYING"; name = ceboisAuctionId; valueType = S; width = 256; } === (the actual definition is much more complex, but the one above sports the problem as well; also, I have tried both with valueType=S as shown above and without a valueType for String/stream default.) If I fetch raw rows _directly from the table_ which contains the attribute, it works perfectly, I get strings for 'ceboisAuctionId' in the dictionaries -- in my raw row dictionaries there are things like e.g., "ceboisAuctionId:28", all right. Nevertheless, if I fetch _another_ table which contains a relationship :1 'auction' into this table, and if I add 'auction.ceboisAuctionId' to fetchSpec.rawRowKeyPaths, I do get the proper value -- but _encoded in NSData_! In this case, in my raw row dictionaries there are things like e.g., "auction.ceboisAuctionId:<class com.webobjects.foundation.NSData (offset=0, length=3, data=[50]'2', [56]'8', [0]'')>" :-O This does not happen with normal (non-derived) columns of the same type: e.g., for a column === { allowsNull = Y; className = NSString; columnName = "C_TITLE"; externalType = "CHAR VARYING"; name = title; width = 256; } === those I get proper strings in both cases, i.e., regardless they are fetched directly from the table, or indirectly through a relationship from another table, in my raw row dictionaries there are always things like "title:Something" or "auction.title:Something". Does it make any sense? Could I fix something in my model to get the values properly converted even if fetched through a relationship and a derived attribute? Thanks and all the best, OC _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com