Resolution found. I looked for an answer all morning before finally posting the question and 10 min after posting I figured it out. I'm still not sure why it gave me an error on a print command, but the problem was because I was searching the wrong table. Once I corrected it that fixed the problem. I hate it when I spend all day looking for an answer that is right in front of my face!
On Tuesday, July 2, 2013 3:13:18 PM UTC-4, Youngblood wrote: > > I am getting the error " invalid literal for long() with base 10: 'test'". > When testing to find the problem it is interesting that I get this error > with a simple print statement. I have searched the group and found several > issues with this same error but none that seem to provide the answer. here > is more details: > > <type 'exceptions.ValueError'> invalid literal for long() with base 10: > 'test'Versionweb2py™Version 2.5.1-stable+timestamp.2013.06.06.15.39.19 > Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > > Traceback (most recent call last): > File "/home/mdipierro/make_web2py/web2py/gluon/restricted.py", line 212, in > restricted > File > "C:/Users/Home/Desktop/web2py/applications/service/controllers/employee.py" > <http://127.0.0.1:8000/admin/default/edit/service/controllers/employee.py>, > line 283, in <module> > File "/home/mdipierro/make_web2py/web2py/gluon/globals.py", line 194, in > <lambda> > File "/home/mdipierro/make_web2py/web2py/gluon/tools.py", line 3022, in f > File "/home/mdipierro/make_web2py/web2py/gluon/tools.py", line 3022, in f > File > "C:/Users/Home/Desktop/web2py/applications/service/controllers/employee.py" > <http://127.0.0.1:8000/admin/default/edit/service/controllers/employee.py>, > line 240, in customers > File > "C:/Users/Home/Desktop/web2py/applications/service/controllers/employee.py" > <http://127.0.0.1:8000/admin/default/edit/service/controllers/employee.py>, > line 102, in getCustomerInfo > File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 9662, in > __repr__ > File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1366, in expand > File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1276, in EQ > File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1376, in expand > File "/home/mdipierro/make_web2py/web2py/gluon/dal.py", line 1830, in > represent > ValueError: invalid literal for long() with base 10: 'test' > > > Relevant part of code: > > 101. myquery=(db.Job.Company==CompanyName) > 102. print ("myquery: ", myquery) > > Anyone know why I am getting this error and how I can correct it? > > -- --- 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/groups/opt_out.
