[opencms-dev] Problem with SQL server and opencms 5.0
ariels at eudoramail.com
Tue Jun 24 23:30:02 CEST 2003
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.
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 =
> -----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:
> It's a bug in CmsDbAccess.
> Delete the following SQl statement in=20
> com\opencms\file\mssql\query.properties will help you
> Good Luck!
Need a new email address that people can remember
Check out the new EudoraMail at
More information about the opencms-dev