Why does SQL Anywhere ignore the @ named parameter?
Israel Lopez
I am using Dapper to query a SQL Anywhere Datasource, and I am getting an error that makes it seem that the "@" prefix for my where clause value is ignored.
Double balance = qb.Query<Double>("select end_balance_amt from QBReportAdminGroup.v_lst_customer where list_ident = @listid", new { listid = ListID }).Single();
Error:
Column '@listid' not found
I have access to that table and my manual query works fine.
select end_balance_amt from QBReportAdminGroup.v_lst_customer where list_ident = '8000000B-1433635931'
Example:
Frédéric
With SQL Anywhere and its .Net data provider (at least Sap.Data.SQLAnywherev4.5), parameters should be prefixed with : instead of @.
This looks to me as being the issue in your case. But I do not know if Dapper is supposed to abstract away such vendor's specific behavior from its users.
So you should try with:
Double balance = qb.Query<Double>(
"select end_balance_amt from QBReportAdminGroup.v_lst_customer where list_ident = :listid",
new { listid = ListID }).Single();
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: PHP collect and combine different data from two tables
- Next: Java replace every Nth specific character (e.g. space) in String
Related
Related Related
- 1
Why does Python requests ignore the verify parameter?
- 2
Why does Swift constructor use named parameter calling?
- 3
Why does Swift constructor use named parameter calling?
- 4
Why does RNGCryptoServiceProvider's constructor ignore its parameter?
- 5
Why does Git ignore these folders?
- 6
Why does FloatToStr ignore ThousandSeparator?
- 7
Why does setInterval() ignore errors?
- 8
Why does GLSL ignore return?
- 9
Why does sudo ignore aliases?
- 10
Why does bash ignore SIGTERM?
- 11
Why Gulp does not ignore the file?
- 12
how does the ignore parameter works in gulp and nodemon?
- 13
how does the ignore parameter works in gulp and nodemon?
- 14
Using React Router the <Redirect /> Does not redirect anywhere, but why?
- 15
Why does strcpy_s not exist anywhere on my system?
- 16
SQL ignore part of WHERE if parameter is null
- 17
SQL: SAP Hana if parameter is null, ignore where
- 18
Sql Server Ignore search on a field if parameter is null
- 19
Why does Sqoop ignore column names when importing data from SQL Database
- 20
Why does Django say there is no module named views?
- 21
Why does AngularJS ignore $scope field change?
- 22
Why does this code ignore the await and proceed anyway?
- 23
Why does make ignore my modifications?
- 24
Why does Git ignore the .vs directory?
- 25
Why does XhtmlTextWriter ignore custom attributes?
- 26
Why does Linq ignore my where clause?
- 27
Why does Yii ignore my .po file?
- 28
Why does my Android transition ignore the TransitionListener?
- 29
Why does expand.grid ignore options?
Comments