- Posts: 10
- Thank you received: 0
Hi Viljem,
Thank you for your help.
I used your suggestions and have managed to make it work.
How i did it was as below:
1. Using phpAdmin i created 2 fields frm_dir1 and frm_dir2
2. I assigned frm_dir1 a default value of {<a href="http://www.
3. I assigned frm_dir2 a default value of {>Download</a>}
(..without curly brackets...)
4. Then I created a view, {CREATE VIEW requestquote_view as SELECT frm_name,frm_email,concat(frm_dir1,frm_file,frm_dir2) as Filename,`recordtime`,`ipaddress` FROM jos_chronoforms_requestquote;}
5. I recreated my list using Table JX to get from the view table
After this steps when i ran my list i could see a hyperlink on Download which when clicked downloads the referred file.
It works!!
Thank You again Viljem.
PS. Is there a way i can do this same thing without using the view table? Is there a way i can get Table JX to concatenate the directory and filename just before displaying on the list?
Please let me know if you have any ideas on this.
Regards
Please Log in or Create an account to join the conversation.
Hi,
no problem, I am glad to help you.
1.If not using the view you can still write a piece of php code
2.Nice solution for that would be sql view.
e.g.
CREATE VIEW Something AS
SELECT CONCAT('www.domain.com/', Folder, '/', FileName)
FROM Table
Please Log in or Create an account to join the conversation.