Hyphen in a column name
Andrea Russo <[email protected]>
| Newsgroups | gmane.lisp.clsql.general |
|---|---|
| Message-ID | <[email protected]> |
Hi, I'm starting to use clsql in one of my project and let me say that I'm really excited about how clsql simplify access to a SQL Database. I'm trying to access an already created database that I can't modify. The only problem I've encountered in doing so, is when I try to access a table which has an hyphen in one of its column names. The CLSQL documentation says that hyphens in lisp symbols will be converted to underscores, but how can I say to CLSQL to not make this conversion? To access the problematic table I also tried to force the column name with the :column option in the def-view-class declaration but I always get the error: Error 1054 / Unknown column 'TBL_DATA.NON_OECD' in 'field list' which clearly indicates that CLSQL is trying to access the "NON_OECD" column which doesn't exists. In fact, the real column name is "NON-OECD". Any help would be really appreciated. Thanks, Andrea. -- Reclama i tuoi diritti digitali, elimina il DRM. Approfondisci su http://www.no1984.org Reclaim your digital rights, eliminate DRM. Learn more at http://www.defectivebydesign.org/what_is_drm