Re: [CDBI] Connection with a fixed "where" clause.

[prev] [thread] [next] [Date index for 2005/08/22]

>>>>> "Karl" == Karl Moens <Karl.Moens@xxxxx.xxx> writes:

Karl> Is it possible to have a class with a fixed "where" clause?

...

Karl>  (it would be like 
Karl> some sort of "VIEW" on the database, but the version of MySQL I'm using 
Karl> doesn't support VIEWs yet).

I had a similar requirement from $client, where based on an application
value, "cancelled" records were either "included" or "excluded".

I tried to work at it by horsing around with the SQL generation,
and finally just punted, happily to using VIEWs because I was using
a *real* database (postgresql).

You might consider that MySQL is definitely not the optimum choice any
more.

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi