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

Anil K Patel anil at aditisoft.com
Tue Jun 24 23:36:01 CEST 2003


Ariel,
Attached is the Query file for MSSqL Server,
Use this file, For us this works great.

Still you have Problem, write back, May be I'll be able to help.

Regards

--- Ariel Spivakovsky <ariels at eudoramail.com> wrote:
> 
> 
> 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
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please
> visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev

=====
Regards
Aditisoft LLC
www.aditisoft.com
We provide OpenCMS implementation services
-------------- next part --------------
A non-text attachment was scrubbed...
Name: query.zip
Type: application/zip
Size: 1512 bytes
Desc: query.zip
URL: <http://lists.opencms.org/pipermail/opencms-dev/attachments/20030624/5fb13d1c/attachment.zip>


More information about the opencms-dev mailing list