Retrieve the auto generated key from a MySQL resultset

2008-05-02 Thread marc --
From the docs @ cfquery - The cfquery tag also returns the following result variables in a structure. You can access these variables with a prefix of the name you specified in the result attribute.[...] result_name.GENERATED_KEY MySQL only. The ID of an inserted row. MySQL 3 does not

RE: Retrieve the auto generated key from a MySQL resultset

2008-05-02 Thread Dave Watts
From the docs @ cfquery - The cfquery tag also returns the following result variables in a structure. You can access these variables with a prefix of the name you specified in the result attribute.[...] result_name.GENERATED_KEY MySQL only. The ID of an inserted row. MySQL 3

RE: Retrieve the auto generated key from a MySQL resultset

2008-05-02 Thread Bobby Hartsfield
the auto generated key from a MySQL resultset From the docs @ cfquery - The cfquery tag also returns the following result variables in a structure. You can access these variables with a prefix of the name you specified in the result attribute.[...] result_name.GENERATED_KEY MySQL only. The ID