'scalikeJDBC DslQuery giving for eq (Unspecified value parameter evidence$1)

I have been trying to implement the following SQL query to QueryDSL

SQL

select count(*) 
from table 
where table.createDate=(
    select MAX(table.createDate) 
    from table where table.primary_key='100'
) and table.key='100';

QueryDSL

withSQL(
      select(sqls.count)
        .from(table.as(tab))
        .where
        .eq(table.createDate,
            select(sqls.max(table.createDate))
              .from(table.as(tab))
              .where
              .append(where))
        .and(where)
    ).map(rs => rs.long(1))
      .single
      .apply()
      .get

where is the value keyValue=100 while I am using by SQLSyntax

So this is giving me error :-

not enough arguments for method eq: (implicit evidence$1: scalikejdbc.ParameterBinderFactory
Unspecified value parameter evidence$1.
        .eq(table.createDate

Can anyone help please ?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source