form.vars.updated_on= now
what's now?
form.vars.posted_by = "Rahul"
posted_by must be an id.
On Nov 22, 3:21 am, Rahul <rahul.dhak...@gmail.com> wrote:
> What's inside "now"?
> Inside "now" contains this -
> import datetime; now = datetime.datetime.now() # For date time
>
> Vinicius, I am sorry about the messed up traceback - Never noticed
> that. simply copy-pasted the same. will take care in future (for now
> its pasted below again)
>
> But I don't understand why the code isnt working when I am serializing
> this in view? It seems to work on the db and even the below code works
> fine -
>
> def before_submit_of_update(form):
> form.vars.updated_on= now
> form.vars.posted_by = "Rahul"
>
> here "now" works fine. what is the problem when I am serializing it?
>
> Traceback (most recent call last): [Reformatted ]
> File "D:\WEB2PY\web2py\gluon\restricted.py", line 194, in
> restricted exec ccode in environment File "D:/WEB2PY/web2py/
> applications/Link_IT/controllers/default.py", line 276, in <module>
> File "D:\WEB2PY\web2py\gluon\globals.py", line 149, in <lambda>
> self._caller = lambda f: f() File "D:/WEB2PY/web2py/applications/
> Link_IT/controllers/default.py", line 58, in index return
> dict(form=form, list_updates=db(db.updates).select())
> File "D:\WEB2PY\web2py\gluon\dal.py", line 5697, in select return
> self.db._adapter.select(self.query,fields,attributes)
> File "D:\WEB2PY\web2py\gluon\dal.py", line 1233, in select rows =
> response(sql)
> File "D:\WEB2PY\web2py\gluon\dal.py", line 1223, in response
> self.execute(sql)
> File "D:\WEB2PY\web2py\gluon\dal.py", line 1309, in execute return
> self.log_execute(*a, **b) File "D:\WEB2PY\web2py\gluon\dal.py", line
> 1304, in log_execute ret = self.cursor.execute(*a,**b)
> File "C:\Python27\lib\sqlite3\dbapi2.py", line 66, in
> convert_timestamp datepart, timepart = val.split(" ")ValueError:
> need more than 1 value to unpack
>
> I am working on other options for splitting etc.
>
> Thanks, Rahul D
> (www.flockbird.com) - web2py powered
>
> Regards, Rahul
> (www.flockbird.com- web2py powered)
>
> On Nov 21, 7:14 pm, Vinicius Assef <vinicius...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Rahul, this is a str.split() error and it happens when there are less
> > pieces than str.split() expects.
>
> > An example:
>
> > >>> fullname = 'John Smith'
> > >>> (first_name, last_name) = fullname.split(" ")
> > >>> print 'first:', first_name, '- last:', last_name
> > John - Smith
> > >>> fullname = 'John'
> > >>> (first_name, last_name) = fullname.split(" ")
>
> > Traceback (most recent call last):
> > File "<pyshell#6>", line 1, in <module>
> > (first_name, last_name) = fullname.split(" ")
> > ValueError: need more than 1 value to unpack
>
> > There weren't 2 parts in fullname. That's why the error occured.
>
> > Back to your problem, the same is happening with your updated_on
> > field. I'd make default=request.now on it.
>
> > BTW, try organize the traceback. It helps people helping you.
>
> > --
> > Vinicius Assef.
>
> > On Mon, Nov 21, 2011 at 10:48 AM, Rahul <rahul.dhak...@gmail.com> wrote:
> > > Hi All,
> > > Is there a solution for below traceback I posted (I am on 1.99.2,
> > > win7, firefox,ie9). Tried search for a solution in below thread .. no
> > > help ...
>
> > >http://groups.google.com/group/web2py/browse_thread/thread/fc4a30879f...
>
> > > Traceback
> > > 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.
> > > Traceback (most recent call last): File "D:\WEB2PY\web2py\gluon
> > > \restricted.py", line 194, in restricted exec ccode in environment
> > > File "D:/WEB2PY/web2py/applications/Link_IT/controllers/default.py",
> > > line 276, in <module> File "D:\WEB2PY\web2py\gluon\globals.py", line
> > > 149, in <lambda> self._caller = lambda f: f() File "D:/WEB2PY/
> > > web2py/applications/Link_IT/controllers/default.py", line 58, in
> > > index return dict(form=form, list_updates=db(db.updates).select())
> > > File "D:\WEB2PY\web2py\gluon\dal.py", line 5697, in select return
> > > self.db._adapter.select(self.query,fields,attributes) File "D:\WEB2PY
> > > \web2py\gluon\dal.py", line 1233, in select rows = response(sql)
> > > File "D:\WEB2PY\web2py\gluon\dal.py", line 1223, in response
> > > self.execute(sql) File "D:\WEB2PY\web2py\gluon\dal.py", line 1309, in
> > > execute return self.log_execute(*a, **b) File "D:\WEB2PY\web2py
> > > \gluon\dal.py", line 1304, in log_execute ret =
> > > self.cursor.execute(*a,**b) File "C:\Python27\lib\sqlite3\dbapi2.py",
> > > line 66, in convert_timestamp datepart, timepart = val.split("
> > > ")ValueError: need more than 1 value to unpack
>
> > > here is my controller (default.py) --------------
>
> > > def index():
> > > return dict( list_updates=db(db.updates).select())
>
> > > here is the view (index.html) ---------
>
> > > {{right_sidebar_enabled=False}}
> > > {{extend 'layout.html'}}
> > > {{=list_updates}}
>
> > > my model (db.py)-------------
>
> > > db.define_table('updates',
> > > Field('description', 'text'),
> > > Field('updated_on','date', readable=False,
> > > writable=False, default=now),
> > > Field('posted_by', readable=False, writable=False,
> > > length=512)
> > > )
>
> > > Please help .. what could be the issue.. I even cleared the db. the
> > > issue still persists.
>
> > > Regards, Rahul
