Welcome to the nuBuilder Forums!

Join our community by registering and logging in.
As a member, you'll get access to exclusive forums, resources, and content available only to registered users.

Hash Variables in Default Value SQL for Lookup

Post Reply
ruiascensao
Posts: 177
Joined: Tue Nov 15, 2011 2:24 pm

Hash Variables in Default Value SQL for Lookup

Unread post by ruiascensao »

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

Code: Select all

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.
BR
Rui
Top
admin
Site Admin
Posts: 2825
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 30 times

Re: Hash Variables in Default Value SQL for Lookup

Unread post by admin »

Rui,

You don't need from location

Code: Select all

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

Steven
Top
Post Reply

Return to “General”