Just fixed my problem.
Instead of doing the SQLFORM.factory, I just did a SQLFORM(db.attachment)
and set the readable/writable attributes to false on the fields I didn't
want to see.
So, this works for me.
Sorry for the noise.
-Jim
On Thursday, November 7, 2013 4:12:54 PM UTC-6, Jim S wrote:
>
> Just found something else interesting about this:
>
> I created one document using a test controller I'd created with a simple
> SQLFORM.grid in it. That one I can retrieve. There are 2 documents that
> were created with the SQLFORM.factory as detailed below, and they don't
> work.
>
> The one that was created with SQLFORM.grid is named:
>
>
> attachment.document.ac4eaf2513b348f0.6469737472696275746f725265626174652e706466.pdf
>
> The 2 created with SQLFORM.factory are:
>
>
> no_table.document.abdf7e081804a484.6469737472696275746f725265626174652e706466.pdf
> no_table.document.bc7c124a9de673f3.62617365646f632e706466.pdf
>
> Not sure why the good one is prefixed with attachment and the other two
> say no_table.
>
> Any ideas?
>
> -Jim
>
> On Thursday, November 7, 2013 3:32:09 PM UTC-6, Jim S wrote:
>>
>> I have a table with an upload field:
>>
>> attachment = db.define_table('attachment',
>> Field('attachmentId', 'id', readable=False),
>> Field('name', length=50, label='Name', required=True),
>> Field('employeeId', db.employee, label='Employee'),
>> Field('ticketId', db.ticket, label='Ticket'),
>> Field('document', 'upload', label='Docment',
>> uploadfolder=
>> '//serverName/documentStore/sideboardHR/documents'))
>> db.attachment.name.requires = IS_NOT_EMPTY()
>>
>>
>> I insert documents into it using:
>>
>> attachmentForm = SQLFORM.factory(Field('name', length=50, label=
>> 'Name',
>> required=True, requires=db.
>> attachment.name.requires),
>> Field('document', 'upload', label=
>> 'Document',
>> required=True, requires=db.
>> attachment.document.requires,
>> uploadfolder=db.attachment.
>> document.uploadfolder),
>> _id='attachmentForm', _formname=
>> 'attachmentForm')
>>
>>
>> if attachmentForm.process(formname='attachmentForm').accepted:
>> fields = attachmentForm.vars
>> ticket = db.ticket(ticketId)
>> if fields['name'] and fields['name'] != '' and fields['document']
>> and fields['document'] != '':
>> db.attachment.insert(name=fields['name'],
>> ticketId=ticketId,
>> employeeId=ticket.employeeId,
>> document=fields['document'])
>>
>>
>>
>> Documents are getting there just fine. I'm using SQLFORM.grid to display
>> them in a list. The list creates a link for me to retrieve the file. When
>> I click on the link I get a 404 NOT FOUND returned to me.
>>
>> Any clues? What am I missing?
>>
>> -Jim
>>
>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
