11 Jun 06:39
Quoting reserved column names...
Sam's Lists <samslists <at> gmail.com>
2009-06-11 04:39:40 GMT
2009-06-11 04:39:40 GMT
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?
------------------------------------------------------------------------------ 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 <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
RSS Feed