Re: Problem with date type specifier in a view-class with MySQL

I am not quite sure I understand the scenario.  Seeing the view-class =

slot specification and table schema would certainly help matters, but =

that said I think I can offer some insight.

Its highly probable that a typecase / multimethod somewhere does not =

have the "date" type mapped to the clsql:date type.  The mysql backend =

is the least well developed backend currently (I believe), though it has =

been used successfully.

The easiest suggestion would be to use timestamp, or datetime, which I =

am fairly sure are supported already (by virtue of these being valid =

typenames across a couple database systems).

Other than that you would have to track down where the type mapper is =

and make adjustments.  A quick grep did not immediately point out the =

issue to me though or I would offer more.

You can also try turning on sql debugging =

`(clsql-sys:start-sql-recording)` and see if this helps spot the problem.

Cheers,
Russ Tyndall
Acceleration.net
[email protected]



On 10/07/2014 10:52 AM, Dave Woodward wrote:
> I=92m using clsql to connect to a MySQL database that already exists.
>
> I=92ve created a view class for one of the tables, and it works selecting=
 integer, string and even join types.
>
> However when adding a column of a date type I get the error "Error: Unkno=
wn type specifier: DATE=94 when using select with the view class with the d=
ate type in it.  The select works fine without that type in it.
>
> I=92m using Clozure CL on OS X and used Quicklisp to load clsql.
>
> Any pointer would be appreciated=85 thanks!
>
> Dave
> [email protected]
>
>
>
>
> _______________________________________________
> CLSQL mailing list
> [email protected]
> http://lists.b9.com/cgi-bin/mailman/listinfo/clsql