Custom Query outputting my SQL Statement

[turn3636]

Using the custom SQL builder with MS SQL server and classic ASP, everything seems to working on that part. I can view my results here:
(it’s a large query…)

I can view my structure here in Server Connect generating my table on the page:

So far, so good… Until I load the page, and in the response payload I see my Query, repeated over and over, and no data on my page.

What’s up? I admit I haven’t used the custom query builder very much. I just started using it because of the current issue of not being able to display a view. Something I’m doing wrong to cause my query to output?

Thanks,
Chris

[turn3636]

Also, when I click “Open in Browser” in the Server Actions to view the results of my query, I get the query:

I’m pretty sure that is not supposed to happen. So right now, I’m dead in the water. I’ve got to finish up some pages before Christmas break, and these are some pretty big queries and I can’t use a view, and now I can’t use the custom query builder.

[mebeingken]

If you have Debug ticked on the custom action query, that should only be used during troubleshooting and needs to be unchecked in order to produce results.

[turn3636]

Debug is checked, but it should still show results in the browser as long as “output” is checked.

[mebeingken]

Sorry, that’s not been my experience.

[turn3636]

Yea, give it a shot. Debug is for looking at the output in the developer tools section of your browser. Click on “Network”, and make sure “XHR” is selected in your developer tools. It will show you your query parameters and error messages and such, but you can still see your output as long as the Output checkbox is checked. You don’t have to turn off debug to see your output.

[turn3636]

Are you saying it works differently for the custom query than it does for the other query builders?

[turn3636]

@patrick, @Teodor, Can you guys take a look at this? I don’t understand what’s going wrong with this. I’ve got to figure out something so I can submit this to my customer.

I created a custom query, click the execute button and it retrieves my data in the preview window. I save it, select it in Server connect and it outputs my query instead of the data. Does the same thing when I view my Action Step in the browser.

[TomD]

I think perhaps @mebeingken gave you the correct answer, but you’re confusing:

with:

Make sure the Debug checkbox is not selected.

[turn3636]

If I uncheck “debug” in the properties window, In the response window in my browser it says an error has occurred, to see the error, enable the DEBUG flag.

I thought the global settings was just that, you have to enable it globally for a project then turn it on/off per action step. I could be wrong though.

[Teodor]

@turn3636

it says an error has occurred, to see the error, enable the DEBUG flag.

This is not the same debug option you are referring to:

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[turn3636]

Well. I owe apologies. I did change it and it took a couple of refreshes but now I see my error. Sorry, just frustrated with myself trying to get it done. I appreciate everyone’s help and politely telling me i’m an idiot and not following the instructions.