I'm attemping to insert a record into a mySQL table and to get the primary key of the
inserted record. According to the mySQL documentation using this query after the
insert should give the auto incremented key of the inserted record:
SELECT LAST_INSERT_ID() as LastId;
This works fine in the SQL monitor in mySQL - INSERT.. followed by
SELECT LAST_INSERT... delivers the primary key of the just inserted
When I execute the two queries from ActionScript, I get 0 as a result in
So the returned data structure has the element LastId added to it, as per
my query but the value is not correct.
Has anyone had and solved this issue in AS?
Retrieving data ...