From: Randall P. <rg...@sy...> - 2004-07-21 00:16:31
|
on 7/20/04 2:56 AM, Anjo Krank at kr...@lo... wrote: > > Am 20.07.2004 um 04:41 schrieb Randall Perry: >> Do you mean the Width column in EOModeler? Tried that, but still got >> the >> error. > > Maybe you didn't rebuild? The term is constructed from the width given > in the model - if none is present, the "(size)" part is omitted. > Anyway, you c(sh)ould either use CHAR, which is the official type for > padded strings, remove the width or change it to VARCHAR if your logic > doesn't prevent it. This would also spare you the RTRIM in the selects. > I thought I rebuilt -- maybe I didn't. I replaced the varchar and bpchar types with char, cleaned all targets, and rebuilt. Now the SQL looks like this, and it works: "SELECT t0.comments, t0.contact, t0.cust, t0.cust_no, t0.division, t0.email, t0.enter_date, t0.filecode, t0.hold, t0.mod_date, RTRIM(t0.password), t0.profit, t0.profit_div, t0.user_name, t0.vendor FROM public.cust_view t0 WHERE (t0.user_name = ?::varchar AND t0.password = ?::bpchar)" withBindings: 1:"user"(userName), 2:"test"(password) So I'll have to do this with all my models to use the Wonder plugin? Is the problem with EOModeler or the plugin? Thanks -- Randall Perry sysTame Xserve Web Hosting/Co-location Website Design/Development WebObjects Hosting Mac Consulting/Sales http://www.systame.com/ |