How to use a String value as part of the SQLinterpolation?

[Miguel Angel Fernandez]

Hi guys,

I'm trying to use a value of String type as part of the SQLinterpolation but simple quotation marks are always added automatically:

val dbName = "myDatabase"

NamedDB(JDBCPoolName) autoCommit { implicit session =>

   sql"""CREATE DATABASE ${dbName}""".update().apply()   

}

The next exception is launched:

SQL execution failed (Reason: ERROR: syntax error at or near "$1"  Position: 17): CREATE DATABASE 'myDatabase'

Any idea?

[Miguel Angel Fernandez]

I answer to myself:

SQL(s"CREATE DATABASE ${dbName}").update().apply()

[Kazuhiro Sera]

Use SQLSyntax.createUnsafely(String) to build the part "dbName".

Kaz

> --
> You received this message because you are subscribed to the Google Groups
> "ScalikeJDBC Users Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to scalikejdbc-users...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.