https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× This is the optional Forum header for the Suggestion Box.

Can the Table JX Grid be configured to download

  • dalonehacker
  • dalonehacker's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 4 months ago #642

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..com/components/com_chronocontact/uploads/requestquote/} (..without curly brackets...)

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

Last edit: 14 years 4 months ago by dalonehacker.

Please Log in or Create an account to join the conversation.

More
14 years 4 months ago #648

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
(above solution was not tested, but it should work)

You will get something like:
www.domain.com/documents/JohnTravolta.jpg

Best regards,
Viljem

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.132 seconds

Contact Us

Contact us on Discord

Contact us on Facebook