hi, not sure if I am being a dullard, but I have a page setup that worked just fine with a query built using “simple query” builder. But I needed to use some views so used custom builder.
my query works perfectly when run in the query builder, I get the correct data set.
i attach screen shot showing the query and its result set (1 row). A screenshot showing my server connect front end and using the server connect and the repeat region with the data points in the page.
i also just rebuilt the query using the query builder, again i get the same results set when viewing data set in query builder, but get a 500 error on the front end, i have looked at the debugger its basically a 500 error, i have a filter on it, but that has worked in past before i changed to a view, but i also removed the filter to see if it fixed the 500 error and it didnt
the drop down/filter worked all good before changing query to using views, its a select list that sends 0 or 1, but it all has worked fine until changing the query to use the views
