This topic is locked

Problem with Lookup Table

10/16/2007 2:05:49 PM
PHPRunner General questions
N
nicolagrimshaw author

Hi
PHPRunner V4.1 (Build 320)
Has anyone else been experiencing problems with lookup tables? I'm trying to recreate something I have done previosuly, sucessufully. When I try to create a dropdown box everything is fine until I select 'unique values' then when I test I get an error
'Failed to get list of values from a database. Check out for errors in custom display expression.'
Also the programme keeps crashing when I do this, however when I upload to the demo account everything seems to work fine. Is it something I am doing wrong or could it be a bug in this build? I'm not 100% sure but I think I used a different build number previously when I didn't get the error.
Thanks

Alexey admin 10/17/2007

Hi,
some databases don't support Unique values and Order by features together.
So either set Order by to the same field you selected in Link field box or select nothing there.