Hi Massimo,
now contains -
import datetime; now = datetime.datetime.now() # For date time
Thanks, Rahul D
On Nov 22, 7:22 pm, Massimo Di Pierro <[email protected]>
wrote:
> 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 <[email protected]> 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 <[email protected]> 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 <[email protected]> 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
