[web2py] Re: Help creating RESTful webservice

2013-08-26 Thread GregD
Niphlod, You right, I didn't have to reimport the pyodbc. I'm connecting to the database now, but still getting an error. I think it has something to do with how I define the field RowVersion. RowVersion is defined as a timestamp data type in MS SQL Server 2012. How do I define that in the

[web2py] Re: Help creating RESTful webservice

2013-08-26 Thread Derek
Don't think you can. RowVersion is not a datetime, and can't be converted to one. Web2py does not have a 'rowversion' type field. You can't update it, and reading it isn't very useful unless you are doing opportunistic locking or something similar. On Monday, August 26, 2013 10:02:47 AM

[web2py] Re: Help creating RESTful webservice

2013-08-23 Thread Niphlod
seems that you're using the binary version. May I ask why do you need to reimport pyodbc on your own ? Why not just using db = DAL(mssql:// etc etc etc ) ? On Friday, August 23, 2013 8:09:45 PM UTC+2, GregD wrote: Hi, We're new to Web2py and starting to use it more and more to meet