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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.