I am trying to update a work log field via SQL. In looking at the database I can see that the entries look like this:
<date>.<username>.<work log entry> ... but when I duplicate this via sql it doesn't seem to recognize the entry. It appears that it puts some special character at the end to terminate it. Anyone know what this is or how I can update diary entries via SQL? Example SQL I am trying: UPDATE WR_REQUESTOR SET DIARY_FIELD = DIARY_FIELD || (SELECT CREATE_DATE FROM WR_AM WHERE ENTRY_ID = $ENTRY_ID$) || '.$Submitter$.Note Type >> $Note Type$ Note Description >> $Note Description$' WHERE WORK_REQUEST = 'WR00000001' Any ideas? Thanks, Sean _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
