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))))".
---
