And FUBAR is a term coined by the military for...well, ask a vet. Rick
On 8/3/07, Shellman, David <[EMAIL PROTECTED]> wrote: > > ** 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]> 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 at www.arslist.org ARSlist:"Where the Answers Are"