johnf wrote: > On Saturday 21 February 2009 08:09:34 am Ricardo Aráoz wrote: > >> def getFields(self, tableName, cursor): >> """ Returns the list of fields of the passed table >> field: ( fieldname, dabo data type, key ) >> """ >> # fairly standard way of getting column settings >> # this may be standard enough to put in the super class >> dbName = self.database >> ---------------------------------> dbName = str(self.database) >> ---------------------------------> tableName = str(tableName) >> >> Or whatever other code that gets dbName and tableName to be strings and >> not unicode. >> Thx >> Ricardo >> > > The problem here is I don't understand why unicode is causing any issues. I > did however send an email to a friend in Germany and asked him to test for > me. It's the weekend so I doubt I'll get answer before Monday. > > But rest assured I have not forgotten about the issue. I'm not using MsSQL > much and I'm not the best person for testing and discovering little (but > important) differences between versions or settings. I could really use help > here - so if there is anyone interested in helping - speak up. > > Ok. I only wanted to stress that doing str(dbName) is safer than using string formatting in sql commands. Using str() solved all my problems related to dbmssql and curosr.execute() understands the dictionary name placing.
Cheers. Ricardo. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
