@jisaacs46 That's because functions return the value of their last expression -- drop-tables will return the second string.

You would see that by running this code in the REPL: (drop-tables)

How do I drop multiple tables using my function?

I think you want something like

note that now drop-tables returns a vector of statements

does that help @jisaacs46 ?

Yes thank you I’ll try that out @joost-diepenmaat

@joost-diepenmaat

How would I use and call sql queries with named parameters?

For example SELECT * FROM pay WHERE pay_start_dt = :date OR pay_end_dt = :date

java.jdbc only supports positional parameters SELECT * FROM pay WHERE pay_start_dt = ? OR pay_end_dt = ? and you'd specify the actual date twice in the parameter list.

Ok, I’ll just do that, thanks @seancorfield

Can I use the as keyword in my selects? Ex. SELECT start_dt as payDate FROM pay

@josmith2016 Yes. Did you try it?

Nvm, I was getting an error but I guess it was something else