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"

Reply via email to