How to get last value when you make insert query for mysql in coldfusion?
This is what i want to do.
I create an album, and after that it goes automatically to image page. So I need to get last auto increment value in insert coding and redirect to insert image page by sending last auto increment value as parameter.
<CFQUERY NAME=”INSERTALBUM” DATASOURCE=”MYSOURCE”>
INSERT INTO ALBUM (ref_id,albumname,timestamp) VALUES (null,’ALBUM NAME’,NOW())