These special characters (they appear as squaure boxes) are control characters that inserts a return character in the output when the log is read by the application from the database.. These are necessary to be inserted for the contents of the logs to be understood by the ARS.
There used to be a freeware for editing log entries that worked pretty well for a few versions of the ARS, I haven't used it on version 7. It used to be available on Software Tool houses website.. Not sure if that would work for the version of ARS you have as you haven't mentioned what version you are on, but worth a try downloading it and giving it a shot. I'd try it on a test form before trying it on real data and make sure it works. Joe ----- Original Message ---- From: Sean Garrison <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, December 18, 2006 2:49:41 PM Subject: Updating worklog entries via SQL 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 __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
