I’m trying to do something like below to insert data into my DB.
INSERT INTO USERS VALUES (2, 'Michael', 'Blythe'), (3, 'Linda', 'Mitchell'), (4, 'Jillian', 'Carson'), (5, 'Garrett', 'Vargas');
I know how I can do this using tags (i.e., a cfloop inside the cfquery, using cfqueryparam’s).
How can I accomplish the same using the cfsscript version (i.e., queryExecute)? I know I can loop to create the SQL but how do I incorporate the cfqueryparam’s for multiple rows? I’d rather not skip the cfqueryparam/cfsqltype as best practice…