|
-
Jan 3rd, 2007, 03:06 AM
#2
Re: [02/03] URGENT : Strange Problem with SqlParameter in Update Query
It's because you're using the "+" operator, which is addition. Addition means concatenation when both operands are strings but if one is a number then it means numerical addition and the non-numeric operand will be implicitly converted to a number. That conversion is failing in your case, as you'd expect. The "proper" string concatenation operator is "&". That will implicitly convert numbers to strings.
Also, you're using parameters for three values and then you go and use a literal value for the fourth. You should be using a parameter for Mem_Id too.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|