How do i insert a database value within a string in designer

[dasdee]

Hi,
How do i replace part of a text with a value from a data source. I am trying to replace a part of a text/string with a value from a datasource. I want to use IIF to check whether the user has a picture, if no, i show the default picture if yes i show the user picture by replacing or appending the user id(picture name) within the file path. Example below:

{IIF((DataSource1.PIC_STATUS ==1),"/abcde/files/pictures/"DataSource1.User_ID".jpeg", "/abcde/files/icons/default_picture.jpeg")}

[HighAley]

Hello.

Please, try to use next expression:

Code: Select all

{IIF((DataSource1.PIC_STATUS ==1),"/abcde/files/pictures/"+DataSource1.User_ID+".jpeg", "/abcde/files/icons/default_picture.jpeg")}

Thank you.

[dasdee]

Hi,
thanks a lot, it works perfectly as i wanted.
Regards.

[Andrew]

Great! Thank you for letting us know about this.