MySQL Forums
ASP.net, VB, SQLDataSource, delete statement and parameters
Posted by: David Mortimer ()
Date: November 14, 2008 03:35AM
Hi, I migrating an SQL Server app to MySQL 5.0 using the .net 5.2 connector. I have an SQLDatasource control, this has the following DeleteStatement defined:
Delete from customers
where customers.id=@ID
The deleteParameters for the control looks like this:
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
Execution fails with the error
Parameter '@ID' must be defined
Similar Select, Insert and Update statements work fine. All suggestions as to the correct approach gratefully appreciated. A variation on this statement did not work using the ODBC driver, I appreciate I may have a syntax error which I'm blind to!
Delete from customers
where customers.id=@ID
The deleteParameters for the control looks like this:
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
Execution fails with the error
Parameter '@ID' must be defined
Similar Select, Insert and Update statements work fine. All suggestions as to the correct approach gratefully appreciated. A variation on this statement did not work using the ODBC driver, I appreciate I may have a syntax error which I'm blind to!
| Subject | Written By | Posted |
|---|---|---|
| ASP.net, VB, SQLDataSource, delete statement and parameters | David Mortimer | 11/14/2008 03:35AM |
| Re: ASP.net, VB, SQLDataSource, delete statement and parameters | Rogério Chumbinho | 12/04/2008 09:02AM |
Sorry, you can't reply to this topic. It has been closed.
© 1995-2008 MySQL AB, 2008- Sun Microsystems, Inc.