Im getting the below error message
Error Executing Database Query.
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'select last_insert_id() as scope_identity' at line 13
Heres where i have scope_identity:
SELECT last_insert_id() AS scope_identity;
<cfset Variables.invArray[Variables.invoiceCounter].invKey = qinsertinvoice.scope_identity>
Can anyone help me out here in fixing this error