 |
willbegood
User
Jul 21, 2008, 11:10 AM
Post #1 of 3
(253 views)
Shortcut
|
|
Populate a list from another menu
|
Can't Post
|
|
Hello, it's getting me mad!
I have a menu lets sait "Data Sheet", it's a menu to display uploaded pdf.
Each data sheet have
- title
-description
- file (upload)
I have another menu "article" composed as below
- title
- description
- image (uploaded)
- pdf files (this is where i want a list populating from "Data sheet" menu wich will show me the list of the uploaded pdf files
I want the viewer to be able to show me the article and at the end"pdf" link.
|
|
| |
|
willbegood
User
Jul 21, 2008, 11:54 AM
Post #2 of 3
(245 views)
Shortcut
|
Near to be solved... just need to filter some empty data
[In reply to]
|
Can't Post
|
|
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
|
|
| |
|
Dave
Staff
/ Moderator
Jul 22, 2008, 9:39 AM
Post #3 of 3
(227 views)
Shortcut
|
|
Re: [willbegood] Near to be solved... just need to filter some empty data
[In reply to]
|
Can't Post
|
|
Hi willbegood,
Try having a field datasheetNum (list field) load from the data sheet section:
Section tablename > Data Sheets
Use this field for option values > num
Use this field for option labels > title
And then use a second viewer at the bottom of the page to load the datasheet with:
'where' => "num = '{$articleRecord['datasheetNum']}'",
Let me know if that works for you.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
