Tailored Text Version:2.1.3756.23820 DotNetNuke Version:5.6.1
I'm using SQL Bind to get data for a Tailored HTML form and I want to SQL to be filtered based on a Request Parameter called (DSParam1).
The SQL I'm using is: SELECT [Title] ,[Description] ,[ItemCode] ,[Qty] ,[Price] ,[VAT] ,[TotalVAT] ,[TotalPrice] FROM [dbo].[ai2i_4xShopItems] WHERE [ItemCode] = '$(DSParam1)'
And the debug Shows: SELECT [Title] ,[Description] ,[ItemCode] ,[Qty] ,[Price] ,[VAT] ,[TotalVAT] ,[TotalPrice] FROM [dbo].[ai2i_4xShopItems] WHERE [ItemCode] = '$(DSPARAM1)'
As you can see it hasn't picked up the DSParam value. I seem to remember that Dynamic views used to suffer with this issue but was fixed last year.
Any chance we can get this sorted?
Adam |