Hi: I am trying to write a fairly simple custom update form as shown below. The application is used in a lab to track "jobs" which consist of many samples each.
The sample names are often more than one word. I am writing a page to edit the existing data base entry. However, when I set the input value={{=row.sample_name}} I only get the first word to prepopulate the input field (i.e. if the sample name is "RED CAR WITH ROOF" , I get-- SAMPLE NAME: RED). I have validated that the sample name are correctly stored in the database. The problem is with all fields in the SAMPLE table, not just sample name. Any help would be appreciated. MODEL: db.define_table('job', Field('job_number', 'integer'), Field('Name), auth.signature) db.define_table('sample', Field('job', 'reference job'), Field('sample_name', 'text'), auth.signature) CONTROLLER: def edit_job(): grid = SQLFORM.smartgrid(db.job, linked_tables=['sample']) return locals() VIEW: {{extend 'layout.html'}} {{if 'sample.job' in request.args:}} * # this is true when I click on the appropriate link in the GRID. This part works as intended. * {{=form.custom.begin}} {{job_id=request.args(2)}}* # This gets the db.jobs.id that links to all the appropriate samples. * {{rows=db(db.sample.job==job_id).select()}} # Selects the appropriate rows associated with the job {{for row in rows:}} #Lists all samples for a job, so I can edit any and all of them. <label for="sample_name"> Sample Name: <input type="text" name="sample_name" id="sample_sample_name" class="text" value={{=row.sample_name}}/> # This is the problem, the input field is prepopulated only with the first word of the sample name. </label> {{pass}} {{=form.custom.submit}} {{=form.custom.end}} {{else:}} {{=grid}} *# This is where the view goes first, after the job is selected it goes to the above view* {{pass}} -- 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.