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
