Dynamic update of iTicker Message

[Former Member]

Hi All,

I developed an iTicker object. When initial update this will get the message from a query. But later in my process i have update iTicker Message with a custom message. I am constructing a message in Java script. What method i have to use to update the iTicker message.

Thanks,

Ranga Manthena

[salvatore_castro · Accepted solution]

Ranga,

Why not just update the/a field in the/a database table and update the ticker?

-Sam

[Former Member]

If you dont want to put the value in a database you can make and xacute query to echo your passed value. Just update the iTickers params and refresh.

Regards,

Christian

[Former Member]

Hi Sam and Christian,

I am constructing a message which i can not update in database. Because i am getting a date field from query and i am concatenating a string to that.

I agree that Making xacute query is also another solution, but i did this differently.

I did a change in query template like below.

SELECT CONVERT(varchar, CONVERT(varchar, <Date>) + '[Param.1]') as 'Message'

FROM <Table>

Thanks for reply,

Ranga Manthena

[salvatore_castro]

Ranga,

Ok, you can use the [SD] and [ED] parameters and this will ensure that the date is formatted properly, [ED] is by default set to the current time.

-Sam

[salvatore_castro]

Ranga,

Ok, you can use the [SD] and [ED] parameters and this will ensure that the date is formatted properly, [ED] is by default set to the current time. This will also prevent you from having to use the CONVERT function.

-Sam

[Former Member]

Hi Sam,

I am constructing a string with in the select, the function 'CONCAT' is not working that is the reason i am using 'CONVERT'.

Thanks,

Rang Manthena