Robert Zehnder
06/21/2023, 6:13 PMqueryExecute no longer return the generatedKey? I am not seeing the value returned in query resultsRobert Zehnder
06/21/2023, 6:14 PMjamiejackson
06/21/2023, 6:16 PMjamiejackson
06/21/2023, 6:18 PMRobert Zehnder
06/21/2023, 6:19 PMRobert Zehnder
06/21/2023, 6:19 PMqueryExecute("INSERT INTO SerializedPosts (posts_id, data) values(uuid_to_bin(:posts_id), :data)", {
'posts_id': { value: "44749a86-06df-11ee-9ad6-4aabbc1875a4", cfsqltype: "cf_sql_varchar"},
'data': {value = "{}", cfsqltype: "cf_sql_varchar"}
},
{
datasource: "renegade",
result: "results"
});
dump(results);Robert Zehnder
06/21/2023, 6:20 PMjamiejackson
06/21/2023, 6:21 PMRobert Zehnder
06/21/2023, 6:22 PMjamiejackson
06/21/2023, 6:22 PMRobert Zehnder
06/21/2023, 6:23 PMRobert Zehnder
06/21/2023, 6:23 PMRobert Zehnder
06/21/2023, 6:24 PMRobert Zehnder
06/21/2023, 6:36 PMRobert Zehnder
06/21/2023, 6:37 PMRobert Zehnder
06/21/2023, 6:38 PMjamiejackson
06/21/2023, 6:38 PMRobert Zehnder
06/21/2023, 6:39 PMuuid() as a defaultRobert Zehnder
06/21/2023, 6:40 PMjamiejackson
06/21/2023, 6:42 PMRobert Zehnder
06/21/2023, 6:42 PMRobert Zehnder
06/21/2023, 6:52 PMcreateGUID() creates a valid guid in mysql. I can make that work. Thanks again