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

[Anil K Patel]

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: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20030624/5fb13d1c/attachment.zip>