[web2py] web2py.js disables submit buttons when submitting form with ajax

2014-01-28 Thread Oleg Marin
Hi! I'm trying to submit form with $.post(), by attaching function handling event "submit". And when it send ajax request to server some handler from web2py.js disables submit button, and changes it's value to "Working...". Alright, it is good behavior. But it doesn't re-enable it after ajax c

[web2py] binary(1024) field truncates to 255

2014-01-29 Thread Oleg Marin
Hi! I'm using MSSQL2008 in readonly without tables definition, and when I run stored procedure with executesql, it returns field of type binary(1024) truncated to size of 255. Running same procedure directly with pyodbc works well. Is it a bug, or something I have missed? -- Resources: - htt

[web2py] MSSQL binary(1024) field truncated to length of 255

2014-01-29 Thread Oleg Marin
Hi! I'm using MSSQL 2008, and when I run stored procedure with executesql, among other it returns field of type binary(1024) truncated to length of 255. Pyodbc directly works well. Is it a bug? Or maybe I have missed something? -- Resources: - http://web2py.com - http://web2py.com/book (Docum

[web2py] Re: binary(1024) field truncates to 255

2014-01-30 Thread Oleg Marin
cursor.execute('abc') > cursor.fetchall() > > > > On Wednesday, January 29, 2014 12:55:51 PM UTC+1, Oleg Marin wrote: >> >> Hi! >> >> I'm using MSSQL2008 in readonly without tables definition, and when I run >> stored procedure with exe

[web2py] Re: binary(1024) field truncates to 255

2014-02-08 Thread Oleg Marin
I'm sorry for long silence, I was busy. I solved my problem. At first, I didn't specified TDS version in connection string. Then I found that connection string at least for mssql not fully URI-compliant, multiple parameters after question sign separating by "; " instead of "&". I think it needs

[web2py] Single form for many to many relationship

2014-02-14 Thread Oleg Marin
Hi! I'm looking for solution for nice single SQLFORM for many to many relationship. For example I have such model: db.define_table('person', Field('name'), Field('position'), Field('office', 'integer')) db.define_table('thing', Field('name'), Field('color')) db.define_table('person_thing', Fiel