Ah...well I'm familiar with FOO but I didn't know about FOOBAR...must be a programmer joke....sorry I didn't get it the first time...:)
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Friday, August 03, 2007 9:39 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Attachement Updation - File Contents Changed ** Hugo had it correct. He is referring to FOOBAR which is a reference often used with perl and probably most of the older programming languages. _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. Head Sent: Friday, August 03, 2007 11:19 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Attachement Updation - File Contents Changed ** Entirely off of this topic...but it would be PERFORM-ACTION-FUBAR :) _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Friday, August 03, 2007 2:31 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Attachement Updation - File Contents Changed ** Stephen, That's very clever, thanks for sharing :) Maybe BMC should put some kind of PERFORM-ACTION-FOOBAR to do this in a DB independent way. Hugo On 8/2/07, Heider, Stephen <[EMAIL PROTECTED]> wrote: ** Hugo, Your post got me thinking: How can you determine if the file contents have changed? I have wanted to create something like this for a while... so I just wrote this SQL Server 2000 function that returns the checksum of an attachment field (actually any field of Image data type. The current and new values could be compared to see if it changed. You can also use this to find duplicates in the attachment fields in your system. CREATE FUNCTION dbo.udf_GetImageChecksum ( @ImageField IMAGE ) RETURNS INT AS BEGIN DECLARE @Len BIGINT, @Pos BIGINT, @CheckSum VARCHAR(8000) SET @Len = DATALENGTH(@ImageField) SET @Pos = 1 SET @CheckSum = '' WHILE @Pos < @Len BEGIN SET @CheckSum = @CheckSum + CONVERT(VARCHAR, BINARY_CHECKSUM(SUBSTRING(@ImageField, @Pos, 8000))) IF LEN(@CheckSum) > 7900 SET @CheckSum = CONVERT(VARCHAR, CHECKSUM(@CheckSum)) SET @Pos = @Pos + 8000 END RETURN CHECKSUM(@CheckSum) END In a Set Fields SQL command: SELECT dbo.udf_GetImageChecksum(c536880912) FROM b611c536880912 WHERE entryId = 'ATTACH000016929' HTH someone. Stephen _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hugo Visser Sent: Thursday, August 02, 2007 5:15 AM To: arslist@ARSLIST.ORG Subject: Re: Attachement Updation ** You cannot compare the file contents, but using TR you should be able to detect that a file was attached again (if the DB value wasn't $NULL$). The "value" contains the file size in bytes, the compressed size in the DB and the full filename on the client. Also note that user cannot change the attachment from the attachment field without re-attaching it. Just changing the attachment (open->edit->save) doesn't update the DB, it only updates the local temporary copy of the file. Hugo On 8/2/07, Meenakshinathan <[EMAIL PROTECTED] > wrote: Hi Robert, Thanks for the information. Anyhow this solution is not working. Remedy stores the attachments in the following way <number of characters>,<no of bytes>(i am sure. but it might bytes),<filename with extenstion>. I am not user this TR and DB can apply for attachement fields. can any one give me a alternative solution on this? Looking for your inputs. Thanks, Meenakshinathan On Jul 28, 2:36 am, Robert Halstead < [EMAIL PROTECTED]> wrote: > I'm not entirely sure on this, but couldn't you do a filter on modify > with a run-if condition as: 'TR.Attachment' != ' DB.Attachment' ?? I'm > not entirely sure how remedy stores the attachments. It might > work.... > > Anyone else ?? > > On 7/27/07, Meenakshinathan < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: > > > Hi Listers, > > > In my application, at first stage users can attach 3-4 files. when the > > request assinged to next stage, that next stage user can edit or > > modify the attachment and can upload it again. In this stage my client > > has an requirement like, first stage user to be notified whenever any > > attachement is updated. If anybody came throrough this , can you > > please let me know how do i implement this? > > > Thanks, > > Meenakshinathan > > > ___________________________________________________________________________- ____ > > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are" > > -- > "A fool acts, regardless; knowing well that he is wrong. The ignoramus > acts on only what he knows, but all that he knows. > The ignoramus may be saved, but the fool knows that he is doomed." > > Robert Halstead > > ___________________________________________________________________________- ____ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are" ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"