This topic is locked

dropdown menus on edit page?

9/7/2005 10:09:22 AM
PHPRunner General questions
scuba author

is it possible to create dropdown menus on the edit page in order to pre-define the values a user can choose. If yes, how - thankful for any comment <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=1826&image=1&table=forumtopics' class='bbc_emoticon' alt=':)' />

Sergey Kornilov admin 9/7/2005

You need to proceed to the Formatting tab in PHPRunner and set Edit as type for those fields to Lookup wizard. Drop-down menus can be aither database-driven or contain a list of hardcoded values.

scuba author 9/8/2005

thanks for the hint - the dropdown works but still I don't get what I need.

I would like to create a dropdown with numers in it from 0 - 7. Each number equals a certain gif.-picture. This is defined in an extra db-tabel:
gif-table

column A |column B

-----------------------

1 | gif_1

2 | gif_2

3 | gif_3

etc.
column A is defined as TINYINT while column B is a TINYBLOB (since the gifs are only about 200 kb).
I want the gifs to be displayed in another table (display-tabel). The column is a TINYBLOB aswell. Using the Lookup Editor I linked the gif-table with the appropriate column in the display-table. So now, on the edit page I can choose a number but the appropriate gif. is not displayed in the display-column.

Would that principally work and I just made a mistake or is that procedure simply not possible? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=5859&image=1&table=forumreplies' class='bbc_emoticon' alt=':blink:' />

Sergey Kornilov admin 9/9/2005

Hi,
this will not work with PHPRunner. Only text values can be displayed from the lookup tables.