error in insert 'msman88'
-
Error in insert string a = "'msman88'"; Needed to be inserted as 'msman88' Error : Incorrect syntax near 'msman88'. Line 70: cmd_Account.ExecuteNonQuery();
-
Error in insert string a = "'msman88'"; Needed to be inserted as 'msman88' Error : Incorrect syntax near 'msman88'. Line 70: cmd_Account.ExecuteNonQuery();
in SQL single quote's can be used to delimit string literals, so if you need them as part of your data, try one of the following: 1. use SQLParameter, which is always the better option as it prevents SQL Injection vulnerability; 2. or double the single quote(s) inside your data Now why would you want single quotes at the extremes of your data in the first place? Maybe you are misinterpreting some piece of documentation? :)
Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]
Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.
-
Error in insert string a = "'msman88'"; Needed to be inserted as 'msman88' Error : Incorrect syntax near 'msman88'. Line 70: cmd_Account.ExecuteNonQuery();