Hello All

How to get the id value after insert a record a record using dbh:query

table_a - columns.

id - auto increment
field1
field2


dbh:query("insert into table_a ( field1,field2) values ('11','Test')")


After insert how to get the table_a - id value for the inserted record?

Thanks
Lloyd