nuBuilder Forum

Posted: **Wed Feb 13, 2013 11:18 am**

Hi,
I'm using Hash Variables in Default Value SQL:

SELECT IF('#dec_site#'='site1', '1511a0e757cc37', '511a0e4fccb19') FROM location

But does not work.
Can I use Hash Variables? Is something wrong with my code?

Thank you.

Posted: **Thu Feb 14, 2013 1:21 am**

Rui,

You don't need from location

SELECT IF('#dec_site#'='site1', '1511a0e757cc37', '511a0e4fccb19')

Steven

Hash Variables in Default Value SQL for Lookup