I don't think some of these functions are available to mySQL. I am new to using it and wonder if anyone can help.
Here is a much shortened version of the script. I think it has to do wth the @@rowcount, begin, end syntax...
SET ItemID=<cfqueryparam cfsqltype="cf_sql_varchar" value="#thisItem.itemId#">
WHERE ItemID= '#thisItem.itemId#'
IF @@ROWCOUNT = 0
INSERT INTO item
(<cfqueryparam cfsqltype="cf_sql_integer" value="#getNextKeywords.keyword_ID#">)