Hi,

I'm working on some code to execute an sql statement when the "hide channel"
property is changed for a channel. what is the best way to implement such
code? is there a particular event i should attach the code to?

any help would be appreciated,

thanks,

Michael

[ Post a follow-up to this message ]

Hi Michael,

I hope this is an SQL statement that does access a different database as the
MCMS database.
Access to the MCMS database using different methods but documented API calls
will violate the MCMS support boundaries for MCMS.

Regarding your specific question: there is no workflow event for changes to
a channel object - so there is no event firing when a custom channel
property value is changed.
You could implement this using a custom channel property dialog.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"drazic19" <drazic19@discussions.microsoft.com> wrote in message
news:B45FE090-5CB8-403E-AF45-3D13DC77B498@microsoft.com...
> Hi,
>
> I'm working on some code to execute an sql statement when the "hide
> channel"
> property is changed for a channel. what is the best way to implement such
> code? is there a particular event i should attach the code to?
>
> any help would be appreciated,
>
> thanks,
>
> Michael

[ Post a follow-up to this message ]

Hi Stefan,

Don't worry the sql is a separate database to cms one. I have another db
that mirrors my cms channel structure and is used elsewhere. It isn't a
custom property that the event needs to look for its a standard channel
property. Does that affect you answer.

Thanks,

Michael

"Stefan [MSFT]" wrote:

> Hi Michael,
>
> I hope this is an SQL statement that does access a different database as t
he
> MCMS database.
> Access to the MCMS database using different methods but documented API cal
ls
> will violate the MCMS support boundaries for MCMS.
>
> Regarding your specific question: there is no workflow event for changes t
o
> a channel object - so there is no event firing when a custom channel
> property value is changed.
> You could implement this using a custom channel property dialog.
>
> Cheers,
> Stefan
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> New to MCMS?
> Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44[/url...nyurl.com/8ugwj
> ----------------------
>
>
> "drazic19" <drazic19@discussions.microsoft.com> wrote in message
> news:B45FE090-5CB8-403E-AF45-3D13DC77B498@microsoft.com... 
>
>
>

[ Post a follow-up to this message ]

Hi Michael,

sorry it does not affect my answer.

Cheers,
Stefan

--
This posting is provided "AS IS" with no warranties, and confers no rights

New to MCMS?
Check out this book: Building Websites Using MCMS: http://tinyurl.com/6zj44
Check out the new book as well: Advanced MCMS development:
http://tinyurl.com/8ugwj
----------------------


"drazic19" <drazic19@discussions.microsoft.com> wrote in message
news:AC1DFA98-CF43-4637-8FB9-E894943DBC6C@microsoft.com...[vbcol=seagreen]
> Hi Stefan,
>
> Don't worry the sql is a separate database to cms one. I have another db
> that mirrors my cms channel structure and is used elsewhere. It isn't a
> custom property that the event needs to look for its a standard channel
> property. Does that affect you answer.
>
> Thanks,
>
> Michael
>
> "Stefan [MSFT]" wrote:
> 

[ Post a follow-up to this message ]