Problems with a link field

[Former Member]

Hi,

I've added a formatted search to a link field. This formatted search is executed when you add a picture to another field. We want this field to show the picture destination folder with the name of the picture.

The problem is that the type of the field is ntext and the data we want to introduce is varchar.

How can we show that data in the field?

Thanks,

vane

[Former Member · Accepted solution]

Hi Vanessa,

This SQL works for me:

DECLARE @path varchar(50)

SELECT @path = cast(T0.BitmapPath as varchar) FROM OADP T0

select cast(@path + $[OITM.U_FieldName] as ntext(16))

Regards,

Ibai Peñ

[Former Member · Accepted solution]

Hi,

I've tried with the SQL that you have suggested but it continues the same. But I've tried it in another field and it works correctly,why is this?

Thanks

[Former Member · Accepted solution]

Link type userfields use to have a bug.

To assign the formatted search you should have a User Field focused. If not, the formatted search is not well created, and gives strange errors.

Hope helps,

Ibai Peñ

[Former Member · Accepted solution]

Thanks, now it works correctly