The attachment field 'handle' contains the raw binary data of your uploaded file. Generally don't want to retrieve this field for all nodes in a list. It seems to me you just need the filename, which can be retrieved from the field 'filename'.
Rob van Maris Technical Consultant Quantiq xmedia & communication solutions Koninginneweg 11-13 1217 KP Hilversum T +31 (0)356257211 M +31 (0)651444006 E [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ted Vinke Sent: woensdag 9 juni 2004 17:00 To: [EMAIL PROTECTED] Subject: handle of a file? Hi! I've got a builder named 'blob' which extends 'attachments', because it contains an additional field 'date'. Now I'm using it in the backend to upload files with it and I'm figuring out how I have to construct the url to the file on the frontend when I'm generating a list - so the browser can download it. With the construction (where ${pfid} contains the startnode of type projectfolder): <mm:list nodes="${pfid}" path="projectfolder,blob" fields="blob.title,blob.description,blob.date,blob.number" orderby="blob.date" directions="DOWN" > I'm able to retrieve all information, but I found out the url /mmbase/attachments/session=cloud_mmbase+48294/TestDocument.xls would also need the actual name of the uploaded file, not just blob.title. But when I extends the fields attribute with blob.handle I'm getting a javax.servlet.ServletException: SearchQuery...failed: ERROR: column blob.handle does not exist errormessage. Since the original attachments-object has a handle, I should be able to acces blob.handle too right? How else I'm a going to construct the url to the file I want to download the file as in: /mmbase/attachments/session=cloud_mmbase+[blob.number]/[blob.handle] (here I ofcourse I'll have to use ${...} variables instead of [] :D) Anybody an idea? Regards, Met vriendelijke groet, Ted Vinke First8 BV Groenestraat 294 6531 JC Nijmegen [EMAIL PROTECTED]
