llege Park, MD 20742
>Phone: +1 301-405-9901
>Email: [EMAIL PROTECTED]
>WWWeb: http://www.umiacs.umd.edu/~nedwards
>
>-
>Take Surveys. Earn Cash. Influence the Future of IT
>Join SourceForge.net's Techsay panel an
i've changed mysql table to use NULL as default
afterwhile the insert works
thank you
*** REPLY SEPARATOR ***
On 15/09/2006 at 16:35 Oleg Broytmann wrote:
>On Fri, Sep 15, 2006 at 02:07:32PM +0200, Ivan Horvath wrote:
>> Invalid: expected a datetime in the DateTi
Best regards, Ivan
Horvath Chief Programmer Alcatel ISD PMS 2000 Product
Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209
9546 Fax.: +36 1
209 9599 Mobil: +36
30 257 0235 VOIP:
+49 511 676 478010 [EMAIL PROTECTED] Anyone who
has never made a mistake has never tried
Best regards, Ivan
Horvath Chief Programmer Alcatel ISD PMS 2000 Product
Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209
9546 Fax.: +36 1
209 9599 Mobil: +36
30 257 0235 VOIP:
+49 511 676 478010 [EMAIL PROTECTED] Anyone who
has never made a mistake has never tried
qlobject/mysql/mysqlconnection.py",
>line 94, in _queryInsertID
>self._executeRetry(conn, c, q)
> File
>"/usr/lib/python2.4/site-packages/SQLObject-0.7.1rc1-py2.4.egg/sqlobject/mysql/mysqlconnection.py",
>line 73, in _executeRetry
>myquery = unicode(query
ssHistory.q.datetime ---> descending order
but how can i make a query with more order by fields?
*** REPLY SEPARATOR ***
On 08/09/2006 at 18:40 Oleg Broytmann wrote:
>On Fri, Sep 08, 2006 at 03:58:42PM +0200, Ivan Horvath wrote:
>> SELECT history.username
Best regards, Ivan
Horvath Chief Programmer Alcatel ISD PMS 2000 Product
Team H-1116, Budapest Kondorfa u. 10. Tel.: +36 1 209
9546 Fax.: +36 1
209 9599 Mobil: +36
30 257 0235 VOIP:
+49 511 676 478010 [EMAIL PROTECTED] Anyone who
has never made a mistake has never tried
but my table collation is utf-8.
> >
> > so do you have any solution inserting non ascii characters to a
> > unicode mysql table?
> >
> > Monday, July 10, 2006, 1:00:42 PM, you wrote:
> >
> > NS> Hi,
> >
> > NS> Thanks, but I get t
, 2006, 5:52:49 PM, you wrote:
OB> The following will work too:
OB> MyTable.select(AND(MyTable.q.name == u'value1', MyTable.q.name <>
u'value2'))
OB> MyTable.selectBy(col1=u'value1', col2=u'value1')
OB>The patch is against SVN t
s hard to see iso8859-15 on a koi8-r terminal. :( Let's go guessing and
OB> experimenting.
OB>Do you have any local or global my.cnf that sets an encoding? Does
OB> Unit(code=u'test') work? Does Unit._connection.query("SET NAMES utf-8")
OB> help?
OB> Oleg.
if i want to insert áéí
1/QueryAll: SHOW COLUMNS FROM unit
'\xc3\xa1\xc3\xa9\xc3\xad'
1/QueryIns: INSERT INTO unit (code) VALUES ('áéí')
1/QueryOne: SELECT code FROM unit WHERE id = (31)
Wednesday, August 30, 2006, 2:48:24 PM, you wrote:
OB> On Wed, Aug 30, 2006 at
varchar(10) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
please help me, because i've already spent too many time with many,
many trials without success
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has
Dear Oleg,
sorry, i didn't check it before.
but here is the test_parse.patch
waiting for 0.8 ...
Monday, August 28, 2006, 4:39:03 PM, you wrote:
OB> On Mon, Aug 28, 2006 at 04:00:49PM +0200, Ivan Horvath wrote:
>> i have a password, which contains @ (at)
>&g
Dear sqlobject-discuss,
i have a password, which contains @ (at)
i had a problem parsing connection string.
here is a patch which works for me. please test it, if it is OK,
please include in the next bug fix.
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never
unicode mysql table?
Monday, July 10, 2006, 1:00:42 PM, you wrote:
NS> Hi,
NS> Thanks, but I get the same exception. It seems that the only role of
NS> use_unicode is to force StringCol's to be UnicodeCol's. My columns are
NS> already UnicodeCol's.
NS> Nadav
NS>
eronimo
NS> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
NS> _______
NS> sqlobject-discuss mailing list
NS> sqlobject-discuss@lists.sourceforge.net
NS> https://lists.sourceforge.net/lists/listinfo/sqlobject-
___
MI> sqlobject-discuss mailing list
MI> sqlobject-discuss@lists.sourceforge.net
MI> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
--
Best regards,
Ivan Horvath
Chief Programmer
Alcatel ISD
PMS 2000 Product Team
H-1116, Budapest
Kondorfa u. 10.
Tel.
s back only one row???
if i use list, or tuple for groupBy i receive an sql error
i assume the same syntax should be applied for orderBy. am i right?
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never made a mistake has never tried anything new.
/
charset
as well
SHOW CREATE TABLE also displays information regarding
table character set.
http://dev.mysql.com/doc/refman/5.0/en/charset-show.html
Thursday, June 15, 2006, 6:45:52 PM, you wrote:
OB> On Thu, Jun 15, 2006 at 01:03:22PM +0200, Ivan Horvath wrote:
>>
code character u'\xe9' in position
37: ordinal not in range(128)
that's why i include BlobCol as well.
what do you think?
Wednesday, June 14, 2006, 4:40:21 PM, you wrote:
OB> On Wed, Jun 14, 2006 at 04:23:58PM +0200, Ivan Horvath wrote:
>> yes, but i didn't
ne 14, 2006, 4:15:42 PM, you wrote:
OB> On Wed, Jun 14, 2006 at 03:53:33PM +0200, Ivan Horvath wrote:
>> i've sent you the mysqlconnection.py couple a days ago.
>> a modification was done because if there is a unicode support, the
>> varchar, blob fields value wasn
Dear Oleg,
in the meantime yesterday i was able to patch the
mysqlconnection, therefore it works for varchar columns
but what about with blob columns?
Monday, June 12, 2006, 11:17:31 PM, you wrote:
OB> On Mon, Jun 12, 2006 at 04:28:39PM +0200, Ivan Horvath wrote:
>>
x27; codec can't encode character u'\xf6' in position 7:
ordinal not in range(128)
what is the problem?
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never made a mistake has never tried anything new.
/Albert Einstein/
___
Dear sqlobject-discuss,
what is the correct way to use sql functions in .select() method?
for example: timediff(end_time, start_time) (mysql function)
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never made a mistake has never tried anything new.
/Albert Einstein
_status","enum('Pending','Started','Suspended','Complete')","","","Pending",""
IH> "proj_leader","varchar(32)","","","",""
IH> as yo
nding','Started','Suspended','Complete')","","","Pending",""
"proj_leader","varchar(32)","","","",""
as you see the proj_id is the primary index and it is a
k\sqlobject\main.py", line
1212, in __init__
self._create(id, **kw)
File "c:\python24\lib\site-packages\sqlobject-trunk\sqlobject\main.py", line
1238, in _create
self.set(**kw)
TypeError: set() keywords must be strings
exception.
what does it mean?
--
Best rega
Dear Oleg Broytmann,
thank you
how to upgrade?
i tried the easy_install.exe without getting 0.7.1
Tuesday, June 6, 2006, 11:46:03 AM, you wrote:
OB> On Tue, Jun 06, 2006 at 11:30:02AM +0200, Ivan Horvath wrote:
>> but it makes an assertionerror requesting t
ically get the field definitions
strange is that on another computer the code is working well
(without defining every column)
sqlobject version is 0.7.0 py version is 2.4.2
--
Best regards,
Ivan Horvath
Chief Programmer
Alcatel ISD
PMS 2000 Product Team
H-1116, Budapest
Kondorfa u. 10.
varchar(20) NOT NULL,
name varchar(100) NOT NULL,
is_deleted bool,
descr text,
unit_id int4,
"type" varchar(1) NOT NULL,
dimension varchar(1),
CONSTRAINT plant_unit_pkey PRIMARY KEY (id),
CONSTRAINT plant_unit_code_key UNIQUE (code)
)
WITHOUT OIDS;
ALTER TABLE plant_unit OW
don't want to show to the user the username nor even
the password
Thursday, March 30, 2006, 9:25:47 PM, you wrote:
OB> On Thu, Mar 30, 2006 at 09:10:43PM +0200, Ivan Horvath wrote:
>> during my test i had a connection problem, and i received the
>> following text:
port 5432?
; used connection string 'dbname=PMS user=USERNAME password=PWDXXX
host=172.16.144.43'
is it normal, secure that the system gives you back the username,
and the password???
anyway which component prints this out?
--
Best regards,
Ivan Horvath
Chief Progra
Dear Oleg,
thank you
Thursday, March 30, 2006, 7:19:36 PM, you wrote:
OB> On Thu, Mar 30, 2006 at 06:33:05PM +0200, Ivan Horvath wrote:
>> but when i try Workpackage.byCode(X) it fails
>> is a unicode string
OB>.select()/.selectBy()/.by*() accepts only s
ot unicode
please help me how can i overcome this problem.
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never made a mistake has never tried anything new.
/Albert Einstein/
---
This SF.Net email is sponsored by xPML, a
means for me it is perfect if the tables are in the
public schema.
thank you anyway your kind of support!
Wednesday, March 29, 2006, 3:20:33 PM, you wrote:
OB> On Wed, Mar 29, 2006 at 02:57:15PM +0200, Ivan Horvath wrote:
>> i don't know oracle at all
OB>It wi
don't know what sql i sent to
you is working in sqlobject environment or not.
i don't know also how do you handle bugs, patches, etc.
Wednesday, March 29, 2006, 2:45:25 PM, you wrote:
OB> On Wed, Mar 29, 2006 at 01:52:52PM +0200, Ivan Horvath wrote:
>> shall yo
Dear Oleg,
shall you incorporate in the next bug fix? or leave it as it is?
Wednesday, March 29, 2006, 1:46:43 PM, you wrote:
OB> On Wed, Mar 29, 2006 at 01:33:39PM +0200, Ivan Horvath wrote:
>> i think there is a problem with this sql which intend to find the
>>
ce.oid
and pg_namespace.nspname = 'ps_schema'
AND c.oid = pg_index.indrelid
AND pg_index.indexrelid = c2.oid
AND pg_index.indisprimary
Tuesday, March 28, 2006, 6:21:35 PM, you wrote:
OB> On Tue, Mar 28, 2006 at 06:07:41PM +0200, Ivan Horvath wrote:
>>
n columnsFromSchema
assert primaryKey, "No primary key found in table %r" % tableName
AssertionError: No primary key found in table 'ps_schema.knowladgebase'
Tuesday, March 28, 2006, 4:47:44 PM, you wrote:
OB> On Tue, Mar 28, 2006 at 04:13:52PM +0200, Ivan Horvath wro
nnection=conn
... class sqlmeta:
... table="ps_schema.knowladgebase"
... fromDatabase=True
what is the problem?
i tried also to specify the idName property, without any success
--
Best regards,
Ivan Horvath
Chief Programmer
Anyone who has never made a m
40 matches
Mail list logo
