[opencms-dev] Problem with SQL server and opencms 5.0

[Ariel Spivakovsky]

I would like to thank both posters who replied to me. My apologies for not replying sooner, but both messages were mistakenly marked as spam.

I tried both suggestions.

The first suggestion from Ansi to delete the sections C_RESOURCES_GET_FILESINFOLDER and C_RESOURCES_GET_SUBFOLDER seems to work well, but I'm left wondering what may be broken.

The second reply from Andy to delete only the lines 
	AND CMS_PROJECTRESOURCES.PROJECT_ID = ?  \
Also works, but all the items in the Administration Offline view appear three times.

If it's only an eyesore I can live with it for a while.

Any way. Thank you both.

Ari



Message: 10
Subject: RE: [opencms-dev] Problem with SQL server and opencms 5.0
Date: Mon, 16 Jun 2003 09:01:12 +0100
From: "Andy Fletcher" <AFletcher at fitchlondon.com>
To: <opencms-dev at opencms.org>
Reply-To: opencms-dev at opencms.org

Actually this is slightly wrong.
You need to delete the lines:

	AND CMS_PROJECTRESOURCES.PROJECT_ID =3D ?  \

from the 2 queries mentioned below from =
com\opencms\file\mssql\query.properties

HTH,
Andy

> -----Original Message-----
> From: ansi [mailto:ansi at 6636.net]
> Sent: 13 June 2003 01:15
> To: opencms-dev at opencms.org
> Subject: Re: [opencms-dev] Problem with SQL server and opencms 5.0
>
>
> some one said:
>
> Hi.
>   It's a bug in CmsDbAccess.
>   Delete the following SQl statement in=20
> com\opencms\file\mssql\query.properties will help you
>   1)C_RESOURCES_GET_FILESINFOLDER
>   2)C_RESOURCES_GET_SUBFOLDER
>=20
> Good Luck!
>=20


Need a new email address that people can remember
Check out the new EudoraMail at
http://www.eudoramail.com