Re: Problem with odbc (pywin32) and unicode

2006-02-07 Thread Frank Millman
Frank Millman wrote: > Hi all > > I am using odbc from pywin32 to connect to MS SQL Server. I am changing > my program from the old (incorrect) style of embedding values in the > SQL command to the new (correct) style of passing the values as > parameters. I have hit a problem. > > The following a

Re: Problem with odbc (pywin32) and unicode

2006-01-28 Thread Frank Millman
Diez B. Roggisch wrote: > > Unicode is one of those grey areas that I know I will have to try to > > understand one day, but I am putting off that day as long as possible! > > I suggest you better start right away instead of stumbling over it all the > time. The most problems in that field don't c

Re: Problem with odbc (pywin32) and unicode

2006-01-27 Thread Diez B. Roggisch
> Unicode is one of those grey areas that I know I will have to try to > understand one day, but I am putting off that day as long as possible! I suggest you better start right away instead of stumbling over it all the time. The most problems in that field don't come from the inherent complexity o

Re: Problem with odbc (pywin32) and unicode

2006-01-27 Thread Frank Millman
Diez B. Roggisch wrote: > Frank Millman wrote: > > > > > This does not work - > > cur.execute("select * from users where userid = ?", [u'frank']) # > > new style > > > > I get the following error - > > OdbcError: Found an insert row that didn't have 1 columns [sic] > > To me it looks as if yo

Re: Problem with odbc (pywin32) and unicode

2006-01-27 Thread Diez B. Roggisch
Frank Millman wrote: > Hi all > > I am using odbc from pywin32 to connect to MS SQL Server. I am changing > my program from the old (incorrect) style of embedding values in the > SQL command to the new (correct) style of passing the values as > parameters. I have hit a problem. > > The following