Simple Query not working correctly

[Chackmool]

I'll do my best to explain as clearly as possible.

I have an app with a database table projectList

When you create a Simple database query.

As you can see, I’m using 109 as the test value, and the condition is set to "EQUAL."

The results come out as expected and everything works fine.

However, if I change the test value to "109test," the result doesn't behave as expected.

In theory, the query should return empty results, but in reality, it returns the same results as with the "109" test value.

It seems that the "Equal" condition is behaving more like a "%LIKE%" condition, instead of strictly matching the value.

Is there a solution to this, or am I doing something wrong? I am on Beta 14

[ben]

Have you considered that the ID is numeric and 109test is not? Maybe the test part is ignored.

[Chackmool]

dont know how ir work. Maybe as you told is ignores by default.

[ben]

Try testing further with a numeric like 10987

[Hyperbytes]

I never trust the inbuilt query results tab, there serms to be some issues with it.
Try running the action directly in the browser and check the results therere.

Dont forget to manualy add the parameter. I.e.?idproject=1234 etc

[Chackmool]

@Hyperbytes

Try running the action directly in the browser and check the results there.

This dont trow any results. As you told me the 'test' word is ignored.