DetailView with error
Query for my view is:
select * from myTable where myID=$(DSParam1)
DSParam1 is for selected company and it works and show me the right item for the company.
But clicking at the "DetailView" i get this error. The Detail ID here is "ProgID" and i think the full query should be
select * from myTable where myID=$(DSParam1) and ProgID='151'
but you can see that the DSParam1 parameter is not pulished thru querystring.
I´ve tested without DSParam1 and it works and shows me the right detail.
**** DEBUG MODE ENABLED *******
Dynamic Views Version: 2.0.1.20807
ModuleID: 623
TabID: 124
DotNetNuke Version: 5.6.1
Detail View:True
Detail View2:623Preparing Detail Query: AND ProgID = '151'
Error:Incorrect
syntax near '('. at
DataSprings.DNN.Modules.DynamicViews.DynamicViews.GenerateReport(String
Status, String strNewRecordsPerPage, String strDetailView)
at
DataSprings.DNN.Modules.DynamicViews.DynamicViews.ProcessDetailedView()
at DataSprings.DNN.Modules.DynamicViews.DynamicViews.Page_Load(Object
sender, EventArgs e)
Loading Data
Inside Get Data:Load
New Page Size:
Loading
Data With Errors:Incorrect syntax near '('. at
DataSprings.DNN.Modules.DynamicViews.DynamicViews.GenerateReport(String
Status, String strNewRecordsPerPage, String strDetailView)
at DataSprings.DNN.Modules.DynamicViews.DynamicViews.GetData(String
Status, String strNewPageSize)
at DataSprings.DNN.Modules.DynamicViews.DynamicViews.Page_Load(Object
sender, EventArgs e)
Inside Get Data:Load
New Page Size:
Search Error:
Search Error Message:Incorrect syntax near '('.
Search Error Stack Trace:
at
DataSprings.DNN.Modules.DynamicViews.DynamicViews.GenerateReport(String
Status, String strNewRecordsPerPage, String strDetailView)
at DataSprings.DNN.Modules.DynamicViews.DynamicViews.GetData(String
Status, String strNewPageSize)
at DataSprings.DNN.Modules.DynamicViews.DynamicViews.Page_Load(Object
sender, EventArgs e)