Single Query Not Working Reliably in ASP .NET / MSSQL

Wappler General Bugs
,
#1

In an ASP .NET app, when single query step is returning below error:

image
image1373×822 73.4 KB

I have few other tables and Server Actions, where single query is working fine, but not always.
Have tried creating a new SA with just 1 single query, but it fails.

What I have found is that if the query returns more than 1 row, its bound to either return this error or just return null.
But if I add WHERE conditions to ensure that only 1 row is returned, it works.
Also, if I add a single query directly, it just does not work. But if I change it to multi-query and back to single, or just add multi-query to start with and change it to single, it starts working again.

This looks like a bug, but not entirely sure. Please help.

Wappler 5.0.3 Released
#2

Are there other actions in the action file or the query the only one?

#3

Seems to me it is more the input variables like $_GET or $_POST that you have defined and their validation rules.

What exactly do you have there and what is the real value posted?

#4

Query is the only step. Nothing else in the SA.

#5

Nothing POSTed or sent via GET. The input section is empty as well… no variables defined anywhere.

#6
#7

Does the error go away if you have a second step in it? You could add just a comment step for testing.

#8

Here is the latest Server Connect file, the last update had a fix for actions with a single step.

DMXzone.ServerConnect.zip (56.6 KB)

#9

@patrick The update did not work.
I am still seeing a NULL response when the single query step has multiple rows being returned.
I also added a set value step after the query, but no change.

#10

Thx, then it seems to be a different issue, will investigate.

1 Like
#11

Hi @patrick. Any luck with this?

#12

Can you send me the json of your action file, I know where it goes wrong but don’t know when and why it happens. It has to do with the meta data inside the action file.

#13

File sent via personal message.

#14
#15

Fixed in Wappler 5.0.3

#16
#17

This topic was automatically closed after 32 hours. New replies are no longer allowed.