Postgres 8.2.4 Case Torres [EMAIL PROTECTED]
> -----Original Message----- > From: BJ Freeman [mailto:[EMAIL PROTECTED] > Sent: Friday, January 11, 2008 9:48 AM > To: [email protected] > Subject: Re: Creating party_note, note_id error > > this looks like a field type definition is messed up. > which DB are you using. > > Case Torres sent the following on 1/11/2008 9:08 AM: > > Hi, > > > > Release 4, version: 602199 > > > > I was trying to create a note for a party in party manager and > > received the error below. > > The two fields to be filled in are "Note Id" and "Note". > > The Note Id form field is 25 chars long, with no max set but the > > database field is set at 20 chars so the user gets an ugly > sql error message. > > It seems the easiest fix is to make the form field max 20 chars but > > I'm not sure how to do this given the following form code. > > > > Any suggestions??? Thanks, Case > > > > <form name="AddPartyNote" type="single" target="createPartyNote" > > focus-field-name="noteId"> > > <auto-fields-service service-name="createPartyNote"/> > > <field name="partyId"><hidden/></field> > > <field name="note"><textarea cols="70" rows="10"/></field> > > <field name="submitButton" title="${uiLabelMap.CommonSave}" > > widget-style="smallSubmit"><submit button-type="text-link"/></field> > > <field name="cancelLink" title="" > > widget-style="smallSubmit"><hyperlink > > target="${donePage}?partyId=${partyId}" also-hidden="false" > > description="${uiLabelMap.CommonCancelDone}"/></field> > > </form> > > > > > > > > ------ > > SQL ERROR: > > > > Problem associating note with party "Exception while inserting the > > following > > entity: [GenericEntity:PartyNote][createdStamp,2008-01-10 > > 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10 > > 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10 > > 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10 > > 13:07:25.773(java.sql.Timestamp)][noteId,New product > > > discussion(java.lang.String)][partyId,12692(java.lang.String)] (while > > inserting: [GenericEntity:PartyNote][createdStamp,2008-01-10 > > 13:07:25.774(java.sql.Timestamp)][createdTxStamp,2008-01-10 > > 13:07:25.773(java.sql.Timestamp)][lastUpdatedStamp,2008-01-10 > > 13:07:25.774(java.sql.Timestamp)][lastUpdatedTxStamp,2008-01-10 > > 13:07:25.773(java.sql.Timestamp)][noteId,New product > > discussion(java.lang.String)][partyId,12692(java.lang.String)] (SQL > > Exception while executing the following:INSERT INTO > public.PARTY_NOTE > > (PARTY_ID, NOTE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, > > CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?) (ERROR: > > value too long for type character varying(20))))". > > > > --- > > > > >
