SQL Select with a value from the valuelists.ini

A place to discuss development of the Xataface core.

SQL Select with a value from the valuelists.ini

Postby 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 :)
siggj
 
Posts: 12
Joined: Tue Jul 20, 2010 4:22 am

Re: SQL Select with a value from the valuelists.ini

Postby 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?
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm

Re: SQL Select with a value from the valuelists.ini

Postby 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 ? :oops:
siggj
 
Posts: 12
Joined: Tue Jul 20, 2010 4:22 am

Re: SQL Select with a value from the valuelists.ini

Postby 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
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Developers

Who is online

Users browsing this forum: No registered users and 11 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved