| Dennis West |
Below is my code and Stored procedure
Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ')'.
Source Error:
Line 382:
Line 383: myCommandI1.Connection.Open()
Line 384: myCommandI1.ExecuteNonQuery()
Line 385: myCommandI1.Connection.Close()
Line 386:
Source File: E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb Line: 384
Stack Trace:
[SqlException: Line 1: Incorrect syntax near ')'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess) +0
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess) +434
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +23
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +14
Microsoft.VisualBasic.CompilerServices.LateBinding.FastCall(Object o, MethodBase method, ParameterInfo[] Parameters, Object[] args)
Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn)
Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
ASPNetPortal.ModuleSettingsPage.BindData() in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:384
ASPNetPortal.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
Dim insertCmdI1 = "insert into AliasFieldNames(ItemID, ModuleID, AliasName)"Dim myCommandI1 = New SqlCommand(insertCmdI1, myConnection)myCommandI1.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.Int))myCommandI1.Parameters("@ItemID").Value = 1myCommandI1.Parameters.Add(New SqlParameter("@ModuleID", SqlDbType.Int))myCommandI1.Parameters("@ModuleId").Value = moduleIdmyCommandI1.Parameters.Add(New SqlParameter("@AliasName", SqlDbType.NVarChar, 50))myCommandI1.Parameters("@AliasName").Value = "Title"myCommandI1.Connection.Open()myCommandI1.ExecuteNonQuery()myCommandI1.Connection.Close()
CREATE PROCEDURE GetModuleType(@ModuleID AS integer)
AS
SELECT * FROM Modules, ModuleDefinitions
WHERE Modules.ModuleID = @ModuleID AND Modules.ModuleDefID = ModuleDefinitions.ModuleDefID AND ModuleDefinitions.FriendlyName = 'Documents'GO
For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/
Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address
|
|
| |
| |
| James Avery |
Try
CREATE PROCEDURE GetModuleType
@ModuleID int
AS
SELECT *
FROM Modules, ModuleDefinitions
WHERE Modules.ModuleID = @ModuleID AND
Modules.ModuleDefID = ModuleDefinitions.ModuleDefID AND
ModuleDefinitions.FriendlyName = 'Documents'
GO
-----Original Message-----
From: Dennis West [mailto:Click here to reveal e-mail address]
Sent: Friday, July 12, 2002 11:08 PM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] Incorrect syntax near ')'. I cannot find a
missing ')' what could cause this
Below is my code and Stored procedure
Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect
syntax near ')'.
Source Error:
Line 382:
Line 383: myCommandI1.Connection.Open()
Line 384: myCommandI1.ExecuteNonQuery()
Line 385: myCommandI1.Connection.Close()
Line 386:
Source File: E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb
Line: 384
Stack Trace:
[SqlException: Line 1: Incorrect syntax near ')'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
[TargetInvocationException: Exception has been thrown by the target of
an invocation.]
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
+0
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean verifyAccess) +434
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +23
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
+14
Microsoft.VisualBasic.CompilerServices.LateBinding.FastCall(Object o,
MethodBase method, ParameterInfo[] Parameters, Object[] args)
Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Obje
ct o, Type objType, String name, Object[] args, String[] paramnames,
Boolean[] CopyBack, Boolean IgnoreReturn)
Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack)
ASPNetPortal.ModuleSettingsPage.BindData() in
E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:384
ASPNetPortal.ModuleSettingsPage.Page_Load(Object sender, EventArgs e)
in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
Dim insertCmdI1 = "insert into AliasFieldNames(ItemID, ModuleID,
AliasName)"
Dim myCommandI1 = New SqlCommand(insertCmdI1, myConnection)
myCommandI1.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.Int))
myCommandI1.Parameters("@ItemID").Value = 1
myCommandI1.Parameters.Add(New SqlParameter("@ModuleID", SqlDbType.Int))
myCommandI1.Parameters("@ModuleId").Value = moduleId
myCommandI1.Parameters.Add(New SqlParameter("@AliasName",
SqlDbType.NVarChar, 50))
myCommandI1.Parameters("@AliasName").Value = "Title"
myCommandI1.Connection.Open()
myCommandI1.ExecuteNonQuery()
myCommandI1.Connection.Close()
CREATE PROCEDURE GetModuleType
(
@ModuleID AS integer
)
AS
SELECT *
FROM Modules, ModuleDefinitions
WHERE Modules.ModuleID = @ModuleID AND
Modules.ModuleDefID = ModuleDefinitions.ModuleDefID AND
ModuleDefinitions.FriendlyName = 'Documents'
GO
For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/
Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
|
|
| |
|
| |
| Minh Truong |
Your command is not calling your SPROC, instead, it's executing a custom
T-SQL command:
"insert into AliasFieldNames..."
----- Original Message -----
From: "Dennis West" <Click here to reveal e-mail address>
To: "ngfx-sqlclient" <Click here to reveal e-mail address>
Sent: Friday, July 12, 2002 11:07 PM
Subject: [ngfx-sqlclient] Incorrect syntax near ')'. I cannot find a missing
')' what could cause this
Below is my code and Stored procedure
Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect
syntax near ')'.
...
|
|
| |
|
| |
| Iain Smallwood |
I am slightly confused by the message but would have thought you would
want to syntax like:
"insert into AliasFieldNames(ItemID, ModuleID, AliasName) VALUES
(@ItemID, @ModuleID, @AliasName)"
to make your insert work. I am confused about the inference that your sp
is not working when your scripted insert seems to be giving the problem.
-----Original Message-----
From: Dennis West [mailto:Click here to reveal e-mail address]
Sent: 13 July 2002 04:08
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] Incorrect syntax near ')'. I cannot
find a missing ')' what could cause this
Below is my code and Stored procedure
Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the
execution of the current web request. Please review the stack trace for
more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1:
Incorrect syntax near ')'.
Source Error:
Line 382:
Line 383: myCommandI1.Connection.Open()
Line 384: myCommandI1.ExecuteNonQuery()
Line 385: myCommandI1.Connection.Close()
Line 386:
Source File:
E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb Line: 384
Stack Trace:
[SqlException: Line 1: Incorrect syntax near ')'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
[TargetInvocationException: Exception has been thrown by the target of
an invocation.]
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
+0
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj,
BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo
culture, Boolean verifyAccess) +434
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +23
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
+14
Microsoft.VisualBasic.CompilerServices.LateBinding.FastCall(Object o,
MethodBase method, ParameterInfo[] Parameters, Object[] args)
Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Obje
ct o, Type objType, String name, Object[] args, String[] paramnames,
Boolean[] CopyBack, Boolean IgnoreReturn)
Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o,
Type objType, String name, Object[] args, String[] paramnames, Boolean[]
CopyBack)
ASPNetPortal.ModuleSettingsPage.BindData() in
E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:384
ASPNetPortal.ModuleSettingsPage.Page_Load(Object sender, EventArgs e)
in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
Dim insertCmdI1 = "insert into AliasFieldNames(ItemID, ModuleID,
AliasName)"
Dim myCommandI1 = New SqlCommand(insertCmdI1, myConnection)
myCommandI1.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.Int))
myCommandI1.Parameters("@ItemID").Value = 1
myCommandI1.Parameters.Add(New SqlParameter("@ModuleID", SqlDbType.Int))
myCommandI1.Parameters("@ModuleId").Value = moduleId
myCommandI1.Parameters.Add(New SqlParameter("@AliasName",
SqlDbType.NVarChar, 50))
myCommandI1.Parameters("@AliasName").Value = "Title"
myCommandI1.Connection.Open()
myCommandI1.ExecuteNonQuery()
myCommandI1.Connection.Close()
CREATE PROCEDURE GetModuleType
(
@ModuleID AS integer
)
AS
SELECT *
FROM Modules, ModuleDefinitions
WHERE Modules.ModuleID = @ModuleID AND
Modules.ModuleDefID = ModuleDefinitions.ModuleDefID AND
ModuleDefinitions.FriendlyName = 'Documents'
GO
For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/
Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
Disclaimer
This message may contain information which is legally privileged and/or
confidential. If you are not the intended recipient, you are hereby
notified that any unauthorised disclosure, copying, distribution or use
of this information is strictly prohibited. Such notification not
withstanding, any comments or opinions expressed are those of the
originator, not of Taylor Made Computer Solutions, unless otherwise
explicitly stated.
|
|
| |
|
| |
| Dennis West |
MessageI am sorry I found the problem shortly after posting it ( I left half of the insert off when i copied it into my code) I gues i just didn't expect to see the ')' which was the right symptom for the error.
----- Original Message -----
From: Iain Smallwood
To: ngfx-sqlclient
Sent: Monday, July 15, 2002 3:07 AM
Subject: [ngfx-sqlclient] RE: Incorrect syntax near ')'. I cannot find a missing ')' what could cause this
I am slightly confused by the message but would have thought you would want to syntax like:
"insert into AliasFieldNames(ItemID, ModuleID, AliasName) VALUES (@ItemID, @ModuleID, @AliasName)"
to make your insert work. I am confused about the inference that your sp is not working when your scripted insert seems to be giving the problem.
-----Original Message-----
From: Dennis West [mailto:Click here to reveal e-mail address]
Sent: 13 July 2002 04:08
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] Incorrect syntax near ')'. I cannot find a missing ')' what could cause this
Below is my code and Stored procedure
Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near ')'.
Source Error:
Line 382:
Line 383: myCommandI1.Connection.Open()
Line 384: myCommandI1.ExecuteNonQuery()
Line 385: myCommandI1.Connection.Close()
Line 386:
Source File: E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb Line: 384
Stack Trace:
[SqlException: Line 1: Incorrect syntax near ')'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess) +0
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess) +434
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +23
System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +14
Microsoft.VisualBasic.CompilerServices.LateBinding.FastCall(Object o, MethodBase method, ParameterInfo[] Parameters, Object[] args)
Microsoft.VisualBasic.CompilerServices.LateBinding.InternalLateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack, Boolean IgnoreReturn)
Microsoft.VisualBasic.CompilerServices.LateBinding.LateCall(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
ASPNetPortal.ModuleSettingsPage.BindData() in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:384
ASPNetPortal.ModuleSettingsPage.Page_Load(Object sender, EventArgs e) in E:\PortalVBVS\PortalVBVS\admin\ModuleSettings.aspx.vb:67
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()
Dim insertCmdI1 = "insert into AliasFieldNames(ItemID, ModuleID, AliasName)"Dim myCommandI1 = New SqlCommand(insertCmdI1, myConnection) myCommandI1.Parameters.Add(New SqlParameter("@ItemID", SqlDbType.Int))myCommandI1.Parameters("@ItemID").Value = 1myCommandI1.Parameters.Add(New SqlParameter("@ModuleID", SqlDbType.Int))myCommandI1.Parameters("@ModuleId").Value = moduleIdmyCommandI1.Parameters.Add(New SqlParameter("@AliasName", SqlDbType.NVarChar, 50))myCommandI1.Parameters("@AliasName").Value = "Title" myCommandI1.Connection.Open()myCommandI1.ExecuteNonQuery()myCommandI1.Connection.Close()
CREATE PROCEDURE GetModuleType(@ModuleID AS integer)
AS
SELECT * FROM Modules, ModuleDefinitions
WHERE Modules.ModuleID = @ModuleID AND Modules.ModuleDefID = ModuleDefinitions.ModuleDefID AND ModuleDefinitions.FriendlyName = 'Documents'GO
For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/
Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
Disclaimer
This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification not withstanding, any comments or opinions expressed are those of the originator, not of Taylor Made Computer Solutions, unless otherwise explicitly stated.
| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID | http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
|
|
| |
|
|
