Last post May 11, 2009 04:23 AM by BubbleJet
Mar 07, 2009 04:16 PM|Sitesbuilders|LINK
SQL parameter not being passed for ASP>NET TableAdapter.
The Database is a Access .mdb file.
Error in WHERE clause near '@'.
Unable to parse query text.
I cannot set a parameter in the query of the TableAdapter.
Any Idea ?
Mar 13, 2009 05:25 PM|Sitesbuilders|LINK
Mar 13, 2009 05:47 PM|hans_v|LINK
Error in WHERE clause near '@'
Don;t you think it's a good idea to show us your SQL string, in particular the WHERE clause?
Mar 26, 2009 09:53 AM|jasonfp|LINK
I ran into the same problem.
All that is required is a ? to set the parameter.
For example, 'Select * from TableName Where IDField = ?'
Hope this helps you...
May 11, 2009 04:23 AM|BubbleJet|LINK
Hi jasonfp, this has sorted out the issue for me.