Not sure why, one more time, this one did not get thru... (but I know my SMTP
provider is a crap)
Jacques
----- Original Message -----
From: "Jacques Le Roux" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, January 11, 2008 10:21 PM
Subject: Re: Creating party_note, note_id error
Yes and as it was not a bug fix it was not backported. You may found what you
need here
http://svn.apache.org/viewvc?view=rev&revision=589084
or here http://tinyurl.com/3a9l7h
Jacques
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Case
I looked at this a while ago and as I recall, the noteid is created for you
if you pass null. I seem to remember submitting a jira which removed the
notid field from the UI so this happens.
Skip
-----Original Message-----
From: Case Torres [mailto:[EMAIL PROTECTED]
Sent: Friday, January 11, 2008 9:08 AM
To: [email protected]
Subject: Creating party_note, note_id error
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))))".
---
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.17.13/1210 - Release Date: 1/5/2008
11:46 AM
