Re: Hyphen in a column name

I believe passing a string to :column instead of passing a symbol will accomplish this.
________________________________________
From: [email protected] [[email protected]] On Behalf Of Andrea Russo [[email protected]]
Sent: Thursday, April 22, 2010 11:45 AM
To: [email protected]
Subject: [CLSQL] Hyphen in a column name

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
_______________________________________________
CLSQL mailing list
[email protected]
http://lists.b9.com/cgi-bin/mailman/listinfo/clsql


Please Note: Due to Florida's very broad public records law, most written communications to or from College employees regarding College business are public records, available to the public and media upon request. Therefore, this email communication may be subject to public disclosure.

Please consider the environment before printing this email.