No way to set which file is downloaded from a recordset?

I have a list of documents but it always downloads the very first document. There is no way to set which document it should download?

And it always increments the dl counter for the first record.

if you are going to use a recordset to tell which file to download, you need to create a way to filter the recordset.

what i normally do is to have a recordset that is used to populate the page. create a form with a submit button and a hidden element, set the hidden element initial value to use the ID column from the recordset. then add a repeat region around the form so that a separate form is created for each record.

you then need to create a lookup recordset that is set to filter the ID column on the hidden form element value

in the download behavior, use the lookup recordset instead of the one that populates the page.

"you then need to create a lookup recordset that is set to filter the ID column on the hidden form element value"

Can you do that without creating another page?

yes, you can create the lookup recordset on the same page.

It seems that I have the same problem, I tried to apply the method described, but nothing helps. The transmitted file has the same name as my page, not the file itself. I put the code attached files used. Thank you for your help.

in the form, the hidden element is named "hiddenField";

<input name="hiddenField" type="hidden" id="hiddenField" value="<?php echo $row_rs_fichier['IDfichier']; ?>" />

in the recordset, you have set the filter to use the IDfichier column and a form element named "IDfichier", which does not exist.

you will need to change the name of the form element:

<input name="IDfichier" type="hidden" id="IDfichier" value="<?php echo $row_rs_fichier['IDfichier']; ?>" />

in the Download behavior, you have set the File name to use the IDfichier column from the recordset Is that column the ID column or the file name column?

Thank's for your help, the problem came in the form and the hidden field.

glad to hear it is working.