Re: Event sink on Sharepoint lists by Jared
Jared
Tue Feb 17 09:15:20 CST 2004
I figured out a way to do this just last week, however,
you may not want to try it since many people advise
against doing anything in the database. SO, if you do
decide to try it, then it will be at your own risk....
I tried to find other solutions, and I posted on message
boards (including this one) and noone could offer any
advice other than "It can't be done". Well, it can be
done, it just depends on IF you want to do it!
Here's how I did it:
In SQL Server enterprise manager, I created a DTS Package
with an ActiveX script that will call my dll. After you
have your DTS package set up, create a Trigger FOR INSERT,
UPDATE (or whatever events you want to call your code) on
the UserData table that will check to see if tp_ListId is
equal to the list that is being updated. If the
entry/update is to the list you want, then call your DTS
package (which in turn will call your dll).
Good luck! And if you (or anyone else) find other ways to
do this, please post as it would be benificial to a lot of
people!!!!!!!
Thanks,
Jared
>-----Original Message-----
>I am sorry but there is no known way of implementing
event sinks on
>SharePoint lists. You will need to modify your process to
use documents and
>document libraries, or change from an auto-event to a
initiated event model
>where a user clicks a button etc to initiate the process.
>
>"Mauri" <mauriciom@NOSPAMinfocorp.com.uy> wrote in message
>news:%23%23uGL2M9DHA.2524@TK2MSFTNGP11.phx.gbl...
>> Hi all,
>>
>> I want to try to associate a dll file to a Sharepoint
list.
>> I know that it's very easy to do it with a document
libary (because a MS
>> paper explain it), but I'm not figured out this task
for common lists.
>>
>> Anyone could help me or give me some pointers???
>>
>>
>> Tks.
>> Mauri.-
>>
>>
>
>
>.
>