Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums 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: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 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”