Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 05:12:41PM +0200, Ivan Horvath wrote: > here i send the mysqlconnection.py, i made the modification > it works now for me, please test it. I applied both your patches to the trunk and to the 0.7-bugfix branch. Thank you! Oleg. -- Oleg Broytmann

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 04:41:55PM +0200, Ivan Horvath wrote: > ts_project(title=u"ivan project1") > formencode.api.Invalid: expected an int in the IntCol 'clientID', got 'unicode'> u'0' instead > > i think this is also not correct, here should be done also a kind > of conversion rega

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 01:41:49PM +0200, Ivan Horvath wrote: > >> if you need the code (main.py) i can send you for further process Let me try to guess what is going on. "use_unicode" suggests you use MySQL, and I think you use fromDatabase=True. With this setup mysqlconnection.py constru

Re: [SQLObject] create a row

2006-06-07 Thread Oleg Broytmann
On Wed, Jun 07, 2006 at 12:56:58PM +0200, Ivan Horvath wrote: > maybe i've found a bug. > in my connection string i specify use_unicode=True > > when the system construct the kw dictionary in the > SQLObject._create method in main.py, the column names are > unicode, theref

Re: [SQLObject] create a row

2006-06-07 Thread Ivan Horvath
Dear All, maybe i've found a bug. in my connection string i specify use_unicode=True when the system construct the kw dictionary in the SQLObject._create method in main.py, the column names are unicode, therefore the keywords in kw are also unicode. i've made alread

Re: [SQLObject] create a row

2006-06-06 Thread Ivan Horvath
Dear Lutz, yes, but this is not the case - i guess here is the class definition: class ts_project(SQLObject): class sqlmeta: table="ts_project" idName="proj_id" fromDatabase=True and this is the mysql describe result (it

Re: [SQLObject] create a row

2006-06-06 Thread Lutz Steinborn
Hello Ivan, as I remeber if you use a string type column as id its up to you to insert a new unique id. some thing like this: new_user=ts_user= (username="myunique_name") because SQLObect has no idea how your id logic works. have fun Regards Lutz On Tue, 6 Jun 2006 13:40:17 +0200 Ivan Horva

[SQLObject] create a row

2006-06-06 Thread Ivan Horvath
Dear sqlobject-discuss, finally i was able to download the latest version from svn. the column definition is solved. but i have problem to insert a new row in a table. ts_project(title="project1") command fails with Traceback (most recent call last): File "D:\alco\python\admin\timeshi