That's a problem on MySQL's side for not following the ANSI-SQL standard, so my suggestion would go to file a bug report on them for not supporting it instead of making Wt support broken "databases" (really, MySQL is a table storage and not a database engine).
2010/3/20 mobi phil <[email protected]>: > Hello, > > Some changes are needed in the design of Wt::Dbo to make it working > with other backends. > The problem is that sqlite specific syntax is deeply hardcoded, > particulary the quote arround table and collumn names. Mysql does not > like syntax with quote. > > create table "name" ... > > I see too unblocking solutions: > * write complex code to remove the quotes from the sql commands like > create table, on the constructor of the derived MysqlStatement class, > > * or to patch the Wt code by removing tho quotes from the generated > statements. > > * a more complicated and uggly solution would be to provide furthe > virtual functions for SqlStatement for each method that is syntax > dependent, etc. etc. > > I looked at the syntax of sqlite, and they do not require quotes > arround the names. Maybe the quotes would be needed if table or column > name would contain space, but such names with spaces are in my opinion > are bad practice... > > > > > -- > rgrds, > mobi phil > > being mobile, but including technology > http://mobiphil.com > > ------------------------------------------------------------------------------ > Download Intel® Parallel Studio Eval > Try the new software tools for yourself. Speed compiling, find bugs > proactively, and fine-tune applications for parallel performance. > See why Intel Parallel Studio got high marks during beta. > http://p.sf.net/sfu/intel-sw-dev > _______________________________________________ > witty-interest mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/witty-interest > ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ witty-interest mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/witty-interest
