In the error page I find the following in the arguments. *File F:\trr\web2py\web2py\gluon\dal.py in update_or_insert at line 9380* code arguments variables Function argument list
(self=<Table cms_meas_details (id,meas_id,agt_no,jcod,...,m_content,remarks,update_uid,update_dt,line_no)>, _key=<Query (((((cms_meas_details.jcod = 'TR001') AND...hift = '1')) AND (cms_meas_details.line_no = 1))>, **values={'agt_no': '10001', 'jcod': 'TR001', 'line_no': 1, 'loc_of_work': 'test', 'm_breadth': '', 'm_content': '2.000', 'm_depth': '', 'm_length': '', 'm_no': '1.0', 'm_times': '2.0', ...}) I do not know where to see the generated query. I am a newbie. Thank you for the interest shown. On Friday, November 28, 2014 10:56:16 AM UTC+5:30, T.R.Rajkumar wrote: > > When I do update_or_insert into a table in postgresql I get the following > error. My code is below. > <class 'gluon.contrib.pg8000.errors.ProgrammingError'> ('ERROR', '42601', > 'syntax error at or near "<"') > > if form.process(keepvalues=True,onvalidation=validate_meas).accepted: > j = 1 > for i in range(1,n+1): #len(l)+1 > if is_number(form.vars['txt%s%s' % (i,9)]): > db.cms_meas_details.update_or_insert(db(db. > cms_meas_details.agt_no==session.agt_no) & (db.cms_meas_details.jcod== > session.jcod) & (db.cms_meas_details.meas_date==session.meas_date) & (db. > cms_meas_details.shift==session.shift) & (db.cms_meas_details.line_no==j), > meas_id=m_id,agt_no=session.agt_no, > jcod=session.jcod, > meas_date=session.meas_date, > shift=session.shift, > loc_of_work=form.vars['txt%s%s' % > (i,1)], > m_no=form.vars['txt%s%s' %(i,2)], > m_times=form.vars['txt%s%s' %(i,3 > )], > m_length=form.vars['txt%s%s' %(i, > 4)], > m_breadth=form.vars['txt%s%s' %(i > ,5)], > m_depth=form.vars['txt%s%s' %(i,6 > )], > mat_code=form.vars['cmbMat%s%s' > %(1,7)], > unit_weight=form.vars['txt%s%s' > %(i,8)], > m_content=form.vars['txt%s%s' %(i > ,9)], > remarks=form.vars['txt%s%s' %(i, > 10)], > update_uid="e34789", > update_dt=request.now, > line_no=j) > j = j + 1 > > > def is_number(s): # Thanks a1an > http://stackoverflow.com/questions/354038/how-do-i-check-if-a-string-is-a-number-in-python > try: > n=str(float(s)) > if n == "nan" or n=="inf" or n=="-inf" : return False > except ValueError: > try: > complex(s) # for complex > except ValueError: > return False > return True > > Is this postgressql error? What should I do? How to debug and find what > is wrong. Pl. help. > > > > -- 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.