Open Daemach opened 2 years ago
Just an FYI, a workaround would be using named params in your SQL statement as follows:
use :dbName
and then use named params in queryExecute()
as follows:
queryExecute(sql="
use master
....
use :dbName
",
params=[
{name="dbName", value=arguments.name, cfsqltype="cf_sql_varchar"}
],
options={
datasource: dsn
}
);
@redtopia no argument here. I was just being lazy, but figured this might pop up in other cases as well.
Great library. I appreciate your time in developing and maintaining it. With the code below, syntax highlighting breaks on the line that restores the database, with the first instance of #. If you insert a space, it fixes the highlighting but breaks the file path, of course.