Near to be solved... just need to filter some empty data
Ok, i'm near to solve my problem, but.. (heyhey i'm the "but" man!!!).
Here is what i've done to make it work.
In my menu "Data Sheet" > on my field "file"(upload) i've defined an extra field (info1) wich i called "name".
The in my menu "Article" i add another field pdf_file (list).
I populate list as below
List option > Get option from database (advanced)
Section tablename > Uploads
Use this field for option values > urlPath
Use this field for option labels > info1
My problem is, as i ask for all the "info1" entry from the files in the uploads directory, i have some blank lines in my Combo (list), because i do not use extra fields info1, info2, info3 etc when uploading image in other menu for exemple.
So what i need is a little filter (perhaps an SQL Query) to help wich will only put info1 data that are NOT empty.
I hope my question is clear.
Sorry for my english, i'm french, i try my best
[:P]