Hello,
I have a problem with Dynamic registration 3.20.20: I have two linked dropdowns, the former populating the latter by a question event reading its value (by its shortname token).
The problem is that when the first dropdown value contains an apice, my sql statement gives an error.
SQL:
select ' - Seleziona la Città - ' as QuestionOption, '0' as QuestionOptionValue
Union All
select Text as QuestionOption, value as QuestionOptionValue from lists where ListName = 'City'
AND [ParentID] = (select EntryID from Lists where ListName = 'Province' and value=replace( '$(MyProvince)', '''', ''))
order by QuestionOption
$MyProvince is the shortname to get the first combo value; if this is for example L'Aquila, the sql will become:
... and value=replace( 'L'Aquila', '''', ''))
and of course give an error.
Is there a way to solve? I cannot remove apices from values.
Best Regards,
al.