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') > ------------------------------------------------------------------------ > > ------------------------------------------------------------------------------ > 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 > ------------------------------------------------------------------------------ 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
