SQL Select with a value from the valuelists.ini

Archived from the Xataface Developers forum.

siggj — Wed Aug 25, 2010 2:26 am

Hello, I want to do something, but I don’t find informations about this.

I have a sql select like :

__sql__ = “SELECT ID_Event, CONCAT(name, ‘ (‘ , status, ‘)’) FROM Event;”

–> status is a int and is associated with a value from the valuelists.ini

My question is : Can I display directly the value from the valuelist.ini ?

Thank you and sorry for my English

---

shannah — Wed Sep 01, 2010 10:49 am

Do you want to get the result of this query (i.e. all rows of the valuelist), or just the value of a field that uses this valuelist?

---

siggj — Mon Sep 06, 2010 8:01 am

I want to display the result of this query and replace the “status” (int) to the value from the valuelist.ini…

Do you understand ?

---

shannah — Fri Sep 17, 2010 11:14 am

I need some context to know what you’re trying to do. The answer is invariably ‘YES’ you can do that. I just don’t know what you’re trying to do specifically.

e.g. Are you using a Dataface_Record object trying to get a field display value rather than the id value… or are you wanting to display it somewhere in the app, or are you trying to list out all values of a valuelist….

-Steve