Re: Why isn't LIMIT functionality included in CDBI?

[prev] [thread] [next] [Date index for 2004/05/22]

> Why isn't LIMIT functionality included in CDBI?

LIMIT is not part of the SQL standard. If it's supported anywhere, it should
be in a database-specific module since it's database-specific SQL.

> Perhaps it should be implemented somewhere in Class::DBI::mysql?

There's been some discussion of that and also some discussion of extending
CDBI::AbstractSearch and SQL::Abstract to support LIMIT. Feel free to take a
crack at it. I'm sure other MySQL users would appreciate it.