MySQL & .NET - Insert Identity & Boolean Values Incorrect

Wappler Version : 1.9.9
Operating System : Windows 10

Expected behavior

Identity returned after insert should be something like 123, 13 etc.
Setting boolean type value in insert/updpate query action should treat value as numeric - 0, 1

Actual behavior

Identity returned after insert is 123.0, 13.0 etc.
Setting boolean type value in insert/updpate query action is treated as - '0', '1'

How to reproduce

Open a .NET/IIS project. Create a new insert query for a database in MySQL. Connect with Driver 8.0. Insert boolean value in a table and retrieve its last inserted ID using identity option in server action.

@patrick @George Still awaiting fix for this. Have again encountered this with the latest version.
It was not fixed in any of the versions since 1.9.9.

Are you sure you have chosen the right database field types for the insert and Boolean Sid? Which types have you used?

Field type in DB is BIT(1). The value accepted is in the format b'0' or 0 for false (and 1 for true).
Wappler is inserting the value as a string - "0" which fails.

Hmm I see that is wrong indeed.
And the identity?

@patrick will check it out

Btw why don’t you use php with MySQL?

it’s a client project. legacy systems. we’ve joined in mid way. hence must work with this setup.

Identity I haven’t tested again will check and update you on Monday.

The client has IIS servers, and MySQL DB.
Their existing projects are all in Visual Studio etc… so he wanted to keep it ASP.NET I think.

Although, Windows IIS servers support PHP, there might be other reasons.

I’ve always had problems with Wappler MS SQL connections and Table queries/inserts/updates.

My projects are Classic ASP with IIS and Connections to SQL Server 2012+.
My tables have ID’s that are INT’s (int, null) and Wappler defines them as double.

e.g

“table”: “Quotations”,
“wheres”: {
“condition”: “AND”,
“rules”: [
{
“id”: “QuoteID”,
“field”: “QuoteID”,
“type”: “double”,
“operator”: “equal”,
“value”: “{{$_GET.quoteid}}”,

I have to manually change the type to “number” which fixes a few issue I get.

Identity seems to be working fine now. Although, I do see that its treated as a string value rather than a number.

@George @patrick Any update on this? Is it getting resolved in this week’s update?