SELECT * FROM #getSafeTableName(tableName)# WHERE #PKName# IN () #PKName# = SELECT * FROM #getSafeTableName(tableName)# var delList = arguments.id; var maxChunkLength = 1000; var numOfChunks = ceiling(listLen(delList)/maxChunkLength); var listAsArray = listToArray(delList); var numOfItems = arraylen(listAsArray); var startItem = ''; var endItem = ''; var k = ''; for (k=1;k lte numOfChunks; k=k+1){ startItem = (k - 1) * maxChunkLength; endItem = startItem + maxChunkLength; if (endItem gt numOfItems){ endItem = numOfItems; } deleteChunks(arrayToList(listAsArray.subList(startItem, endItem)),arguments._mapTableInfo,arguments._mapColumns); } DELETE FROM #getSafeTableName(tableName)# WHERE #PKName# IN () #PKName# = var stTblColumns = arguments._mapColumns; var stTableInfo = arguments._mapTableInfo; var stColumns = structNew(); var arg = ""; var theID = arguments.id; var pkName = arguments._mapTableInfo.PKName; structDelete(arguments, pkName, false); structDelete(arguments, "_mapTableInfo", false); structDelete(arguments, "_mapColumns", false); for(arg in arguments) { if(structKeyExists(stTblColumns,arg)) { stColumns[arg] = duplicate(stTblColumns[arg]); stColumns[arg].value = arguments[arg]; } } if(val(theID) eq 0) theID = _insertRow(stColumns, stTableInfo); else _updateRow(theID, stColumns, stTableInfo); SELECT * FROM #getSafeTableName(tableName)# WHERE (1=1) and #key# LIKE and #key# = #preserveSingleQuotes(arguments.sql)# INSERT INTO #getSafeTableName(tableName)# (#pkeyName#,#lstFields#) VALUES ( #seqName#.nextVal, , ) select #seqName#.currVal as lastId from dual INSERT INTO #getSafeTableName(tableName)# (#lstFields#) VALUES ( , ) SELECT SCOPE_IDENTITY() AS lastID ;SELECT lastval() AS lastID; SELECT LAST_INSERT_ID() AS lastID SELECT @@IDENTITY AS lastID INSERT INTO #getSafeTableName(tableName)# (#lstFields#) VALUES ( , ) UPDATE #getSafeTableName(tableName)# SET #col# = , WHERE #PKName# =