I was trying this into MySQL, which I knew probably wouldn’t work:
<cffile action="WRITE" file="ram://TheData.tab" output="#TheData#" addnewline="No" fixnewline="No"> <cfquery name="InsertData" datasource="ds"> LOAD DATA LOCAL INFILE 'ram://TheData.tab' INTO TABLE tbname FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' (field1, field2, field3) </cfquery>
and as expected, it didn’t. (Unable to open file ‘ram://TheMajors.tab’ java.io.FileNotFoundException in ACF, and “Could not send file : ram:\TheMajors.tab” in Lucee)
Is there a way to make a ram drive accessible outside of CF tags which are obviously aware of and can access ram drives CFML creates? This would be access from within a JDBC driver I suppose?