Xata•15mo ago

Sql over http unused parameters.

I need help using the typescript sdk to pull data using sql.

const my_nam = 'interbro'
const my_date = '2020-04-01'
const result = await xata.sql`SELECT * FROM table WHERE name = ${my_nam} AND date = ${my_date}

const my_nam = 'interbro'
const my_date = '2020-04-01'
const result = await xata.sql`SELECT * FROM table WHERE name = ${my_nam} AND date = ${my_date}

const my_nam = 'interbro'
const my_date = '2020-04-01'
const result = await xata.sql`SELECT * FROM table WHERE name = ${my_nam} AND date = ${my_date}

const my_nam = 'interbro'
const my_date = '2020-04-01'
const result = await xata.sql`SELECT * FROM table WHERE name = ${my_nam} AND date = ${my_date}

When I run this, I get the error,

Invalid SQL: unused parameters: used 1 of 2 parameters.
status: 400

Any help?