Great,
Can You create a patch against the current cvs HEAD and
submit it here?
Than somebody at Alkacon can apply it.
BR,
Andras
Marcus Popetz wrote:
> SQL server doesn't use the LIMIT command at the end, it
uses the "top"
> command at the start:
>
>
> So this:
>
> C_PROJECTS_READLAST_BACKUP=
> SELECT
> PUBLISH_TAG,
> PROJECT_ID,
> PROJECT_NAME,
> PROJECT_PUBLISHDATE,
> PROJECT_PUBLISHED_BY,
> PROJECT_PUBLISHED_BY_NAME,
> USER_ID,
> USER_NAME,
> GROUP_ID,
> GROUP_NAME,
> MANAGERGROUP_ID,
> MANAGERGROUP_NAME,
> PROJECT_DESCRIPTION,
> DATE_CREATED,
> PROJECT_TYPE,
> TASK_ID
> FROM
> CMS_BACKUP_PROJECTS
> ORDER BY
> PUBLISH_TAG DESC
> LIMIT ?
>
>
> should be :
>
> C_PROJECTS_READLAST_BACKUP=
> SELECT
> TOP ?
> PUBLISH_TAG,
> PROJECT_ID,
> PROJECT_NAME,
> PROJECT_PUBLISHDATE,
> PROJECT_PUBLISHED_BY,
> PROJECT_PUBLISHED_BY_NAME,
> USER_ID,
> USER_NAME,
> GROUP_ID,
> GROUP_NAME,
> MANAGERGROUP_ID,
> MANAGERGROUP_NAME,
> PROJECT_DESCRIPTION,
> DATE_CREATED,
> PROJECT_TYPE,
> TASK_ID
> FROM
> CMS_BACKUP_PROJECTS
> ORDER BY
> PUBLISH_TAG DESC
>
>
> -mp
_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the
list, please visit
http://lists.opencms.org/mailman/listinfo/opencms-dev
|
