I have the following code in the SQL Driven Options for a Listbox. I have question events which force the page to re-load and this works great. The short name for the street Textbox is Street. I also have a DNN Text Suggest field that works great auto completing entered text for a street.
I try to use the same SQL statement below to populate the options for the Listbox by changing the where clause to be where FULL_STREET = '$(StreetL)' which is the short name for the DNN Text Suggest field. This does not work. I have debug mode on and the where clause is always set to a blank criteria.... and never populates based on the value from the DNN Text Suggest filed, even after the question events are fired off.
select 'ADDRESS: ' + PHYS_ADDRESS + ' OWNER: ' + OWNER as QuestionOption, 'ADDRESS: ' + PHYS_ADDRESS + ' OWNER: ' + OWNER as QuestionOptionValue from [TestWebDB].[dbo].[RENTAL_REGISTRATION] where FULL_STREET = '$(Street)' and HAS_PERMIT = 'Yes' order by 1 Can you please help? Thanks! |