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

[Andy Fletcher]

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

	AND CMS_PROJECTRESOURCES.PROJECT_ID = ?  \

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 
> com\opencms\file\mssql\query.properties will help you
>   1)C_RESOURCES_GET_FILESINFOLDER
>   2)C_RESOURCES_GET_SUBFOLDER
> 
> Good Luck!
> 
> 
> 
> -----Original Message-----
> From: "Ariel Spivakovsky" <ariels at eudoramail.com>
> To: opencms-dev at opencms.org
> Date: Thu, 12 Jun 2003 16:34:53 -0400
> Subject: [opencms-dev] Problem with SQL server and opencms 5.0
> 
> > 
> > 
> > I am running opencms5_rc2 on Linux with a SQL Server DB and 
> Inet driver
> > and it works fine.
> > 
> > When I try to install opencms 5.0 I get errors that look like this:
> > 
> > com.opencms.core.CmsException: 4 Sql exception. Detailed error:
> > [com.opencms.file.mssql.CmsDbAccess] [TDS Driver]Wrong number of
> > parameters. 
> > root cause was java.sql.SQLException: [TDS Driver]Wrong number of
> > parameters 
> > 
> > I found that another user had the same problem using SQL 
> server but a
> > different driver.  
> > Original post:
> > http://mail.opencms.org/pipermail/opencms-dev/2003q2/004504.html
> > 
> > My original problem with version 5_rc2 was importing documentation
> > modules.
> > 
> > Thanks
> > Ari
> > 
> > 
> > 
> > 
> > 
> > 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
> 
> _______________________________________________
> 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
>