The default value should be the file name, but you don't have to set it
when you define the table in the model. Instead, set the default in the
controller right *before* you create the form:
db.project.project_pdf.default = the_file_name
Simply setting form.vars.project_pdf will not work.
Anthony
On Monday, February 29, 2016 at 2:32:55 AM UTC-5, killzane wrote:
>
> So if I have this field in db.project
> Field('project_pdf', 'upload', label='Project PDF', comment='',
> uploadfolder='app/uploads'),
>
> I must change to
> Field('project_pdf', 'upload', label='Project PDF', comment='',
> uploadfolder='app/uploads', default=''),
> what content should I put in "default" attribute?
> the file name? or folder path?
> records have same folder path but different file name.
>
> Even if I change "form.var.project_pdf", the link button won't appear?
>
>
> Anthony於 2016年2月29日星期一 UTC+8上午8時51分27秒寫道：
>>
>> The widget gets created when the form is initialized, so if you want to
>> specify a value for the file URL, you should do it by setting the "default"
>> attribute of the upload field in the db.project table *before* creating
>> the table.
>>
>> Anthony
>>
>> On Sunday, February 28, 2016 at 10:07:28 AM UTC-5, killzane wrote:
>>>
>>> I want to modify a record from db.project, and there are a reference
>>> field in db.project.
>>> So I use SQLFORM.factory to add field to put reference list name.
>>>
>>> the code I paste is simplify version
>>> here is full code
>>> project = db((db.project.id == 1) & (db.frature.project_id ==
>>> 1)).select(db.project.ALL, db.feature.ALL).first()
>>>
>>> form = SQLFORM.factory(Field('list_name', 'string', label='List Name'),
>>> db.project, db.feature, table_name='project',upload=URL('download'))
>>>
>>> for t in [db.project, db.project_feature]:
>>> query = t.id == project.id if t == db.project else t.project_id ==
>>> project.id
>>> __copydata(db(query).select(limitby=(0,1)).first(), form.vars,
>>> t.fields)
>>>
>>> so, that me ask another question:
>>> How to make SQLFORM.widgets.upload.widget work.
>>> I mean make the link button appear.
>>> what content I need to put in form.var?
>>>
>>> Anthony於 2016年2月28日星期日 UTC+8下午9時29分52秒寫道：
>>>>
>>>> Sorry, still not clear what you are trying to do, and you have not
>>>> explained why you are iterating over the Fields of the db.project table.
>>>>
>>>> On Sunday, February 28, 2016 at 3:48:26 AM UTC-5, killzane wrote:
>>>>>
>>>>> Because I want to add other field to the form so I use SQLFORM.factory.
>>>>>
>>>>> And this is my __copydata method
>>>>> def __copydata(src, dest, fields):
>>>>> if src:
>>>>> for k in fields:
>>>>> if src.has_key(k):
>>>>> dest[k] = src[k]
>>>>> return dict()
>>>>>
>>>>>
>>>>>
>>>>> Anthony於 2016年2月26日星期五 UTC+8下午9時08分13秒寫道：
>>>>>>
>>>>>>
>>>>>> for t in db.project:
>>>>>>> query = (t.id == request.vars.id)
>>>>>>> __copydata(db(query).select(limitby=(0,1)).first(), form.vars,
>>>>>>> t.fields)
>>>>>>>
>>>>>>
>>>>>> The above is confusing and cannot be the actual code, as it would
>>>>>> raise an exception. When you iterate over db.project, you get its Field
>>>>>> objects (so each value of "t" is a Field object). Field objects do not
>>>>>> have
>>>>>> ".id" or ".fields" attributes, so both of the next two lines would
>>>>>> result
>>>>>> in errors. Perhaps you instead mean to be iterating over Table objects,
>>>>>> but
>>>>>> it's not clear why you would be doing that, as the form is based on just
>>>>>> a
>>>>>> single table.
>>>>>>
>>>>>> Anthony
>>>>>>
>>>>>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
