This topic is locked

Square brackets in table name MSSQL

9/1/2008 7:17:52 AM
ASPRunner.NET General questions
C
clfreddi@tin.it author

I just dnload your product 2 days ago and testing it. Very good product.

I've found this problem in "update password" function:
It seems not to recognize that square brakets already exists in table name and doubles them...
Error in Query Construction
update set [Pwd] = @Password

where [UID] = @Login and [Pwd] = @OldPassword
Extract of WEB.CONFIG with table name definition.
<?xml version="1.0"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<configuration>

<configSections>

<section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>

</configSections>

<appSettings>
<add key="LoginMethod" value="WITHLOGIN" />

<add key="LoginFrom" value="DB" />

<add key="UserListTable" value="[dbo].[USERS]" />

<add key="FieldUserLogin" value="UID" />

<add key="FieldUserLoginType" value="String" />

<add key="FieldUserPwd" value="Pwd" />

<add key="FieldUserPwdType" value="String" />

<add key="FieldUserEmail" value="UID" />

<add key="FieldUserEmailType" value="String" />

<add key="MailSender" value="clfreddi@tin.it" />
any suggestion ?
Best Regards

Claudio

Sergey Kornilov admin 9/9/2008

Claudio,
please send your project along with SQL Server database script to support@xlinesoft.com for investigation.