On 11 Jun 2009, at 11:23, jonhattan wrote: > Sam's Lists escribió: >> So I keep humming along on this upgrade of someone else's code from >> old versions of SQLObject and Mysql to the current SQLObject and >> MySQL >> 5... >> >> The current problem is that I have a table with the column name >> 'condition' which apparently is not a reserved word in MySQL 4.0 but >> is a reserved word in 5.0. >> >> When SQLObject translates its stuff to sql it does not put quotes >> around the column names. If it only would everything would work >> fine. >> >> I could rename the column, but the word is used a lot in the program >> in different ways, so it will get confusing to make sure I only >> change >> the right ones . >> >> Is there a way to force SQLObject to quote it properly? >> > you can force the name of the column in the database this way: > > condition = StringCol(dbName='_condition')
Or simply quote it and you do not need to change anything: condition = StringCol(dbName='`condition`') -- Dan ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
